To create a SAS date value where the Date9 or any other date format will apply correctly, you need a day, month and year value. What day and month do you expect to have in the result when only a year , apparently, is supplied? Are the year only values always provided as 4 digits? Do you have any other layouts for that character date value? We may need to see more to get code that works more completely.   This provides an example of how to read those two values into dates. You get to pick the month and day to use as the default for the MDY function that turns numeric month, day and year into a date. I used January 1 for the example. data example; input BRTHDTC :$15.; if length(BRTHDTC)=4 then brthdt = mdy(1,1, input(BRTHDTC,4.)); else brthdt=input(BRTHDTC,yymmdd10.); format brthdt date9.; datalines; 1988-02-23 1973 ; ... View more

Just use a little arithmetic to figure out where each ARMCD starts. data have; input usubjid armcd :$30. arm :$300.; datalines; 7959011 GPRTNKYKNSLWPCJEHGKG ACCUVE1\ACCUVE2\ACCUVE3\ACCUVE4\ACCUVE5\ACCUVE6\ACCUVE7\ACCUVE8\ACCUVE9\ACCUVE10 ; data want; set have(rename=(armcd=armcd_string arm=arm_string)); length ARMCD $2 ARM $20; do index=1 to 10 ; ARMCD=substr(armcd_string,2*(index-1)+1,2); ARM=scan(arm_string,index,'\'); output; end; drop armcd_string arm_string; run; Obs usubjid ARMCD ARM index 1 7959011 GP ACCUVE1 1 2 7959011 RT ACCUVE2 2 3 7959011 NK ACCUVE3 3 4 7959011 YK ACCUVE4 4 5 7959011 NS ACCUVE5 5 6 7959011 LW ACCUVE6 6 7 7959011 PC ACCUVE7 7 8 7959011 JE ACCUVE8 8 9 7959011 HG ACCUVE9 9 10 7959011 KG ACCUVE10 10 ... View more