That works beautifully.  Thanks. ... View more

That said, if worse comes to worse I could make a character variable and use it for the x-axis but it would be a pain since I'll be generating a lot of graphs. ... View more

FitPolicy looks promising but the problem is that I don't have a text string that goes on the x-axis, like in your example, and instead I have a numeric variable (1 thru 7) that has a format and it is the formatted values that are too long and that I'd like to go on separate rows.  Any remedy for that? ... View more

I'm using proc sgplot.  I've never heard of FITPOLICY the other person mentioned.  I'll look into it.  I'll be making a bunch of plots so something that is general would be helpful.  If it was just one or two then I'd consider things like reducing the font but I don't think that's feasible when making a bunch of them. ... View more

That did it.  My root problem is that I didn't know that format assignments were just done in datastep without regard to whether they were in a if-then-do loop.   Also, I was trying to use code like   if &X_VAR = "NatInj_Hand" then do;   when instead I should have been using code like   %if &X_VAR = NatInj_Hand %then %do   So that's that.  Although I've done a lot of macro coding, I haven't used %if and %then much so that was my problem, as well as the aforementioned fact that I didn't know that formats were assigned even if they were in a do loop.   Thanks to all for the help. ... View more

I'm not sure what you're saying about informats but I have the following proc format earlier in the program that defines the formats that I refer to in the macro.  Since the macro argument I pass is NatInj_Hand, I should see the words below for that format, but instead I see words for the other formats (or numbers when it runs out of what it thinks should be the formats).   Also note that the NatInj_Hand variable exists before I call the macro and it is a binary variable that I use as the response variable in the proc logistic.  The newly created variable in the macro is NatInj_Hand_v and it contains values 1 thru 8 and it is supposed to have the formats for NatInj_Hand below, but the proc print at the end of my macro shows that it does not, which is the problem.  I'm pretty sure I could get around this problem by being inelegant and if I can't figure it out much longer I may do that, but for now, I'll keep trying.  The code I attached has three variables for now in the "X_VAR" section but if I can fix my current problem it's going to have a lot more.   proc format; value NatInj_Hand 1 = 'Amputation' 2 = 'Burns' 3 = 'Crushing' 4 = 'Lac/Punc' 5 = 'Frac/Chip' 6 = 'Other inj' 7 = 'Sprain/Strain' 8 = 'Contusion/Bruise' ; 1 = 'Op Equip' 2 = 'Handling' 3 = 'Weld/Grind' 4 = 'Mach Maint' 5 = 'Hand (No Pow)' 6 = 'Hand (Power)' 7 = 'Walk/Run' 8 = 'Other' 9 = 'Roofbolt' ; value SubUnit 1 = 'Underground' 2 = 'Mill / Prep Plant' 3 = 'Surface' ; value Sector 1 = 'Coal' 2 = 'Sand/Gravel' 3 = 'Stone' 4 = 'Metal' 5 = 'NonMetal' ; run; ... View more

