data mydate (keep=ln_no mydate);
set date1;
run;
output is
ln_no mydate
011 09JUN2015:00:00:00.000
I tried using this
newdt = datepart(mydate);
format newdt mmddyy10.
For some reason the newdt turns into a numeric and looses its date datatype.
I want to extract the 09JUN2015 since the datepart function on this particular field does not convert to a date.
For some reason the newdt turns into a numeric and looses its date datatype.
SAS Dates, times and datetimes are stored as numeric variables.
Is your starting variable a numeric variable with a datetime format?
If it's character, DATEPART() will not work. In that case, you can use SCAN instead with the : as the delimiter and then use INPUT to convert it to a SAS date.
It seems that the variable MYDATE is a char type - that is a character string,
then you can read it either by defining its length $9 with informat date9. (neglect the time part)
or if you have it as one char type variable of length $24 then:
datex = scan(mydate,1,':');
date = input(datex,date9.);
format date date9.;
Great info,it worked!!
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
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.