Desktop productivity for business analysts and programmers

Convert Character variable / string YYYYMM in date

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

Convert Character variable / string YYYYMM in date

[ Edited ]

Hi everybody,

 

I am trying to convert a character variable HAVE (format $6) that contains year and month which are written as yyyymm (e.g. 201801) into a date format (variable WANT), preferably expressed as 01JAN2018.

 

In my Initial variable, the day is missing, so it should always be the first of a given month.

 

How can I do this?

 

I tried the following, but unfortunately it doesn't work:

 

data test1;

set test2;

format WANT date9.;

WANT = Input( HAVE, date9.);

run;

 

 

I would be very happy if somebody could help me. Thank you in advance!

 

Kind regards,

Gloria

 

 

 


Accepted Solutions
Solution
‎03-16-2018 09:03 AM
Super User
Posts: 10,570

Re: Convert Character variable / string YYYYMM in date

data test1;
set test2;
format want date9.;
want = input(have !! "01", yymmdd8.);
run;
---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code

View solution in original post


All Replies
Solution
‎03-16-2018 09:03 AM
Super User
Posts: 10,570

Re: Convert Character variable / string YYYYMM in date

data test1;
set test2;
format want date9.;
want = input(have !! "01", yymmdd8.);
run;
---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
New Contributor
Posts: 2

Re: Convert Character variable / string YYYYMM in date

Posted in reply to KurtBremser
Thank you a lot, it worked out.
☑ This topic is solved.

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

Discussion stats
  • 2 replies
  • 1418 views
  • 1 like
  • 2 in conversation