The macro code is below with the macro call below that.  The code is lined up and beautiful and easy to read in my program editor but it is hard to read below.  If there's a way to make it easier to read for you then please let me know.      The first part of the macro is a proc freq, then a proc logistic that creates a dataset, but you can skip past that and go to the subsequent data step, where is uses that dataset and which is where the problem is.   In my output window, the proc print at the end shows that it's giving the wrong result.  In the real macro there is yet more code below that but that's not the point, so I just put %MEND; right after the proc print.  And there is no error in my log, although I can post it if you like, but I'm trying not to overwhelm you.  My code runs without error but it just gives a result that I don't understand.   The chunk from "TAKE CARE OF X_VAR - START" to "TAKE CARE OF X_VAR - END" is where the problem is so you don't have to look at the stuff after that.  The 2nd argument in the macro is x_var.   The argument in the macro call that corresponds to that is NatInj_Hand.  The if-then-do loop for NatInj_Hand comes first and creates a variable named NatInj_Hand_v and assigns a format to it.    But in the proc print at the end, the variable NatInj_v has a different format assigned to it.  It has the format assigned in the if-then-do loop for Sector, which is the last of the three.  Or if I comment that format assignment out, then it has the one for MineAct_Hand, which is the second of the three.  Or if I comment both of those format assignments out, only then does it have the appropriate format assignment of the on in the NatInj_Hand if-then-do loop.   I hope this isn't too much.  If there's anything I can do to make it easier or any questions I can answer then let me know.   %MACRO IMP (bodypart, x_var, x_var_ref, x_levels, group_var, group_var_ref); options mprint; proc freq data=AI_Use; tables &BODYPART.Inj * &X_VAR * &GROUP_VAR / nopct norow; run; ods select ModelInfo NObs ResponseProfile; proc logistic data=AI_Use; title "THIS HAS COVARIABLES &X_VAR AND &GROUP_VAR"; class &X_VAR (ref="&X_VAR_REF") &GROUP_VAR (ref="&GROUP_VAR_REF") / param=ref; model &BODYPART.Inj = &X_VAR &GROUP_VAR &X_VAR * &GROUP_VAR / clodds = wald; oddsratio &X_VAR; ods output OddsRatiosWald = &BODYPART._&X_VAR._&GROUP_VAR; run; proc print data=&BODYPART._&X_VAR._&GROUP_VAR; title "&BODYPART._&X_VAR._&GROUP_VAR"; run; data &BODYPART._&X_VAR._&GROUP_VAR.2; set &BODYPART._&X_VAR._&GROUP_VAR; *********************************************************************************; ************************* TAKE CARE OF X_VAR -- START *************************; *********************************************************************************; %LET X = "&X_VAR"; if &X = "NatInj_Hand" then do; if find (Effect, "&X_VAR_REF") ne 0 then do; if find (Effect, 'Amputation/Enucleation' ) ne 0 then &X_VAR._v = 1; if find (Effect, 'Burns' ) ne 0 then &X_VAR._v = 2; if find (Effect, 'Crushing' ) ne 0 then &X_VAR._v = 3; if find (Effect, 'Cut/Laceration/Puncture') ne 0 then &X_VAR._v = 4; if find (Effect, 'Fracture/Chip' ) ne 0 then &X_VAR._v = 5; if find (Effect, 'Other injury' ) ne 0 then &X_VAR._v = 6; if find (Effect, 'Sprain/Strains' ) ne 0 then &X_VAR._v = 7; * if find (Effect, 'Contusion/Bruise' ) ne 0 then &X_VAR._v = 8; label &X_VAR._v = 'Nature of Injury'; format &X_VAR._v NatInj_Hand.; end; end; if &X = "MineAct_Hand" then do; if find (Effect, "&X_VAR_REF") ne 0 then do; if find (Effect, 'Operating Equipment' ) ne 0 then &X_VAR._v = 1; if find (Effect, 'Handling Material' ) ne 0 then &X_VAR._v = 2; if find (Effect, 'Welding/Grinding' ) ne 0 then &X_VAR._v = 3; if find (Effect, 'Machine Maint./Repair)' ) ne 0 then &X_VAR._v = 4; if find (Effect, 'Hand tools (Not Powered)') ne 0 then &X_VAR._v = 5; if find (Effect, 'Hand tools (Powered)' ) ne 0 then &X_VAR._v = 6; if find (Effect, 'Walking/Running' ) ne 0 then &X_VAR._v = 7; if find (Effect, 'Other' ) ne 0 then &X_VAR._v = 8; * if find (Effect, 'Roofbolting' ) ne 0 then &X_VAR._v = 9; label &X_VAR._v = 'Mine Worker Activity'; format &X_VAR._v MineAct_Hand.; end; end; if &X = "Sector" then do; if find (Effect, "&X_VAR_REF") ne 0 then do; if find (Effect, '1 - Coal' ) ne 0 then &X_VAR._v = 1; if find (Effect, '5 - Sand/Gravel') ne 0 then &X_VAR._v = 2; if find (Effect, '6 - Stone' ) ne 0 then &X_VAR._v = 3; if find (Effect, '8 - Metal' ) ne 0 then &X_VAR._v = 4; * if find (Effect, '7 - Nonmetal' ) ne 0 then &X_VAR._v = 5; label &X_VAR._v = 'Sector'; format &X_VAR._v Sector.; end; end; *********************************************************************************; ************************* TAKE CARE OF X_VAR -- END *************************; *********************************************************************************; *********************************************************************************; *********************** TAKE CARE OF GROUP_VAR -- START ************************; *********************************************************************************; %LET GROUP = "&GROUP_VAR"; if &GROUP = "SubUnit3" then do; if find (Effect, 'A-Underground' ) ne 0 then &GROUP_VAR._v = 1; if find (Effect, 'C-Mills/Prep Plants') ne 0 then &GROUP_VAR._v = 2; if find (Effect, 'B-Surface' ) ne 0 then &GROUP_VAR._v = 3; label &GROUP_VAR._v = 'SubUnit3'; format &GROUP_VAR._v SubUnit.; end; else if &GROUP = "Sector" then do; if find (Effect, "&X_VAR_REF") ne 0 then do; if find (Effect, '1 - Coal' ) ne 0 then &GROUP_VAR._v = 1; if find (Effect, '5 - Sand/Gravel') ne 0 then &GROUP_VAR._v = 2; if find (Effect, '6 - Stone' ) ne 0 then &GROUP_VAR._v = 3; if find (Effect, '8 - Metal' ) ne 0 then &GROUP_VAR._v = 4; if find (Effect, '7 - Nonmetal' ) ne 0 then &GROUP_VAR._v = 5; label &GROUP_VAR._v = 'Sector'; format &GROUP_VAR._v Sector.; end; end; *********************************************************************************; *********************** TAKE CARE OF GROUP_VAR -- END ************************; *********************************************************************************; if &X_VAR._v ne . and &GROUP_VAR._v ne . then output; run; proc print data=&BODYPART._&X_VAR._&GROUP_VAR.2; title "ODDS RATIO OF HAVING A &BODYPART INJURY AS OPPOSED TO A NON-&BODYPART INJURY"; var &X_VAR._v &GROUP_VAR._v OddsRatioEst LowerCL UpperCL; run; %MEND;   Here is the macro call.   %IMP (Hand, NatInj_Hand , Contusion/Bruise, 7, SubUnit3, B-Surface ); ... View more

  I don't know what icon you mean to right-click.  If I right-click my SAS icon before opening SAS I don't see that.  And after I open SAS I don't have any icon to right-click anymore. ... View more