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;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: