If one dataset (Test1) and I have variable ‘displaymonth’ with the format DATETIME20.
and
the other dataset (Test2) variable ‘displaymonth’ $8.
How do I go about getting the first dataset (Test1) ‘displaymonth’ to be the same as Test2? So when I merge the 2 they match?
I tried this but doesn't work
Data Test1;
Set Test1;
Applseq=applseq+0;
put displaymonth=$8.;
Run
data test1_int (drop=_displaymonth);
set test1 (rename=(displaymonth=_displaymonth));
displaymonth = put(datepart(_displaymonth),yymmddn8.);
run;
Then use that in your join instead of test1.
Alternatively:
proc sql; create table WANT as select... from TEST1 A full join TEST2 B on A.DISPLAYMONTH=input(B.DISPLAYMONTH,yymmdd8.); quit;
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.