Find Every nTh Observation from SAS / BASE , SAS /SQL

*In this particular code we use mod statement here we are finding every 5th observation from our dataset.

like if we have 20 observation in data set "a1" then we will get 4 observation in data set "analysis".

:corollary1:

Using Simle Base SAS (SAS/BASE)

Data analysis;
set a1;
if mod( _n_ ,5)=0;
run;

:Description Of Code:

Data Analysis: means the name of new data set which we are creating in our work library 

set statement: Is used for access the already created dataset

_N_ : this is used for iteration purpose means how many times sas system looped . 

mod :This function is use to find the remainder of the number 

Mod (_n_,5)=0; : here when we take the mod of (_n_,5) then the remainder will be 0(when  _n_  reaches to 5 and divided by 5 then remainder will be 0 )

if mod( _n_ ,5)=0; : means when this code satisfy the if condition mod( _n_ ,5)=0

:Corollary 2:

Using SAS SQL (Proc SQL,SAS/SQL)

Proc SQl;

Create table analysis as

select * from a

where (mod( Monotonic () ,5))=0; 

quit;

 :Description Of Code:

Create table analysis as: means the name of new data set which we are creating in our work library 

select * from a: Is used for access the already created dataset

Monotonic (): this is used for iteration purpose means how many times sas looped same as _N_. 

mod :This function is use to find the remainder of the number 

Mod (  Monotonic ()  ,5)=0; : here when we take the mod of (   Monotonic ()   ,5) then the remainder will be 0(when monotonic() reaches to 5 and divided by 5 then remainder will be 0 )

where mod(   Monotonic ()   ,5)=0; : means when this code satisfy the  where condition 

mod(  Monotonic () ,5)=0