Hi All,
I have a column with all strings in a date format such as
28/08/1969
19/04/1977
26/07/1956
26/06/1992
11/04/1984
data outputdata;
set inputdata ;
newvar = input(dob, mmddyy10.);
format newvar mmddyy10.;
run;
When I use the following code only some of the strings get converted to an actual SAS date.
28/08/1969 .
19/04/1977 .
26/07/1956 .
26/06/1992 .
11/04/1984 11/04/1984
Does anyone know why SAS is converting some of them but not others?
newvar = input(dob, mmddyy10.);
Look very very carefully. This is not the right informat to use with your data. Can you figure out why? The proper informat is ... well, after you identify why that informat isn't correct to use on your data, I leave that to you to figure out the correct informat as a homework assignment.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: