Hello SAS Supoort Communities,
Looking at obs=14 for the variable additional_signature_date_1='8/25/2011' - This is NOT date9. informat but mmddyy10 informat.
Try this....
data audit.a2011p1;
set audit.a2011p;
date_var = input(additional_signature_date_1,mmddyy10.);
format date_var date9.;
run;
Always check your log, WARNING messages must be there or _ERROR_.
Hope this helps.
Looking at obs=14 for the variable additional_signature_date_1='8/25/2011' - This is NOT date9. informat but mmddyy10 informat.
Try this....
data audit.a2011p1;
set audit.a2011p;
date_var = input(additional_signature_date_1,mmddyy10.);
format date_var date9.;
run;
Always check your log, WARNING messages must be there or _ERROR_.
Hope this helps.
God bless you and your family! Thank you so much! I appreciate it! It worked!
I am not going to download a zip file. Can you post some of the values of the charcter variable? Make sure to check whether the values have leading spaces. For example you could run this data step to print the first 10 non-missing values.
data _null_;
set audit.a2011p;
where not missing(additional_signature_date_1);
put additional_signature_date_1 $quote. ;
if _n_ >= 10 then stop;
run;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.