topic Proc Freq and Chisq - how "to keep" just what is needed in SAS Programming

Proc Freq and Chisq - how "to keep" just what is needed

DmytroYermak — Tue, 29 Aug 2017 21:36:23 GMT

Hi all,

I have the following code:

proc freq data=titanicX;
	tables class*survived / chisq ;
	output out=sampleX chisq (keep=_PCHI_ P_PCHI_); 
run;

I need to keep just Chisq and p-value in the output file. The option 'keep' above is not functioning. Could you please help with the issue. Thank you!

Re: Proc Freq and Chisq - how "to keep" just what is needed

WarrenKuhfeld — Tue, 29 Aug 2017 22:21:14 GMT

(KEEP=...) is a data set option. You have to put it right after the data set name.

Re: Proc Freq and Chisq - how "to keep" just what is needed

DmytroYermak — Wed, 30 Aug 2017 04:04:29 GMT

Thank you, Warren. You are completely right, it was the showstopper )

proc freq data=sample&i noprint;
			tables class*survived / chisq;
			output out=sampleX&i (keep=_PCHI_ P_PCHI)chisq;
		run;