sas questions including merge, macro, convert

[Amy0223]

Could someone help me answer these problems? thank you!

Instructions: Please write the SAS code you would use to do each of the following tasks.  The library name should be ONE, the datasets should be named DATA1 (with variables ID, AGE, GENDER, and SMOKE) and DATA2 (with variables REDCAP_ID, Q1, Q2, and Q3).

1. Write a code to import DATA1.csv file to SAS dataset into the library and remove duplicates.
2. Write a merge code to keep only the records that are common in both datasets.
3. Write a macro to create frequency report for all variables in the combined SAS dataset with rtf destination.
4. Write a code to convert the variable AGE, which is currently a character variable, to numeric and recode to create age categories 0-20, 21-40, 41-60, 61-80, and 81-100.
5. Write a format code and apply it to the above categories.

[Kurt_Bremser]

What have you done so far? Show your code and logs, show some example data, tell us where the results don't meet your expectations.