topic Re: Combining mm,yy,dd,cc into 1 variable in SAS Programming

Combining mm,yy,dd,cc into 1 variable

sgarg — Thu, 04 Oct 2018 23:49:16 GMT

I need to combine cc , yy, mm, dd numeric variable into 1 variable. mm can be input as 3 so i need to make it 03 first and then merge into one variable.

I need to do this with all variables.

Not sure how to do any help please.

Thanks.

Re: Combining mm,yy,dd,cc into 1 variable

mkeintz — Thu, 04 Oct 2018 23:59:34 GMT

Since they are numeric, not character, variables, it doesn't matter that some mm, some dd, or some yy are single digits (I presume cc is 19 or 20). You'll use numeric operations and numeric function on them.

my_date=mdy(mm,dd,100*cc+yy);

format my_date date9.;

Re: Combining mm,yy,dd,cc into 1 variable

Reeza — Fri, 05 Oct 2018 01:48:50 GMT

@sgarg wrote:

I need to combine cc , yy, mm, dd numeric variable into 1 variable.

OK. What do you want as the output in that variable?

@sgarg wrote:

mm can be input as 3 so i need to make it 03 first and then merge into one variable.

Show what you have and what you need as output, explicitly.

@sgarg wrote:

I need to do this with all variables.

You've indicated three variables, how many variables do you have? What have you tried so far?

Do you instead mean you need to do this for all rows/records or for multiple different day/month/year variables?

Re: Combining mm,yy,dd,cc into 1 variable

sgarg — Fri, 05 Oct 2018 02:07:57 GMT

Thankyou Guys for replay and great help...

I wrote the code like below and it worked. THANKS AGAIN!

ELIG_CERT_EFF_DATE =mdy(mm,dd,100*cc+yy);
format ELIG_CERT_EFF_DATE mmddyyn8.;

Re: Combining mm,yy,dd,cc into 1 variable

Reeza — Fri, 05 Oct 2018 02:33:59 GMT

@sgarg please mark @mkeintz answer as correct, because he posted the correct solution.