1676 %macro bysex(var,n, name); 1677 proc univariate data=work1; 1678 class y1p_G_GIRL; 1679 var &var; 1680 histogram &var / nrows=2 outhist=OutHist&n 1681 odstitle="&name by Gender"; 1682 ods select histogram; 1683 run; 1684 1685 data work.butterflysex&name; 1686 keep &var Males Females; 1687 label Males = Females = y1pi_VT = ; 1688 merge OutHist&n(where = (y1p_G_GIRL = 1) rename = (_COUNT_ = Females _MIDPT_ = &var)) 1689 OutHist&n(where = (y1p_G_GIRL = 0) rename = (_COUNT_ = Males _MIDPT_ = &var)); 1690 by &var; 1691 Males = -Males; 1692 run; 1693 1694 ods graphics / reset; 1695 title "Butterfly Plot of &name Counts By Gender"; 1696 proc sgplot data=work.butterflysex&name; 1697 format Males Females positive.; 1698 hbar &var / response=Males legendlabel="Males"; 1699 hbar &var / response=Females legendlabel="Females"; 1700 xaxis label="Count" grid 1701 min=-150 max=150 values=(-150 to 150 by 10) valueshint; 1702 yaxis label="&name" discreteorder=data; 1703 run; 1704 1705 %mend bysex; 1706 OPTIONS MPRINT; 1707 %bysex(y1pi_VT, 1,VT) MPRINT(BYSEX): proc univariate data=work1; MPRINT(BYSEX): class y1p_G_GIRL; MPRINT(BYSEX): var y1pi_VT; MPRINT(BYSEX): histogram y1pi_VT / nrows=2 outhist=OutHist1 odstitle="VT by Gender"; MPRINT(BYSEX): ods select histogram; MPRINT(BYSEX): run; NOTE: The data set WORK.OUTHIST1 has 17 observations and 5 variables. NOTE: PROCEDURE UNIVARIATE used (Total process time): real time 1.16 seconds cpu time 0.32 seconds MPRINT(BYSEX): data work.butterflysexVT; MPRINT(BYSEX): keep y1pi_VT Males Females; MPRINT(BYSEX): label Males = Females = y1pi_VT = ; MPRINT(BYSEX): merge OutHist1(where = (y1p_G_GIRL = 1) rename = (_COUNT_ = Females _MIDPT_ = y1pi_VT)) OutHist1(where = (y1p_G_GIRL = 0) rename = (_COUNT_ = Males _MIDPT_ = y1pi_VT)); MPRINT(BYSEX): by y1pi_VT; MPRINT(BYSEX): Males = -Males; MPRINT(BYSEX): run; NOTE: There were 7 observations read from the data set WORK.OUTHIST1. WHERE y1p_G_GIRL=1; NOTE: There were 10 observations read from the data set WORK.OUTHIST1. WHERE y1p_G_GIRL=0; NOTE: The data set WORK.BUTTERFLYSEXVT has 10 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.01 seconds MPRINT(BYSEX): ods graphics / reset; MPRINT(BYSEX): title "Butterfly Plot of VT Counts By Gender"; MPRINT(BYSEX): proc sgplot data=work.butterflysexVT; MPRINT(BYSEX): format Males Females positive.; MPRINT(BYSEX): hbar y1pi_VT / response=Males legendlabel="Males"; MPRINT(BYSEX): hbar y1pi_VT / response=Females legendlabel="Females"; MPRINT(BYSEX): xaxis label="Count" grid min=-150 max=150 values=(-150 to 150 by 10) valueshint; MPRINT(BYSEX): yaxis label="VT" discreteorder=data; MPRINT(BYSEX): run; NOTE: Since no format is assigned, the numeric category variable will use the default of BEST6. NOTE: PROCEDURE SGPLOT used (Total process time): real time 0.47 seconds cpu time 0.09 seconds NOTE: Some of the tick values have been thinned. NOTE: There were 10 observations read from the data set WORK.BUTTERFLYSEXVT. 1708 %bysex(y1pi_R5Hz, 2,R5Hz) MPRINT(BYSEX): proc univariate data=work1; MPRINT(BYSEX): class y1p_G_GIRL; MPRINT(BYSEX): var y1pi_R5Hz; MPRINT(BYSEX): histogram y1pi_R5Hz / nrows=2 outhist=OutHist2 odstitle="R5Hz by Gender"; MPRINT(BYSEX): ods select histogram; MPRINT(BYSEX): run; NOTE: The data set WORK.OUTHIST2 has 22 observations and 5 variables. NOTE: PROCEDURE UNIVARIATE used (Total process time): real time 0.55 seconds cpu time 0.31 seconds MPRINT(BYSEX): data work.butterflysexR5Hz; MPRINT(BYSEX): keep y1pi_R5Hz Males Females; MPRINT(BYSEX): label Males = Females = y1pi_VT = ; MPRINT(BYSEX): merge OutHist2(where = (y1p_G_GIRL = 1) rename = (_COUNT_ = Females _MIDPT_ = y1pi_R5Hz)) OutHist2(where = (y1p_G_GIRL = 0) rename = (_COUNT_ = Males _MIDPT_ = y1pi_R5Hz)); MPRINT(BYSEX): by y1pi_R5Hz; MPRINT(BYSEX): Males = -Males; MPRINT(BYSEX): run; NOTE: Variable y1pi_VT is uninitialized. NOTE: There were 11 observations read from the data set WORK.OUTHIST2. WHERE y1p_G_GIRL=1; NOTE: There were 11 observations read from the data set WORK.OUTHIST2. WHERE y1p_G_GIRL=0; NOTE: The data set WORK.BUTTERFLYSEXR5HZ has 11 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.03 seconds MPRINT(BYSEX): ods graphics / reset; MPRINT(BYSEX): title "Butterfly Plot of R5Hz Counts By Gender"; MPRINT(BYSEX): proc sgplot data=work.butterflysexR5Hz; MPRINT(BYSEX): format Males Females positive.; MPRINT(BYSEX): hbar y1pi_R5Hz / response=Males legendlabel="Males"; MPRINT(BYSEX): hbar y1pi_R5Hz / response=Females legendlabel="Females"; MPRINT(BYSEX): xaxis label="Count" grid min=-150 max=150 values=(-150 to 150 by 10) valueshint; MPRINT(BYSEX): yaxis label="R5Hz" discreteorder=data; MPRINT(BYSEX): run; NOTE: Since no format is assigned, the numeric category variable will use the default of BEST6. NOTE: PROCEDURE SGPLOT used (Total process time): real time 0.52 seconds cpu time 0.06 seconds NOTE: Some of the tick values have been thinned. NOTE: There were 11 observations read from the data set WORK.BUTTERFLYSEXR5HZ. 1709 %bysex(y1pi_R10Hz, 3,R10Hz) MPRINT(BYSEX): proc univariate data=work1; MPRINT(BYSEX): class y1p_G_GIRL; MPRINT(BYSEX): var y1pi_R10Hz; MPRINT(BYSEX): histogram y1pi_R10Hz / nrows=2 outhist=OutHist3 odstitle="R10Hz by Gender"; MPRINT(BYSEX): ods select histogram; MPRINT(BYSEX): run; NOTE: The data set WORK.OUTHIST3 has 21 observations and 5 variables. NOTE: PROCEDURE UNIVARIATE used (Total process time): real time 0.77 seconds cpu time 0.32 seconds MPRINT(BYSEX): data work.butterflysexR10Hz; MPRINT(BYSEX): keep y1pi_R10Hz Males Females; MPRINT(BYSEX): label Males = Females = y1pi_VT = ; MPRINT(BYSEX): merge OutHist3(where = (y1p_G_GIRL = 1) rename = (_COUNT_ = Females _MIDPT_ = y1pi_R10Hz)) OutHist3(where = (y1p_G_GIRL = 0) rename = (_COUNT_ = Males _MIDPT_ = y1pi_R10Hz)); MPRINT(BYSEX): by y1pi_R10Hz; MPRINT(BYSEX): Males = -Males; MPRINT(BYSEX): run; NOTE: Variable y1pi_VT is uninitialized. NOTE: Missing values were generated as a result of performing an operation on missing values. Each place is given by: (Number of times) at (Line):(Column). 1 at 2:208 NOTE: There were 11 observations read from the data set WORK.OUTHIST3. WHERE y1p_G_GIRL=1; NOTE: There were 10 observations read from the data set WORK.OUTHIST3. WHERE y1p_G_GIRL=0; NOTE: The data set WORK.BUTTERFLYSEXR10HZ has 11 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.01 seconds MPRINT(BYSEX): ods graphics / reset; MPRINT(BYSEX): title "Butterfly Plot of R10Hz Counts By Gender"; MPRINT(BYSEX): proc sgplot data=work.butterflysexR10Hz; MPRINT(BYSEX): format Males Females positive.; MPRINT(BYSEX): hbar y1pi_R10Hz / response=Males legendlabel="Males"; MPRINT(BYSEX): hbar y1pi_R10Hz / response=Females legendlabel="Females"; MPRINT(BYSEX): xaxis label="Count" grid min=-150 max=150 values=(-150 to 150 by 10) valueshint; MPRINT(BYSEX): yaxis label="R10Hz" discreteorder=data; MPRINT(BYSEX): run; NOTE: Since no format is assigned, the numeric category variable will use the default of BEST6. NOTE: PROCEDURE SGPLOT used (Total process time): real time 0.53 seconds cpu time 0.11 seconds NOTE: Some of the tick values have been thinned. NOTE: There were 11 observations read from the data set WORK.BUTTERFLYSEXR10HZ. Here is the log output for my macro. I am not an expertise in sas and hope you could help me out. ... View more

