DATA Step, Macro, Functions and more

date conversion

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 19
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,115

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: 17,912

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,115

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
;
Occasional Contributor
Posts: 19

Re: date conversion

thank you
☑ This topic is solved.

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

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