Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to convert char(date) to date to get noumber of months
- Thread starter KH75
- Start date
Well you could use the informat YYMMn. This will set the date value to the first of the month in question.
So in your case May 1, 2013
Here is an example that presumes that your variable with the '20135' value is named mydate.
proc sql;
create table test as
select *, input(mydate, yymmn6.) as mynewdate
from mydataset
;
quit;
I hope that this helps you.
Klaz
So in your case May 1, 2013
Here is an example that presumes that your variable with the '20135' value is named mydate.
proc sql;
create table test as
select *, input(mydate, yymmn6.) as mynewdate
from mydataset
;
quit;
I hope that this helps you.
Klaz
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question