Combining 3 variables into one and converting to date

[AMMAN]

I need to take three numeric variables, combine into one, then convert to a date.  I am using a CATX and am getting a warning I don't understand.

data IncurredDate;
set work.AngieClaims;
date=input(catx("/", Mnth, Date, Year), mmddyy10);
format date mmddyy10;
run;

Log and input file attached. 

Thanks for your help.

[kiranv_]

just use mdy function

data IncurredDate;
set work.AngieClaims;
newdate=mdy( Mnth, Date, Year);
format newdate mmddyy10.;
run;

[AMMAN]

Thanks for the recommendation.  I tried that and got this result.  I don't see the combined variable

[kiranv_]

try making new column name as date and I have updated my answer

[AMMAN]

I dropped some vars to clean it up.  New var shows up, but it empty

data IncurredDate (drop=MOS DOS YOS Mnth Date Year) ;
set work.AngieClaims;
newdate=mdy(Mnth, Date, Year);
format newdate mmddyy10.;
run;

[kiranv_]

see the below example . even if you have data in character values this works albite it gives note in log.(first 2 examples work)

unless some of your does not make date, which cause this issue. check the examples in code below



data want;
mnth = 1;
d = 2;
yr =2016;
newdate=mdy(mnth,d,yr);
format newdate mmddyy10.;
run;

data want1;
mnth = "1";
d = "2";
yr ="2016";
newdate=mdy(mnth,d,yr);
format newdate mmddyy10.;
run;
/* this will not work because there is 13 as month and result in . and you have note in 
log NOTE: Invalid argument to function MDY(13,2,2016) at line 77 column 9.*/
data want3;
mnth = 13;
d = 2;
yr =2016;
newdate=mdy(mnth,d,yr);
format newdate mmddyy10.;
run;

[AMMAN]

Ooof,  I don't understand your feedback.

[kiranv_]

did u run the codes. first 2 work if your month, day and year are allowable then mdy code work. 

[AMMAN]

Thanks for your help.  I was looking at the wrong variable. 

[andreas_lds]

---

@AMMAN wrote:

Ooof,  I don't understand your feedback.

---

Start with reading the log of your program: are there any notes about missing values? The function mdy need three numbers to create a data, if one is missing the result is missing, too. @kiranv_ tried to point to the most likely cause of having missing values: your data.

[AMMAN]

I was confused by the labels.  I couldn't understand why it said I was missing values.  I was looking at the wrong variable.  Thanks for your help!

[Tom]

Because you are still trying to use a variable that doesn't exist for the year number.

[Tom · Accepted solution]

From the picture you posted your MONTH variable is named MNTH, your DAY variable is named DOS and your YEAR variable is named YOS.

So the assignment statement you want would be 

date=mdy(mnth,dos,yos);

It looks like you probably ran this code instead 

date=mdy(mnth,dos,year);

So SAS created a new variable named YEAR that has all missing values. And also made DATE as missing since you did not provide a year value.

[AMMAN]

Thanks for your help!