Hi,
From a given SAS Dataset, how can I fetch last but one record or third record from the last without doing hard coding. I don't want to do hard coding the values as the number of observations keep on changing.
TIA.
Hi @VVDR Using SASHELP.CLASS dataset that has 19 records, here is an illustration-
The comments should make sense to you
/*last but one=numofrecs-1,third=last minus 2 records*/
data want;
/*last but one=numofrecs-1,third=last minus 2 records*/
do _n_= nobs-1, nobs-2;
set sashelp.class nobs=nobs point=_n_;
output;
end;
stop;
run;
Hi @VVDR Using SASHELP.CLASS dataset that has 19 records, here is an illustration-
The comments should make sense to you
/*last but one=numofrecs-1,third=last minus 2 records*/
data want;
/*last but one=numofrecs-1,third=last minus 2 records*/
do _n_= nobs-1, nobs-2;
set sashelp.class nobs=nobs point=_n_;
output;
end;
stop;
run;
Are these assignment questions?
Here one way to get what the question asked for. The code below selects the 3rd last column.
%let n_obs_from_last=3;
data want;
obs=nobs -&n_obs_from_last +1;
if obs>0 then
do;
set sashelp.class nobs=nobs point=obs;
output;
end;
stop;
run;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.