topic Assign values to an observation in SAS Procedures

Assign values to an observation

Lani — Thu, 09 Sep 2010 23:18:07 GMT

Hi Everyone,

I have a data set, let say 2000 observations.
I need to assign every hundred obs with a number.
For instance, the first 100 obs get number 1; the second 100 obs get number 2, and so on.
obs-------number
1----------1
2----------1
3----------1
.-----------1
.-----------1
100-------1
101-------2
102-------2
.-------
.-------
.-------
2000-------20

Here is my code:
data test;
retain number;
set test;

nrec=1;
num=1;
if nrec=1 then number=num;
nrec=nrec+1;
if nrec=101 then do;
number=num+1;
nrec=1;
end;

Thank you,
Lani

Re: Assign values to an observation

art297 — Fri, 10 Sep 2010 00:48:54 GMT

Lani,

Are you only trying to accomplish something like?:

data test;
set test;
if mod(_n_,100) eq 1 then number+1;
run;

HTH,
Art

Re: Assign values to an observation

Lani — Fri, 10 Sep 2010 14:02:14 GMT

Hi Art,

Yes, that was what I tried to do. Thanks so much for your help.
Have a GREAT weekend!

Lani