hi,all
I have a category variable "class" ,I want to create a new variable "NO" which number ariable "class" ,the result as follows:
Thanks a lot!
This would only appear in the log if you did not have your By Statement, which initializes the first. and last. variables.
data have;
input Class Grades;
datalines;
1 367
1 363
1 302
2 349
2 332
2 311
2 311
3 357
3 343
;
data want;
set have;
by class;
if first.Class then No=0;
No+1;
run;
Actually there are some missing with the variable "class" ,so I tried like follows,but the log
notes that variable first.class uninitialized.Any solution? thanks
data want;
set have;
by class;
if Class^=. and first.Class then No=0;
No+1;
run;
This would only appear in the log if you did not have your By Statement, which initializes the first. and last. variables.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: