D'oh, that was so dumb of me. I had forgotten to do ODS HTML; first. I guess if you don't tell if it you want HTML or RTF or whatever then ODS GRAPHICS ON; doesn't do you any good. Thanks for your help. ... View more

Do you mean the Plinko game on The Price Is Right where they drop a ball in the top and it hits all the pegs on the way down and eventually lands in one of the cells at the bottom? If so then the first thing you'd have to do is figure out / guess / estimate what the probabilities are of the ball dropping into each cell at the bottom. Presumably it's symmetric, ie, the cell at the farthest left has an equal probability to the cell at the farthest right, etc. But what the probabilities are, I have no idea. If you have the probabilities (or any set of probabilities) then simulating that in SAS via a function (RANUNI I think) is easy. ... View more

Oops, I now notice my post should have gone in the SAS Statistical Procedures section instead of the SAS Procedures section, so I reposted it in SAS Statistical Procedures section. If you have any ideas then please respond there. Sorry for the mixup. ... View more

Thanks a lot, folks, that was very useful info. I appreciate it. ... View more

Here is the macro and the log results for it when using mlogic, etc. 1265 %MACRO VAL_SA_A_D_SD_DK_No_a (var); 1266 data x; 1267 set final; 1268 if &VAR = 'Strongly Agree' then &VAR = '1_' || 'Strongly Agree' ; 1269 if &VAR = 'Agree' then &VAR = '2_' || 'Agree' ; 1270 if &VAR = 'Disagree' then &VAR = '3_' || 'Disagree' ; 1271 if &VAR = 'Strongly Disagree' then &VAR = '4_' || 'Strongly Disagree'; 1272 if &VAR = "Don't Know" then &VAR = '5_' || "Don't Know" ; 1273 if &VAR = 'No answer' then &VAR = '6_' || 'No answer' ; 1274 run; 1275 proc freq data=final; tables &VAR; run; 1276 proc freq data=x ; tables &VAR; run; 1277 %MEND VAL_SA_A_D_SD_DK_No_a; 1278 %VAL_SA_A_D_SD_DK_No_a (S1_D1 ); MLOGIC(VAL_SA_A_D_SD_DK_NO_A): Beginning execution. MLOGIC(VAL_SA_A_D_SD_DK_NO_A): Parameter VAR has value S1_D1 WARNING: The Base Product product with which DATASTEP is associated will be expiring soon, and is currently in warning mode to indicate this upcoming expiration. Most typically this warning period runs for 45 days. Please run PROC SETINIT to obtain more information on your warning period. MPRINT(VAL_SA_A_D_SD_DK_NO_A): data x; MPRINT(VAL_SA_A_D_SD_DK_NO_A): set final; SYMBOLGEN: Macro variable VAR resolves to S1_D1 SYMBOLGEN: Macro variable VAR resolves to S1_D1 MPRINT(VAL_SA_A_D_SD_DK_NO_A): if S1_D1 = 'Strongly Agree' then S1_D1 = '1_' || 'Strongly Agree' ; SYMBOLGEN: Macro variable VAR resolves to S1_D1 SYMBOLGEN: Macro variable VAR resolves to S1_D1 MPRINT(VAL_SA_A_D_SD_DK_NO_A): if S1_D1 = 'Agree' then S1_D1 = '2_' || 'Agree' ; SYMBOLGEN: Macro variable VAR resolves to S1_D1 SYMBOLGEN: Macro variable VAR resolves to S1_D1 MPRINT(VAL_SA_A_D_SD_DK_NO_A): if S1_D1 = 'Disagree' then S1_D1 = '3_' || 'Disagree' ; SYMBOLGEN: Macro variable VAR resolves to S1_D1 SYMBOLGEN: Macro variable VAR resolves to S1_D1 MPRINT(VAL_SA_A_D_SD_DK_NO_A): if S1_D1 = 'Strongly Disagree' then S1_D1 = '4_' || 'Strongly Disagree'; SYMBOLGEN: Macro variable VAR resolves to S1_D1 SYMBOLGEN: Macro variable VAR resolves to S1_D1 MPRINT(VAL_SA_A_D_SD_DK_NO_A): if S1_D1 = "Don't Know" then S1_D1 = '5_' || "Don't Know" ; SYMBOLGEN: Macro variable VAR resolves to S1_D1 SYMBOLGEN: Macro variable VAR resolves to S1_D1 MPRINT(VAL_SA_A_D_SD_DK_NO_A): if S1_D1 = 'No answer' then S1_D1 = '6_' || 'No answer' ; MPRINT(VAL_SA_A_D_SD_DK_NO_A): run; NOTE: There were 115 observations read from the data set WORK.FINAL. NOTE: The data set WORK.X has 115 observations and 107 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.03 seconds WARNING: The Base Product product with which FREQ is associated will be expiring soon, and is currently in warning mode to indicate this upcoming expiration. Most typically this warning period runs for 45 days. Please run PROC SETINIT to obtain more information on your warning period. MPRINT(VAL_SA_A_D_SD_DK_NO_A): proc freq data=final; SYMBOLGEN: Macro variable VAR resolves to S1_D1 MPRINT(VAL_SA_A_D_SD_DK_NO_A): tables S1_D1; MPRINT(VAL_SA_A_D_SD_DK_NO_A): run; NOTE: There were 115 observations read from the data set WORK.FINAL. NOTE: PROCEDURE FREQ used (Total process time): real time 0.01 seconds cpu time 0.01 seconds WARNING: The Base Product product with which FREQ is associated will be expiring soon, and is currently in warning mode to indicate this upcoming expiration. Most typically this warning period runs for 45 days. Please run PROC SETINIT to obtain more information on your warning period. MPRINT(VAL_SA_A_D_SD_DK_NO_A): proc freq data=x ; SYMBOLGEN: Macro variable VAR resolves to S1_D1 MPRINT(VAL_SA_A_D_SD_DK_NO_A): tables S1_D1; MPRINT(VAL_SA_A_D_SD_DK_NO_A): run; NOTE: There were 115 observations read from the data set WORK.X. NOTE: PROCEDURE FREQ used (Total process time): real time 0.01 seconds cpu time 0.01 seconds MLOGIC(VAL_SA_A_D_SD_DK_NO_A): Ending execution. And here is the generated output. The prefix numbers get assigned for all the other groups but not for the Don't Know group. Cumulative Cumulative S1_D1 Frequency Percent Frequency Percent ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ 1_Strongly Agree 23 20.91 23 20.91 2_Agree 31 28.18 54 49.09 3_Disagree 23 20.91 77 70.00 4_Strongly Disagree 4 3.64 81 73.64 Don’t Know 29 26.36 110 100.00 Frequency Missing = 5 ... View more

