topic converting 2 separate column to one date format in SAS Enterprise Guide

converting 2 separate column to one date format

woo — Mon, 13 Feb 2017 17:11:03 GMT

i have 2 columns,

var/value/type

month = feb <-- char

day=1 <-- num

i want to convert them into date format like,

var=date

value= 1 Feb 2017 or 02/01/2017

can someone please help...Thank you...

Re: converting 2 separate column to one date format

ballardw — Mon, 13 Feb 2017 18:41:09 GMT

Do you want a character value:

length datechar $ 11.; /* this assumes that month will only ever be 3 characters, it will need to be longer if that is not the case*/

datechar = catx(' ',day,month,'2017'); or possibly catx(' ',day,propcase(month),'2017') depending on how you want capitalization of the month.

or a SAS date value? (if your month is longer than 3 characters or a non-standard abbreviation then extra logic will be needed*/

date = input(catt(day,month,'2017'),date9.);

format date date9.;

If you don't have a year value then you need to provide one explicitly.

Re: converting 2 separate column to one date format

woo — Mon, 13 Feb 2017 17:56:38 GMT

thank you Ballardw,

actually I need sas date value,
when try using this,

date = input(catt(day,month,'2017',date9.));

it says "expecting an arithmetic expression" for "date9." in date= statement pointing to "syntax error"

Re: converting 2 separate column to one date format

Reeza — Mon, 13 Feb 2017 18:37:13 GMT

When building nested functions, testing one at a time.

Your parenthesis is in the wrong location, you're trying to concatenate all values include Date9.

Try moving the parenthesis to after 2017.

You probably want a format applied as well, to display it the way you want

Re: converting 2 separate column to one date format

ballardw — Mon, 13 Feb 2017 18:42:47 GMT

I corrected the code in my post for the SAS date, I didn't see that my first) hadn't been typed.

Re: converting 2 separate column to one date format

woo — Mon, 13 Feb 2017 18:56:06 GMT

Thank you Ballardw,
you are right, after your first comment, I was trying to put 2 parenthesis all the way in end not realizing correct syntax -
perfectly worked fine...