Desktop productivity for business analysts and programmers

converting 2 separate column to one date format

Accepted Solution Solved
Reply
Super Contributor
Super Contributor
Posts: 318
Accepted Solution

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

 

 

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

 


Accepted Solutions
Solution
‎02-13-2017 01:56 PM
Grand Advisor
Posts: 10,210

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.

View solution in original post


All Replies
Solution
‎02-13-2017 01:56 PM
Grand Advisor
Posts: 10,210

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
Super Contributor
Posts: 318

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"



Grand Advisor
Posts: 17,325

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 

 

 

Grand Advisor
Posts: 10,210

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
Super Contributor
Posts: 318

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
  • 162 views
  • 0 likes
  • 3 in conversation