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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.