Good afternoon all,
I've been trying for the past couple of days to join two tables, however, I cannot join them because of different data types.
In one table, I have a column 'PERIOD_START_DT' (coming from a datasource that cannot be changed) with a $10. number format which reads '2015-10-25'. The other table has a column 'YrWk' with a date format MMDDYY10. which reads '04/02/2017'.
I need to convert PERIOD_START_DT to MMDDYY10, but I havent had any luck. First I tried chaning the format in the PROC SQL statment, then I moved to try to use a DATA step before a PROC SQL step to format it. Both were equally unsuccessful.
Any recommendations on how to approach this?
Thanks!
data want (drop=_:); set have (rename=(PERIOD_START_DT=_PERIOD_START_DT)); format PERIOD_START_DT MMDDYY10.; PERIOD_START_DT=input(_PERIOD_START_DT,yymmdd10.); run;
Art, CEO, AnalystFinder.com
data want (drop=_:); set have (rename=(PERIOD_START_DT=_PERIOD_START_DT)); format PERIOD_START_DT MMDDYY10.; PERIOD_START_DT=input(_PERIOD_START_DT,yymmdd10.); run;
Art, CEO, AnalystFinder.com
.... THANK YOU SO MUCH.
I thought I had tried that exact same thing but clearly I didnt becasue this worked perfectly!
Thanks again,
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.