🔒 This topic is solved and locked.
Need further help from the community? Please
sign in and ask a new question.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 08-06-2021 04:30 AM
(1380 views)
Hi
Below is the code and a note from the log file while executing this code.
Why does SAS think first.usubjid is a varible by itself.
Please advise how to get rid of this note from the log file or an alternate to this code.
230 data mh_fin;
231 set mh mh_test4;
232
233 if first.usubjid then MHSEQ=1;
234 else MHSEQ+1;
235
236 run;
NOTE: Variable first.usubjid is uninitialized.
Thank you
1 ACCEPTED SOLUTION
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Hi @bharath86,
Have you tried using a by statement with the variable usubjid after the set statement?
Kind regards,
Amir.
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Hi @bharath86,
Have you tried using a by statement with the variable usubjid after the set statement?
Kind regards,
Amir.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Hey,
Thanks for raising that by statement.
I actually revised the code and changed the variable.
data mh_fin;
set mh mh_test4;
by studyid;
if first.studyid then MHSEQ=1;
else MHSEQ+1;
run;
Thank you that helps.