Suppose that you have the following data set:   data temp; do set = 1 to 4; do count = 0 to 5; output; end; end; run; Now, you want to get all possible combinations of sets from this data set such that the sum of the "count" is 5. You have to include each "set" one time. For example, I want: combination set count 1 1 5 1 2 0 1 3 0 1 4 0 2 1 4 2 2 1 2 3 0 2 4 0 3 1 4 3 2 0 3 3 1 3 4 0 etc etc etc   Any suggestions on how to accomplish this would be appreciated. TIA!   ... View more

I would like to generate a new variable that is set equal to an element from a macro variable list. But, I want to select the element from the list based on a value in the dataset. For example: %let myvar = 12 23 95 1005; data temp; do x = 1 to 4; output; end; run; data temp2; set temp; y=%scan(&myvar,x,' '); run; This code yields an error because the %scan function is expecting an integer for the second condition. I want the output to be a dataset: x   y 1   12 2   23 3   95 4   1005   Any thoughts or suggestions would be appreciated. Thank you!   ... View more

Why can't SAS compute McNemar's test when zeros are in a column? I think that it is because SAS doesn't "know" that there are zeros. For example, consider the following data set for a hypothetical case-control study. data one; input caseevent controlevent number; cards; 0 0 0 0 1 9 1 0 0 1 1 15 ; run; In this data set, controls are matched to cases. We have 0 case-control pairs where both the case and the control do NOT have the event. There are 15 pairs where they both have the case. For discordant pairs, we have 9 instances where the control had an event, and the case did not. Also, we have 0 instances where the case had an event, and the case did not.   Running PROC FREQ and requesting McNemar test: proc freq data=one; tables caseevent*controlevent / agree; weight number; exact mcnemar; run; We get the appropriate table   But, there is no McNemar test and SAS log gives a NOTE:   So, apparently SAS thinks we are missing data. I can calculate McNemar test (with or without continuity correction) manually. In this case X2=(|9-0|^2)/9=9 with one degree of freedom. Or continuity corrected X2=((|9-0|-1)^2)/9=7.1.   But, it there some way to get sas to do this without having to program it? Further, I would prefer the Exact McNemar test. But, maybe I just need to program conditional Binomial tests for this. ... View more

Why doesn't this work? /*******************/ data temp; do id = 1 to 10; x=ranuni(134); y=ranuni(135); output; end; run; ods rtf file="<your directory>\test.rtf"; %macro m1 (); %let mytitle=This is my title; %let xvalue=; data _null_; set temp; call symputx ('xvalue',x); run; %let yvalue=999; %if (&yvalue ne ) %then ods rtf text="Xvalue is %sysfunc(round(&xvalue,.01))."; title "&mytitle"; proc sgplot data=temp; scatter x=x y=y; run; title ; %mend m1; %m1; ods rtf close; /*********************/   When I execute this code, I get the following error message:   TIA ... View more