topic Re: How do I fetch specific record from a given sas dataset in SAS Programming

How do I fetch specific record from a given sas dataset

VVDR — Sun, 14 Jun 2020 00:38:36 GMT

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.

Re: How do I fetch specific record from a given sas dataset

novinosrin — Sun, 14 Jun 2020 01:10:53 GMT

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;

Re: How do I fetch specific record from a given sas dataset

Patrick — Sun, 14 Jun 2020 01:22:20 GMT

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;

Re: How do I fetch specific record from a given sas dataset

Reeza — Sun, 14 Jun 2020 02:14:07 GMT

SAS supports indexing to allow for efficient data retrieval. If you need to extract records by varying criteria you may want to add in some indexes to support your queries.