topic Outputting results from log for LEXCOMB permutation in Statistical Procedures

Outputting results from log for LEXCOMB permutation

nd — Mon, 04 Mar 2024 17:55:32 GMT

Here's my code:

%put ParamList = &ParamList; 
data testing;
   array x[5] $10 (&ParamList);
   n=dim(x);
   k=2;
   ncomb=comb(n,k);
   do j=1 to ncomb+1
      rc=lexCOMB(j, k, of x[*]);
       if rc<0 then delete;
	   put j 5. +2 x1-x2;
	   output;
   end;
run;

where ParamList = "1-White" "2-Black" "3-Hispanic" "4-Asian" "5-Other"

The code outputs the following in the log:

1 1-White 2-Black
2 1-White 3-Hispanic
3 1-White 4-Asian
4 1-White 5-Other
5 2-Black 3-Hispanic
6 2-Black 4-Asian
7 2-Black 5-Other
8 3-Hispanic 4-Asian
9 3-Hispanic 5-Other
10 4-Asian 5-Other

How can I save these results in a SAS file? Thanks.

Re: Outputting results from log for LEXCOMB permutation

ballardw — Mon, 04 Mar 2024 18:16:22 GMT

Did you look at the TESTING data set created?

The OUTPUT statement tells SAS to write the variables to the data set when encountered.

If you compare the values of the X1 and X2 variables with your LOG output they should match.

HOWEVER, your code as posted is missing a semicolon at the end of the

  do j=1 to ncomb+1

Re: Outputting results from log for LEXCOMB permutation

nd — Mon, 04 Mar 2024 19:27:59 GMT

The missing semicolon is a typo, my saved code has it.

Attached is the TESTING dataset. What I want is one column with the results "1-White 2-Black", "1-White 3-Hispanic," etc. Thanks.

Re: Outputting results from log for LEXCOMB permutation

ballardw — Mon, 04 Mar 2024 21:55:59 GMT

If you want a new variable in the data set then add:

Newvar = catx(' ',x1,x2);

before the output statement.

Re: Outputting results from log for LEXCOMB permutation

nd — Tue, 05 Mar 2024 14:51:54 GMT

Thank you!