I created three separate macro statement and wanted it to output three different plots for each statement. I did not pass a list actually. But the thing it it output three identical plots which is the output for the third macro statement. ... View more

My problem is I need to output the results for these three macros,which should be different. (%bysex(y1pi_VT, 1,VT) %bysex(y1pi_R5Hz, 2,R5Hz) %bysex(y1pi_R10Hz, 3,R10Hz) When I run these three sentences separately, it works fine.But when I run these together, it output three plots of R10Hz.   EXPECTED RESULTS     REAL OUTPUT     ... View more

You are right. There is no need to use the macro here. ... View more

That does not work. ... View more

I think I can try without the macro.  ... View more

I do not think that is the problem because I have used the same macro before in another program and that worked very well.  But thanks anyway. ... View more

341 342 /*frequency table for fategorical data*/ 343 options mprint symbolgen; 344 %macro ques(n,o); 345 proc freq data = quad.category1 order = freq; 346 label Q&n = &o; 347 tables Q&n/ missing nocum ; 348 run; 349 350 %mend ques; 351 352 %ques(13,'Compared to before COVID-19, your alcohol intake has') MPRINT(QUES): proc freq data = quad.category1 order = freq; SYMBOLGEN: Macro variable N resolves to 13 SYMBOLGEN: Macro variable O resolves to 'Compared to before COVID-19, your alcohol intake has' MPRINT(QUES): label Q13 = 'Compared to before COVID-19, your alcohol intake has'; SYMBOLGEN: Macro variable N resolves to 13 MPRINT(QUES): tables Q13/ missing nocum ; MPRINT(QUES): run; NOTE: Writing HTML Body file: sashtml.htm NOTE: There were 588 observations read from the data set QUAD.CATEGORY1. NOTE: PROCEDURE FREQ used (Total process time): real time 0.13 seconds cpu time 0.10 seconds 353 %ques(15,'Before COVID-19, how often did you eat out (at a restaurant) ?' 乯 354 %ques(16,'Before COVID-19, how often did you order take-out/delivery?' 乯; SYMBOLGEN: Macro variable N resolves to 18 355 %ques(17,'Before COVID-19, how often did you cook at home?' 乯; SYMBOLGEN: Macro variable O resolves to 'In the past week, how often have you eaten out?' SYMBOLGEN: Macro variable N resolves to 18 356 %ques(18,'In the past week, how often have you eaten out?' ); SYMBOLGEN: Macro variable N resolves to 19 SYMBOLGEN: Macro variable O resolves to 'In the past week, how often have you ordered take-out/delivery' SYMBOLGEN: Macro variable N resolves to 19 357 %ques(19,'In the past week, how often have you ordered take-out/delivery' );     here is the log.Thanks ... View more

Yes it does have label statement. ... View more