topic Re: i want a code for below data in SAS Procedures

i want a code for below data

chittamsri1_gmail_com — Mon, 21 Apr 2014 10:43:46 GMT

suppose dataset contains variable 'name'

name

sri

ram

ragu

quest: we want to create another dataset in way that we should create another vaiable 'id' i want to assign values in an order automatically to variable 'id' like for 1st variable 101 ,2nd variable 102 and so on if we have 100 variable values the first 'id' value should be 101 and last 'id' variable should be 200

name id

sri 101

ram 102

ragu 103

a 104

b 105

c 106

d 107

e 108

f 109

g 110

h 111

i 112

j 113

Re: i want a code for below data

Chrishi — Mon, 21 Apr 2014 11:01:49 GMT

Hope this works for the above problem.

data want;

set have;

if _N_=1 then id=101;

else id+1;

run;

Thanks,

Sudeer.

Re: i want a code for below data

Ksharp — Mon, 21 Apr 2014 11:23:47 GMT

Don't understand why would you do that.

data have;

set have;

retain n 100;

n+1;

run;

Re: i want a code for below data

data_null__ — Mon, 21 Apr 2014 11:50:04 GMT

Would it be a good idea to make the ID character? It might help to indicate the purpose and prevent it from being used as a measure.

Re: i want a code for below data

chittamsri1_gmail_com — Tue, 22 Apr 2014 10:17:17 GMT

Thanks for your reply