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
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.