Hi,
I have a cancer data set and I need to create an X variable (observation count). What's the codings used in this case.
Thanks
SAS has an automatic variable that can be used as an observation counter. This assumes you want a row counter. If you want to count observations by groups or some other method you need to provide more details, preferably sample input and output.
Data want;
Set sashelp.class;
X = _n_;
Run;
Proc print data=want label;
Run;
SAS has an automatic variable that can be used as an observation counter. This assumes you want a row counter. If you want to count observations by groups or some other method you need to provide more details, preferably sample input and output.
Data want;
Set sashelp.class;
X = _n_;
Run;
Proc print data=want label;
Run;
Thank you
Its always a good idea to post test data (in the form of a datastep), and what the output should look like. We can only work with what you post here. Do you mean you want an equivalent to the SAS automatic variable _n_ or a total observations?
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.