data type conversion

[SASAna]

Hi SAS users,

SAS dataset1 has   a field  clm_date   with  num 8 mmddyy10. format  ( data  Ex : 11/20/2019 )

SAS dataset1 has   a field  claim_FDOS with char10  $10 format. (data EX : 11/20/2019 )

I need help to merge these 2 datasets   by clm_date = claim_FDOS. How to convert the data type and merge them.

Thanks,

Ana 

[ballardw · Accepted solution]

Convert the character using an input:

data want;
    set have;
    newvar=input(claim_fdos,mmddyy10.);
    format newvar mmddyy10.;
run;

You need to provide a few more details on what you mean by "merge".
Best is to provide small examples of both sets AND what the desired result would be.

Typically merging by dates means that there are also other identification items involved because the same date can be associated with many people/activities/claims or what not.

[SASAna]

Thank you. worked very well.