DATA Step, Macro, Functions and more

date conversion

Accepted Solution Solved
Reply
Contributor
Posts: 20
Accepted Solution

date conversion

I have dates coming in as Nov 7, 1948, May 27, 1947 and Feb 13, 1953 - how do i convert these dates into a yymmdd8.?

 

Thank you


Accepted Solutions
Solution
‎11-06-2015 05:29 PM
Trusted Advisor
Posts: 1,117

Re: date conversion

[ Edited ]

What about this:

data test;
length c $12
       d $8;
input c $12.;
d=put(input(c, anydtdte12.), yymmdd8.);
cards;
Nov 7, 1948
May 27, 1947
Feb 13, 1953
;

 Or a bit shorter (if your dates are raw data):

data test;
length d $8;
input c anydtdte12.;
d=put(c, yymmdd8.);
cards;
Nov 7, 1948
May 27, 1947
Feb 13, 1953
;

View solution in original post


All Replies
Super User
Posts: 19,789

Re: date conversion

coming from where?
Frequent Contributor
Posts: 108

Re: date conversion

Please ask question in such a way that we can understand and
help...
Solution
‎11-06-2015 05:29 PM
Trusted Advisor
Posts: 1,117

Re: date conversion

[ Edited ]

What about this:

data test;
length c $12
       d $8;
input c $12.;
d=put(input(c, anydtdte12.), yymmdd8.);
cards;
Nov 7, 1948
May 27, 1947
Feb 13, 1953
;

 Or a bit shorter (if your dates are raw data):

data test;
length d $8;
input c anydtdte12.;
d=put(c, yymmdd8.);
cards;
Nov 7, 1948
May 27, 1947
Feb 13, 1953
;
Contributor
Posts: 20

Re: date conversion

Posted in reply to FreelanceReinhard
thank you
🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 264 views
  • 1 like
  • 4 in conversation