Here is the exact code. It is part of a macro but that shouldn't matter, especially since I have other similiar macros that work fine. And the code below works fine too except for the line with Don't Know" in it. (Yes, it's stupid to have to do this task in the first place, but it's a long story as to why I have to.) data x; set final; if &VAR = 'Strongly Agree' then &VAR = '1_' || 'Strongly Agree' ; if &VAR = 'Agree' then &VAR = '2_' || 'Agree' ; if &VAR = 'Disagree' then &VAR = '3_' || 'Disagree' ; if &VAR = 'Strongly Disagree' then &VAR = '4_' || 'Strongly Disagree'; if &VAR = "Don't Know" then &VAR = '5_' || "Don't Know" ; if &VAR = 'No answer' then &VAR = '6_' || 'No answer' ; run; ... View more

That worked great. Thanks. As I suspected, the solution was something right in front of me. ... View more

This issue gets into parameterization, which is hard to explain via computer. But it helps to ask yourself what question you're trying to answer, which sounds basic, I know, but it's amazing how often that very clearly and very specifically defining the question helps you find the answer. You ask how you know if CORNELL is significant. Signficant compared to what? Remember, CORNELL isn't a continuous variable such as AGE, where you get a parameter estimate and a p-value and that tells you what happens as AGE changes. Instead, CORNELL is one general. The beta and p-value for JACKSON will tell you whether JACKSON is different from CORNELL (or equivalently whether CORNELL is different from JACKSON). The beta and p-value for DAVIS will tell you whether DAVIS is different from CORNELL (or equivalently whether CORNELL is different from DAVIS). And you could write a CONTRAST statement to determine whether JACKSON is different from DAVIS. Those are typically the only kinds of questions I ask in situations like that. But there is a way to answer the question "Is CORNELL different from all generals combined?" and I don't know what it is right now but perhaps that's not what you really need to know anyway. ... View more

I've found a semi-fix. If I use V=. then it uses a period as a plotting point, which is much more visible then if I use V=POINT. ... View more