data mylib.employees_new; set mylib.employees; if IDnum=1001 then Birthdate='01JAN1963'd; else if IDnum=1002 then Birthdate='08AUG1946'd; else if IDnum=1003 then Birthdate='23MAR1950'd; else if IDnum=1004 then Birthdate='17JUN1973'd; run;
data mylib.employees_new; array birthdates{1001:1004} _temporary_ ('01JAN1963'd '08AUG1946'd '23MAR1950'd '17JUN1973'd); set mylib.employees; Birthdate=birthdates{IDnum}; run;
IDnum
),
but does not contain employees' birthdates. You can use a format
to combine employees' birthdates with the data that is stored
in Mylib.Employees.
proc format; value birthdate 1001 = '01JAN1963' 1002 = '08AUG1946' 1003 = '23MAR1950' 1004 = '17JUN1973'; run; data mylib.employees_new; set mylib.employees; Birthdate=input(put(IDnum,birthdate.),date9.); run;
18.118.20.68