topic Re: PROC REPORT NOTE: Groups are not created. . . in New SAS User

PROC REPORT NOTE: Groups are not created. . .

doctortimi — Sat, 20 Jul 2019 17:41:03 GMT

Hello SAS Community,

I just started working with proc report this week and I'm having a hard time creating a report. My study is a descriptive comparison of various factors between 2 groups. I already have a dataset with all my descriptive stats created. However, when I run my proc report code, I get this message "NOTE: Groups are not created because the usage of levels is DISPLAY. To avoid this note, change all
GROUP variables to ORDER variables." and my report is partially displayed.

This is my code:

proc report data = report_data nowd

column groupnr indexvar variable levels (Casepct Controlpct pvalue);
define groupnr /order noprint;
define indexvar / order noprint;
define variable /"Characteristics" group;
define levels / " " ;
define Casepct / "Group A" ;
define Controlpct / "Group B";
define pvalue / "P-value" group format = pvalue6.4;
compute before groupnr;
line ' ';
endcomp;
run;

This is what I want my report to look like (screenshot attached above).

Any help will be greatly appreciated.

Re: PROC REPORT NOTE: Groups are not created. . .

Tom — Sat, 20 Jul 2019 17:36:19 GMT

If you want to post a photo don't do it as an attachment. Instead click on the Photos icon in the menu bar and it will let you paste or upload your photo.

Re: PROC REPORT NOTE: Groups are not created. . .

doctortimi — Sat, 20 Jul 2019 17:39:03 GMT

Noted. Thank you.

Re: PROC REPORT NOTE: Groups are not created. . .

Reeza — Sat, 20 Jul 2019 23:05:52 GMT

Ok, so what are you getting and what does the log show? Which part isn't working, and what does your input look like? Can you replicate the whole process by using SAShelp.heart?

Re: PROC REPORT NOTE: Groups are not created. . .

doctortimi — Sat, 20 Jul 2019 23:49:52 GMT

Hi Reeza,

Thank you for replying. My report is actually displaying only the results of my continuous variables. I tried the same code with the sashelp.heart dataset and it's the same output I get in proc report.

I'm attaching my sashelp input dataset and proc report code. For this test data, I am comparing a few variables between Dead/Alive groups.

proc report data = report_data nowd;

	column groupnr indexvar variable levels (Case__n_pct Control__n_pct 
        pvalue);
	define groupnr /order noprint;
	define indexvar / order noprint;
	define variable /"Characteristics" group;
	define levels / " " style(column) = {cellwidth = 1.25in};
	define Case__n_pct / "Dead";
	define Control__n_pct / "Alive";
	define pvalue / "P-value" group format = pvalue6.4;
	compute before groupnr;
 	line ' ';
	endcomp;
run;

Re: PROC REPORT NOTE: Groups are not created. . .

doctortimi — Sun, 21 Jul 2019 00:43:01 GMT

Hi Reeza,

I figured it out. There was an error in my code.

Thank you!

Re: PROC REPORT NOTE: Groups are not created. . .

Reeza — Sun, 21 Jul 2019 19:52:27 GMT

Glad you figured it out. I would suggest posting your revised code for other and marking that as the answer so this thread can be closed 🙂

Re: PROC REPORT NOTE: Groups are not created. . .

doctortimi — Tue, 23 Jul 2019 16:01:33 GMT

Attached is the updated code. I had used a different variable in my input dataset to define the 2 groups and p-values.

proc report data = report_data nowd;

	column groupnr indexvar variable levels (Case__n_percent Control__n_percent
        prob);
	define groupnr /order noprint;
	define indexvar / order noprint;
	define variable /"Characteristics" group;
	define levels / " " style(column) = {cellwidth = 1.25in};
	define Case__n_percent / "Dead";
	define Control__n_percent/ "Alive";
	define prob/ "P-value" group format = pvalue6.4;
	compute before groupnr;
 	line ' ';
	endcomp;
run;

Thank you, Reeza!

Re: PROC REPORT NOTE: Groups are not created. . .

Tom — Tue, 23 Jul 2019 16:06:37 GMT

If you COLUMN statement as VAR1 VAR2 ... and you define VAR2 as GROUP, then VAR1 must be GROUP also.