## converting 2 separate column to one date format

Solved
Super Contributor
Posts: 419

# converting 2 separate column to one date format

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

Accepted Solutions
Solution
‎02-13-2017 01:56 PM
Super User
Posts: 13,913

## Re: converting 2 separate column to one date format

[ Edited ]

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.

All Replies
Solution
‎02-13-2017 01:56 PM
Super User
Posts: 13,913

## Re: converting 2 separate column to one date format

[ Edited ]

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.

Super Contributor
Posts: 419

## Re: converting 2 separate column to one date format

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"

Super User
Posts: 23,980

## Re: converting 2 separate column to one date format

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

Super User
Posts: 13,913

## Re: converting 2 separate column to one date format

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

Super Contributor
Posts: 419

## Re: converting 2 separate column to one date format

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...
☑ This topic is solved.

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

Discussion stats
• 5 replies
• 195 views
• 0 likes
• 3 in conversation