topic Re: SAS dataset gets reduced after code gets executed in New SAS User

SAS dataset gets reduced after code gets executed

adrfinance — Thu, 21 Nov 2019 13:43:35 GMT

I have a dataset which initially has more than 8000 rows.

Then when I execute the following SAS code:

rsubmit;
data have2;
set initial_dataset;
/* Since beginning is always equal to 1, I don't use it here in my code */
if /* beginning=1 and */ end=2 then flag=1;
else flag=0;
run;
endrsubmit;

the resulting dataset (have2) only has 10 rows. Why is this the case and how can I fix it?

Re: SAS dataset gets reduced after code gets executed

PeterClemmensen — Thu, 21 Nov 2019 13:45:21 GMT

Can you post the log please? There is nothing in your code that subsets the number of observations.

Re: SAS dataset gets reduced after code gets executed

Astounding — Thu, 21 Nov 2019 13:54:31 GMT

This could happen if this statement appears anywhere within your code:

options obs=10;

Much less likely, this would cause similar trouble:

options firstobs=7991;

Other than that, we are left with the possibility of investigating the data further to find out if the incoming data set really contains 8000 observations.