Hi, I've to import a database table into a SAS table but I want one of the columns being imported which represents the time period to be converted from a character to a SAs date column.
The orginal period column is in character format as, for example, YYYY-MM-DD (such as 2013-09-01) but I would like it to be in the format 01SEP2013 as a SAs date column. Here is my code:
/* This step imports a file from the DW into a library called current on the C drive */
data current.dos_data;
set mysqlsvr.dos_date_of_supply;
format period default=DATE9.;
informat period default=DATE9.;
run;
data have; input period $10.; cards; 2013-09-01 ; data want (drop=_:); set have (rename=(period=_period)); format period date9.; date=input(_period,yymmdd10.); run;
Art, CEO, AnalystFinder.com
data have; input period $10.; cards; 2013-09-01 ; data want (drop=_:); set have (rename=(period=_period)); format period date9.; date=input(_period,yymmdd10.); run;
Art, CEO, AnalystFinder.com
Thank you
You can do it on the fly
data CURRENT.DOS_DATA;
set MYSQLSVR.DOS_DATE_OF_SUPPLY(rename=(PERIOD=PERIODC));
format PERIOD date9.;
PERIOD=input(PERIODC,yymmdd10.);
run;
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.