Hello all, I am trying to make three datasets from a macro that uses the macro variable name to make the name of the dataset. My issues arises from needing to make multiple datasets from different output and I want to change the name of the dataset so there are a total of three datasets with three different names.   Here is my code and an example of what I am trying to do: %macro tab1 (var); PROC SORT DATA = main OUT= &var ; BY &var ; RUN; PROC FREQ DATA = &var ; &POPULATION; TABLES strata1 * strata2 * trtp * peoyn / nocol nopercent cmh; by &var; output cmh relrisk out= &var; /*<----- want this dataset to be renamed &var1*/ run; ODS TRACE ON; ODS OUTPUT ParameterEstimates= &var; /*<----- want this dataset to be renamed &var_INT*/ proc logistic data=&var; STRATA strata1 strata2; &POPULATION; class trtpn &var; model peoynn = trtpn &var trtpn*&var; run; ODS TRACE OFF; %mend; %tab1 (variable_a); %tab1 (variable_b);     The product will be six datasets named: (variable_a, variable_a1, variable_a_INT) and (variable_b, variable_b1, variable_b_INT).     Thank you for your help and let me know if youhave any questions,   Best,   Donald ... View more

Hello Eveyrone,   I am trying to satsify the following conditions in my dataset:   If there are multiple ECHO results, pick only the adequate result(s), if all results are inadequate pick one closest to Day 35 If there are multiple adequate results, pick only the one(s) in the prespecified window (Day 32-42) If there are multiple adequate results in the window, and they have the same result (MI, no MI, or Inadequate) pick the one closest to Day 35 If there are multiple adequate results in the window, and they have different results (one MI and one no MI), choose the DVT (but Annemarie thinks this did not happen) And my data looks like this:     SUBJID ECHORES WINDOW 1 No MI 35 2 Inadequate 34 2 No_MI 41 3 Yes 32 3 Yes 34 4 Yes 32 4 Yes 28       I was starting by working on the first condition by trying out a series of do loops: data want; do until(last.usubjid); set test; by usubjid; if first.usubjid then do; if ECHORES = "No MI" or if ECHORES = "MI" THEN DO; if last.usubjid then do; if ECHORES = "INADEQUATE" then delete; end; end; end; end; run; Is using DOW loops the right way to approach this?   Best,   Donald   ... View more

Hello,   I want to sum two columns by treatment and add a new row called "total"  for each treatment into each of the columns that I want summed. I am using SAS 9.4. Here is an example of what I have and what I am trying to do: I was able to add the rows pretty easily using the insert function in SQL:   proc sql; insert into COHORT values (1,"Total", ., ., .) values (2,"Total", ., ., .) values (3,"Total", ., ., .); quit;   TRT_ARM Country Efficacy_endpt Total_event 1 Peru 300 17 1 Spain 48 0 1 Awesomvania 25 8 2 Peru 325 51 2 Spain 46 9 2 Awesomvania 98 5 3 Peru 73 21 3 Spain 45 1 3 Awesomvania 375 30 1 Total . . 2 Total . . 3 Total . .   But I am having some difficulty filling the rows. I want them to look like this:     TRT_ARM Country Efficacy_endpt Total_event 1 Peru 300 17 1 Spain 48 0 1 Awesomvania 25 8 2 Peru 325 51 2 Spain 46 9 2 Awesomvania 98 5 3 Peru 73 21 3 Spain 45 1 3 Awesomvania 375 30 1 Total 373 25 2 Total 469 65 3 Total 493 52     I have tried using the count function in SQL, but that gives me a column for each treatment arm with the sum I want, but it is in its own column.   I also welcome any SUGI papers that you think might help! Thank you!   Donald S. ... View more

Hello everyone,   I am trying to calculate the length and number of interruptions between dates for each subject ID.    Here is the an example of what the data looks like in explorer:   usubjid startdate enddate 12 2009-03-25 2010-10-26 12 2010-10-30 2011-01-30 12 2011-02-15 2011-03-16 13 2010-12-11 2011-01-13 13 2011-04-13 2011-07-30     For each subjectid, I would like to know the total number of interruptions and the total length of each interruptions.      Thanks for your help!   Donald S. ... View more