Hello everyone,  I am working to improve my knowledge of macro usage. My question is, is it possible to perform the same data step on three different datasets at one time using a macro as opposed to writing out the data step three different times. I know I can combine the datasets and perform the data step only once but I would like to explore macro options. My sample data is as follows:    data fruit_1; length FRUIT $10.; input FRUIT $ TOTAL; datalines; Orange 2 Grape 31 Strawberry 5 ; run;   data fruit_2; length FRUIT $10.; input FRUIT $ TOTAL; datalines; Cherry 20 Lemon 15 Pineapple 4 ; run;   data fruit_3; length FRUIT $10.; input FRUIT $ TOTAL; datalines; Apricot 12 Plum 5 Kiwi 16 ; run;   I would like to run a datastep like below on all of the above datasets without having to rewrite the datastep two additional times.    data fruit_1; set fruit_1; if total ge 5 then OVER = 1; else OVER = 0; run;   ... View more

Please forgive me, I have been trying to figure this out for sometime now and I have read the various solutions related to my question, in this forum, but I am still unable to come up with a solution.    My problem is I have a dataset like below (also attached) with hundreds of observations.    Ft.Belvoir, VA Annapolis NHC, MD  Camp Pendleton NH, CA    What I would like to do is keep just the name part and add the word location in the front. I would like to end up with:   Location Ft. Belvoir  Location Annapolis Location Camp Pendleton    Could someone assist me with this please?  ... View more

I have the following dataset below:  ID DATE AGE YEAR max_age 1 5/31/2002 21 2002 21 1 10/31/2003 24 2003 24 1 5/31/2003 24 2003 24 1 12/31/2003 24 2003 24 1 8/31/2003 24 2003 24 1 3/31/2003 24 2003 24 1 1/31/2003 23 2003 24 1 7/31/2003 24 2003 24 2 7/31/2004 33 2004 33 2 5/31/2004 33 2004 33 2 1/31/2004 33 2004 33   The max_age variable is the max_age by id per year and was created using the  code below:  proc sql; create table max_age as select*, max(age)as max_age from age2 group by ID, year; quit;   I need assistance with the next step I would like my output to have one observation per id per year. My output should like below. Any assistance would be greatly appreciated.    ID DATE AGE YEAR MAX_AGE 1 5/31/2002 21 2002 21 1 12/31/2003 24 2003 24 2 7/31/2004 33 2004 33 ... View more

I have the following data (excel file attached as well).  FRUIT  MONTH  YEAR  TOTAL ORANGE 1 2018 5 ORANGE 2 2018 10 ORANGE 3 2018 15 APPLE 1 2018 4 APPLE 2 2018 8 APPLE 3 2018 12   I would like to know how I can get a total for each month for oranges and apples combined. For example, for month 1 the total would be 9 for both oranges and apples. I would also like the table to look like below:  FRUIT  MONTH  YEAR  TOTAL ORANGE 1 2018 5 ORANGE 2 2018 10 ORANGE 3 2018 15 APPLE 1 2018 4 APPLE 2 2018 8 APPLE 3 2018 12 BOTH  1 2018 9 BOTH  2 2018 18 BOTH  3 2018 33   Could someone please assist me with this please?  ... View more

  I have two data sets (data below) and I am trying to merge the data together using proc sql code below. When I merge the two tables I get all of the dates from Id 3 and only the review dates for ID 1 and 2. I have tried to join the two tables using left, right, inner and full join and it seems as if I am getting the same results. What I would like to do is merge by ID and keep all of the dates for each ID. Can someone assist me with this please?   data test1; infile datalines delimiter = ','; input ID START:mmddyy10. REVIEWCOMPLETE: mmddyy10. HEALTHDATE:mmddyy10. HEALTHDATEEND:mmddyy10. END: mmddyy10. CERTIFYDATE: mmddyy10.; format START REVIEWCOMPLETE HEALTHDATE HEALTHDATEEND END CERTIFYDATE mmddyy10. ; datalines; 1, , , , , , , 2, , , , , , , 3,01/16/2019, 01/23/2019, 01/26/2019, 01/26/2019, 01/26/2019,01/26/2019, ; Run;   data test2; infile datalines delimiter = ','; input ID START:mmddyy10. REVIEW:mmddyy10. REVIEWCOMPLETE: mmddyy10. HEALTHDATE:mmddyy10. HEALTHDATEEND:mmddyy10. END: mmddyy10. CERTIFYDATE: mmddyy10.; format START REVIEW REVIEWCOMPLETE HEALTHDATE HEALTHDATEEND END CERTIFYDATE mmddyy10. ; datalines; 1,01/17/2020,01/29/2020,01/30/2020, , , , , 2,01/10/2020,01/24/2020, , , , , , 3, , , , , , , , ; Run; proc sql; create table table3 as select * from test1 as a inner join test2 as b on a.id = b.id; quit; ... View more

Hello everyone,   I was wondering if I could get some assistance and to be honest I don't really know where to start. I have data like below and what I would like to determine is the last stage an individual completed. The stages should be completed in order from start to end and no individual in my data should have an end date because no one has completed the process.   In some instances, individuals have dates that occur out of order for example id 001, 002, 004 etc. and I do not want to exclude those individuals but maybe use a different flag variable to identify those people.   What I would like to do is create a flag for where the person stopped. So for instance, id 007 made it through to review complete but did not make it to health date. Therefore, the last stage that person completed was review complete. I would flag that person as being stopped at review complete. The overall goal is to get a count of how many people got stopped in each stage. Any help would be greatly appreciated.   ID Start Review Review Complete Health date Health date end End 001 10/11/2019 . . 10/24/2019 10/24/2019 . 002 11/14/2019 . . 11/15/2019 11/15/2019 . 003 10/24/2019 10/29/2019 10/29/2019 11/20/2019 11/20/2019 . 004 01/08/2019 . . 02/19/2019 . . 005 08/16/2019 08/16/2019 09/27/2019 09/20/2019 09/20/2019 . 006 02/11/2019 . . . . . 007 02/12/2019 02/13/2019 02/13/2019 . . .   ... View more