topic Re: data type conversion in SAS Programming

data type conversion

SASAna — Fri, 05 Feb 2021 20:10:02 GMT

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

Re: data type conversion

ballardw — Fri, 05 Feb 2021 20:26:22 GMT

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.

Re: data type conversion

SASAna — Fri, 05 Feb 2021 20:43:52 GMT

Thank you. worked very well.