topic Re: PROC REPORT in New SAS User

PROC REPORT

kcvaldez98 — Tue, 28 Nov 2023 19:40:47 GMT

Hi SAS coders,

I am having trouble with this code:

PROC REPORT DATA=COLANLYS.COMBINED_ANALYSIS;

COLUMN demo_edupctn3(MEAN,STD) demo_povpctn (MEAN,STD) riskfactors_countyestimate (MEAN,STD)

outcomes_adults_mental_distr (MEAN,STD);

DEFINE demo_edupctn3 / ANALYSIS MEAN STD FORMAT=4.1;

DEFINE demo_povpctn / ANALYSIS MEAN STD FORMAT=4.1;

DEFINE riskfactors_countyestimate / ANALYSIS MEAN STD FORMAT=4.1;

DEFINE outcomes_adults_mental_distr / ANALYSIS MEAN STD FORMAT=4.1;

RBREAK AFTER / SUMMARIZE;

RUN;

It gives me an error that says:

ERROR: There is more than one statistic associated

with the column defined by the following elements.

Please advise on what I am doing wrong.

Re: PROC REPORT

PaigeMiller — Tue, 28 Nov 2023 19:45:49 GMT

@kcvaldez98 wrote:

ERROR: There is more than one statistic associated

with the column defined by the following elements.

You can only have one statistic per variable in a DEFINE statement. You can't request two (or more) statistics per variable in a single DEFINE statement.

In PROC REPORT, you can use an ALIAS to get multiple statistics for a single original variable. See this example:

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.4/proc/n0ldy84v9j7463n1jjkloe7av38c.htm

Re: PROC REPORT

kcvaldez98 — Tue, 28 Nov 2023 21:44:37 GMT

Thank you for helping me with that.

I followed that SAS documentation, but I ran into some things I need help with.

MY code is this:

PROC REPORT DATA=COLANLYS.COMBINED_ANALYSIS;

COLUMN N demo_edupctn3 = sd1

demo_povpctn = sd2 riskfactors_countyestimate = sd3

outcomes_adults_mental_distr=sd4;

DEFINE N / 'N';

DEFINE demo_edupctn3 / ANALYSIS MEAN FORMAT=4.1;

DEFINE sd1 / ANALYSIS STD FORMAT = 5.1;

DEFINE demo_povpctn / ANALYSIS MEAN FORMAT=4.1;

DEFINE sd2 / ANALYSIS STD FORMAT = 5.1;

DEFINE riskfactors_countyestimate / ANALYSIS MEAN FORMAT=4.1;

DEFINE sd3 / ANALYSIS STD FORMAT = 5.1;

DEFINE outcomes_adults_mental_distr / ANALYSIS MEAN FORMAT=4.1;

DEFINE sd4 / ANALYSIS STD FORMAT = 5.1;

RUN;

My output looks like this:

I want it where it shows the MEANS and Standard deviations and I think this is only standard deviations.

Please advise.

Re: PROC REPORT

PaigeMiller — Tue, 28 Nov 2023 21:49:18 GMT

you have to put the variable for the means into the COLUMN statement.

Re: PROC REPORT

kcvaldez98 — Tue, 28 Nov 2023 21:52:36 GMT

Would that also be an alias variable or the original variable that I am looking at?

Re: PROC REPORT

PaigeMiller — Wed, 29 Nov 2023 13:13:01 GMT

Follow the example shown in the link I gave.

There, there is a variable name (and in the DEFINE statement the statistic SUM is specified), followed by two aliases, one for statistic MIN and one for statistic MAX.