130.INPUT | FORMAT FOR RAW DATA | RETAIN | LABEL STATEMENTS FOR SDTM DATA

INPUT | FORMAT FOR RAW DATA | RETAIN | LABEL STATEMENTS FOR SDTM DATA

/*Convert this into an SDTM DM dataset with variables USUBJID, BRTHDTC, SEX, TRT01A.*/

/*Derive AGE from DOB using INTCK function.*/

DATA RAWDM;

 INPUT SUBJID DOB:YYMMDD10. SEX$ TRT$;

 FORMAT DOB DATE9.;

 CARDS;

001 1980-05-10 M Placebo

002 1975-08-20 F Drug_A

;

RUN;

PROC PRINT;RUN;

OUTPUT:

Obs	SUBJID	DOB	SEX	TRT
1	1	10MAY1980	M	Placebo
2	2	20AUG1975	F	Drug_A

DATA DM;

 RETAIN USUBJID BRTHDTC SEX TRT01A;

 SET RAWDM;

 LABEL SUBJID = 'SUBJECT IDENTITY' 

          DOB = 'DATE OF BIRTH'

          SEX = 'SEX'

          TRT = 'TREATMENT';

 USUBJID=PUT(SUBJID,Z3.);

 BRTHDTC=PUT(DOB,YYMMDD10.);

 TRT01A =TRT;

 AGE    =INTCK('YEAR',DOB,'11MAR2025'D);

 KEEP USUBJID BRTHDTC TRT01A SEX AGE;

RUN;

PROC PRINT;RUN;

OUTPUT:

Obs	USUBJID	BRTHDTC	SEX	TRT01A	AGE
1	001	1980-05-10	M	Placebo	45
2	002	1975-08-20	F	Drug_A	50

PRACTICE AND COMMENT YOUR CODE: 

-->PLEASE FOLLOW OUR BLOG FOR MORE UPDATES.

TO FOLLOW OUR TELEGRAM CHANNEL CLICK HERE