topic Re: Merge Outputs in SAS Studio

Merge Outputs

nhi996 — Fri, 06 Oct 2017 18:08:20 GMT

Hey!

I'm writing a macro and my current output looks like this:

I'd like to merge those two so that my output looks like this:

This is what my code currently looks like:
The words macro counts the number of variables in vars_icf


%LET M=%WORDS(&vars_icf.);
%Do i=1 %TO &M.;
%Let var1 = %scan (&vars_icf., &i.);
ODS Output summary=output1 (Rename=(&var._N = N &var._NMISS = NMiss));
proc means data=&input. N NMISS;
var &var1.;
run;
ods output close;
ODS Output summary=test;
proc freq data=&input.;
tables &var1. / NOCUM;
run;
ods output close;

I am grateful for any help!

Re: Merge Outputs

Kurt_Bremser — Fri, 06 Oct 2017 18:27:22 GMT

Please post your whole code. The macro definition (%macro and %mend, for %do to work) is missing, as the macro call that activates all this. And I see no %end for the %do.

Re: Merge Outputs

nhi996 — Fri, 06 Oct 2017 18:39:38 GMT

Ok I added a bit.

%MACRO ICF(vars_icf=, vars_cor=, input=, output=);
%LET M=%WORDS(&vars_icf.);
%DO i=1 %TO &M.;
%Let var1 = %scan (&vars_icf., &i.);
%Let var2 = %scan(&vars_cor., &i.);
ODS Output summary=output1 (RENAME=(&var1._N = N &var1._NMISS = NMiss)); 
proc means data=&input. N NMISS;
var &var1.;
run;
ods output close;
data output 1_1;
set output1;
format variablenname $20.;
variablenname = "&vars_icf.";
run;
ods output summary=output2;
proc freq data=&input.;
tables &var1. / NOCUM;
run;
ods output close;
set output1;
ods output summary=test2;
proc corr data=&input. PEARSON NOMISS NOPROB NOSIMPLE;
var &var1.;
with &vars_cor.;
ods output close;
data output3_1;
set test2;
%END;
%MEND icf;


%icf(input=multiple_sclerosis, vars_cor=eq5d, vars_icf=d530);

I want to do the following with this macro:
The vars_icf all can be between 0 and 4. So each row stands for 1 variable (d530, d540...) and in the columns, for each var I want
N, NMiss, the absolute and relative frequency and the correlations with the variables of vars_cor.

Re: Merge Outputs

nhi996 — Fri, 06 Oct 2017 18:42:14 GMT

This is how my preferred output should look like.

Re: Merge Outputs

Reeza — Fri, 06 Oct 2017 20:16:31 GMT

Is there a particular reason you're running one variable at a time through all these procedures? Why not do them all at once?

Re: Merge Outputs

nhi996 — Fri, 06 Oct 2017 20:18:07 GMT

No. I'm fairly new to sas and not used to the style of programming yet

Re: Merge Outputs

Reeza — Fri, 06 Oct 2017 20:23:55 GMT

If you're new to SAS, I wouldn't start with macros. There's a lot of 'newer' ways to do things that are a lot more efficient. You can run all variables at once through proc means and proc freq.

Re: Merge Outputs

nhi996 — Fri, 06 Oct 2017 20:40:43 GMT

It's a worksheet for university and we have to use a macro unfortunately