topic Re: Adding to PROC REPORT in SAS Procedures

Adding to PROC REPORT

hswdl01 — Thu, 10 Dec 2020 15:13:23 GMT

Hi, I am attempting to create this table in an ODS report for my Chi-Square results and I want to include the test name 'Chi-Square' under the column 'Test' in the table. However, I keep getting a blank cell beneath 'Test' in my table and I'm unsure how to alter my code to fix this. This is the code I am currently working with:

DATA ChiSqResults;
	SET ChiSqResults;
	KEEP STATISTIC DF VALUE PROB;
	LABEL Prob = "P-Value";
	IF STATISTIC = "Chi-Square";
		VALUE = ROUND(VALUE, 0.01);
		Prob = ROUND(PROB, 0.01);
	FORMAT VALUE F12.2
		Prob F12.2;
	RUN;

TITLE1 BOLD	'Chi-Square Test of Independence Results';
FOOTNOTE	"Created by HS";
PROC REPORT DATA = ChiSqResults;
	COLUMN	Test 
		("Statistical Results" DF Value Prob);
	LABEL Prob = 'P-Value';
	
	RUN;
TITLE;

Thanks in advance

Re: Adding to PROC REPORT

James18 — Tue, 08 Dec 2020 13:50:25 GMT

Hi,

I believe you are having this issue because you are keeping the variable 'Statistic' in your Data step but in your Proc Report step, you are referring to 'Test' when you actually mean 'Statistic'. If you would like for the statistic variable to be renamed test, you could use a Define statement. I hope my code below helps!

PROC REPORT DATA = HypRslt.chisqresults  ;
	COLUMN	Statistic
	("Statistical Results"     DF  Value Prob );
	DEFINE  Statistic   /  'Test';
	DEFINE  Value       /  Format= 4.2;
	DEFINE  Prob        /  Format= 4.2 'P-Value';
	RUN;

Re: Adding to PROC REPORT

kaitlineolson7 — Thu, 10 Dec 2020 15:11:11 GMT

Hi,

It looks like 'Test' in your code should be replaced with Statistic, as that is where the Chi-Square option is held. Using DEFINE, as shown below, should solve your problem!

PROC REPORT DATA = dataset.ChiSqResults;
COLUMN Statistic ("Statistical Results" DF Value Prob );
DEFINE Statistic / 'Test';
DEFINE Prob / 'P-Value' FORMAT = 4.2 ;
DEFINE Value / FORMAT = 4.2;
FOOTNOTE "Created by HS";
RUN;