Hi,
I have a character variable that has a date string in it, so its not a real date variable but I need to change it to one. The values look like this.
Apr-01-2015
Apr-05-2015
Mar-05-2015
May-10-2015
I have been trying various of syntax and functions but I haven't been able to figure-out the right combination. This is what I have so far:
order_date_new2= input(compress(order_date,'-'), yymmdd8.);
Any help is appreciated!
Hi,
The syntax that you have use is almost OK. The format yymmdd, as far as I know, need First the year, then month and last Day, if you have dates in that format, I'm sure that is better ways to do it, but I will use Date9
date_real=input(scan(order_date,2,'-')||scan(order_date,1,'-')||scan(order_date,3,'-'),date9.);
Hi,
The syntax that you have use is almost OK. The format yymmdd, as far as I know, need First the year, then month and last Day, if you have dates in that format, I'm sure that is better ways to do it, but I will use Date9
date_real=input(scan(order_date,2,'-')||scan(order_date,1,'-')||scan(order_date,3,'-'),date9.);
Perfect. Thanks!
There is an INFORMAT that will work too. Remember to RTM.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.