https://communities.sas.com/t5/SAS-Programming/sas-questions-including-merge-macro-convert/m-p/640888#M190972 <P>Could someone help me answer these problems? thank you!</P> <P>&nbsp;</P> <P><STRONG><U>Instructions</U></STRONG>: Please write the SAS code you would use to do each of the following tasks.&nbsp; 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).</P> <OL> <LI>Write a code to import DATA1.csv file to SAS dataset into the library and remove duplicates.</LI> <LI>Write a merge code to keep only the records that are common in both datasets.</LI> <LI>Write a macro to create frequency report for all variables in the combined SAS dataset with rtf destination.</LI> <LI>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.</LI> <LI>Write a format code and apply it to the above categories.</LI> </OL> Fri, 17 Apr 2020 23:19:33 GMT Amy0223 2020-04-17T23:19:33Z https://communities.sas.com/t5/SAS-Programming/sas-questions-including-merge-macro-convert/m-p/640888#M190972 <P>Could someone help me answer these problems? thank you!</P> <P>&nbsp;</P> <P><STRONG><U>Instructions</U></STRONG>: Please write the SAS code you would use to do each of the following tasks.&nbsp; 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).</P> <OL> <LI>Write a code to import DATA1.csv file to SAS dataset into the library and remove duplicates.</LI> <LI>Write a merge code to keep only the records that are common in both datasets.</LI> <LI>Write a macro to create frequency report for all variables in the combined SAS dataset with rtf destination.</LI> <LI>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.</LI> <LI>Write a format code and apply it to the above categories.</LI> </OL> Fri, 17 Apr 2020 23:19:33 GMT https://communities.sas.com/t5/SAS-Programming/sas-questions-including-merge-macro-convert/m-p/640888#M190972 Amy0223 2020-04-17T23:19:33Z https://communities.sas.com/t5/SAS-Programming/sas-questions-including-merge-macro-convert/m-p/640920#M190978 <P>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.</P> <P>&nbsp;</P> Sat, 18 Apr 2020 05:45:31 GMT https://communities.sas.com/t5/SAS-Programming/sas-questions-including-merge-macro-convert/m-p/640920#M190978 Kurt_Bremser 2020-04-18T05:45:31Z