01-09-2018 01:16 PM
AFAIK, there is no descending() function in SAS, but there is a descending option for the by statement: http://documentation.sas.com/?docsetId=lestmtsref&docsetTarget=p0yeyftk8ftuckn1o5qzy53284gz.htm&docs...
01-09-2018 01:41 PM
If you mean to read a dataset in reverse order, backwards from the end, here is one way:
data ssalc; set sashelp.class(obs=1) nobs=nobs; do i = nobs to 1 by -1; set sashelp.class point=i; output; end; drop i; run;
01-09-2018 03:02 PM - edited 01-09-2018 03:51 PM
Since NOBS=NOBS is taken care of at compile time, here is an alternative to @PGStats code.
data ssalc(drop=i); do i = nobs to 1 by -1; set sashelp.class point=i nobs=nobs; output; end; stop; run;
01-09-2018 03:47 PM
Test it! I did.
It will work because it will hit the obs=1 limit after the first iteration. It's just another way to avoid an infinite loop.