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
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.
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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: