topic Re: Create observation count variable - X in SAS Programming

Create observation count variable - X

mayasak — Wed, 11 May 2016 03:52:08 GMT

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

Re: Create observation count variable - X

Reeza — Wed, 11 May 2016 03:54:21 GMT

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;

Re: Create observation count variable - X

RW9 — Wed, 11 May 2016 08:07:55 GMT

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?

Re: Create observation count variable - X

mayasak — Wed, 11 May 2016 14:09:00 GMT

Thank you