topic Re: Can we open proc means output in proc report? in SAS Studio

Can we open proc means output in proc report?

sasban — Thu, 19 Oct 2017 23:55:32 GMT

I'm new is SAS, trying to open proc means output in proc report to beautify it. However, it didn't open as it was in proc mean. I would appreciate any suggestions, tips and tricks.

Re: Can we open proc means output in proc report?

error_prone — Fri, 20 Oct 2017 00:12:17 GMT

You could use output statement in proc means to create a dataset and use that in proc report. But proc report can aggregate data, so maybe proc means is not necessary at all. You have to show your proc means code to help you further.

Re: Can we open proc means output in proc report?

Reeza — Fri, 20 Oct 2017 00:49:38 GMT

Don't. Learn to use ODS first and control the output directly from PROC MEANS.

Re: Can we open proc means output in proc report?

sasban — Mon, 23 Oct 2017 17:55:45 GMT

I need to get an output as attached from a data set. I tried using Proc means and Proc report, but didn't help. Any suggestions please?

Re: Can we open proc means output in proc report?

Reeza — Mon, 23 Oct 2017 18:04:05 GMT

Yeah, that's not standard output. Look for a paper called 'Creating Complex Reports' from Cynthia Zender that will detail how to create these reports.

Re: Can we open proc means output in proc report?

sasban — Mon, 23 Oct 2017 18:06:31 GMT

Thank you Reeza!

Re: Can we open proc means output in proc report?

sasban — Wed, 25 Oct 2017 15:26:38 GMT

@error_prone,

I'm looking for output like in proc report (below), Can I get that output through proc means (below)?

Proc import datafile="/folders/myshortcuts/Myfolders/SAS Exercise/EFF_Exercise.xls"

Out=AE

Dbms=XLS replace;

run;

data AEsmall;

set AE (keep=avisitn avisitn_1 trt01p aval);

run;

Proc sort data=AEsmall out=AEready;

by avisitn;

run;

Proc means data=AEready N mean stderr maxdec=3;

var aval;

class avisitn avisitn_1 trt01p;

ods output summary=AE1;

run;

data viral_load;

set AE1;

format aval_mean_se $50.;

drop NObs aval_mean aval_stderr;

aval_mean_se=put(aval_mean, 5.3)!!' ('!!put(aval_stderr, 5.3)!!')';

run;

Proc report data=viral_load out=TableQ7;

title1 'Table 1:';

title2 'Summary of Viral Load Over Time';

title3 'ITT Population';

column avisitn trt01p aval_N aval_mean_se;

define avisitn/group 'Test day (Week)';

define trt01p/group 'Treatment';

define aval_N/group 'N';

define aval_mean_se/display 'Unadjusted Mean (SE)';

run;

Re: Can we open proc means output in proc report?

Reeza — Wed, 25 Oct 2017 15:38:30 GMT

Not by default, you need to use a process similar to what's shown which involves customizing the output to what you need.