topic Re: Help with sas code in SAS Programming

Help with sas code

rashmirao99 — Tue, 05 May 2020 16:06:01 GMT

Hi I have data like this:

Subjid visitdt kitno

201-001 2019-08-21 1001

201-001

210-001 2019-09-21 1003

I need to create another column called ecref and the result should look like this:

Subjid visitdt kitno ecref

201-001 2019-08-21 1001 1001

201-001 1001

210-001 2019-09-21 1003 1003

Thanks.

Re: Help with sas code

PaigeMiller — Tue, 05 May 2020 16:21:04 GMT

Please provide a meaningful title that describes the problem. A title like "Help with SAS code" applies to almost every problem.

Re: Help with sas code

biopharma — Tue, 05 May 2020 16:37:36 GMT

Agree with the other poster that you have to provide a meaningful description of your problem. Look up the documentation for RETAIN. Then take care to reset ECREF to a missing value for each SUBJID. You do have your data already sorted correctly by SUBJID and another ID field like a record number or a sequence number within each subject, right? So something along the lines as below should work (UNTESTED).

data want ;

set have ;

by subjid ;

retain ecref ;

if first.subjid then ecref = . ;

if not missing(kitno) then ecref = kitno ;

run ;

Re: Help with sas code

Sathish_jammy — Tue, 05 May 2020 16:56:14 GMT

Use the below code.

data want;
set have;
by Subjid;
retain ecref;
if kitno ne . then ecref = kitno;
run;