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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.