Please help, I created a permanent dataset with 454,243 observations.
I used this to create a tempory dataset with a simple set statement, no conditions or clauses or anything... and the tempory dataset had only 444,244 observations! Less 9,999. This happened in SAS EG, so I wanted to try this in PC SAS....
I opened the permanent dataset in PC SAS and found it to have 464,242 observations!!! Plus 9,999 compared with the original!!!
Then the tempory dataset which I created had the same number (464,242), which restores my faith in the "set" statement!!!
What is happening? I am not new to SAS and have never experienced this before. My collegues are also bewildered. They checked my code and agree it seems fine!!
Look at SAS(R) 9.2 Language Reference: Dictionary, Fourth Edition
You may have an option set that reduces your number of observations with every step. (FIRSTOBS=10000)
Look at SAS(R) 9.2 Language Reference: Dictionary, Fourth Edition
You may have an option set that reduces your number of observations with every step. (FIRSTOBS=10000)
Thanks!
You're right I was using that option earlier to check my code on a sample dataset!
So grateful, thanks
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.