Renaming a Column in Proc Freq

ssills24 — Thu, 10 Dec 2020 15:04:52 GMT

Hello,

I am trying to create a SAS output table using PROC FREQ, and I only want the Test, DF, Value, and Prob columns. However, I need to rename the prob column to P-Value. Whenever I run the code below, I receive an error saying that the variable Prob does not exist.

ODS OUTPUT ChiSq = ChiSqResults (DROP = Table WHERE = (Statistic = 'Chi-Square') RENAME = (Prob = P-Value);
PROC FREQ DATA = HypAnalysis2;
TABLES HypRelDeathInd*StateCd / NOCUM NOCOL NOROW NOPERCENT CHISQ;
RUN;

PROC PRINT DATA = ChiSqResults NOOBS;
RUN;

I would appreciate any help! Thank you.

Re: Renaming a Column in Proc Freq

andreas_lds — Fri, 04 Dec 2020 05:45:14 GMT

@ssills24 wrote:

Hello,

I am trying to create a SAS output table using PROC FREQ, and I only want the Test, DF, Value, and Prob columns. However, I need to rename the prob column to P-Value. Whenever I run the code below, I receive an error saying that the variable Prob does not exist.

ODS OUTPUT ChiSq = HypRslt.ChiSqResults (DROP = Table WHERE = (Statistic = 'Chi-Square') RENAME = (Prob = P-Value);
PROC FREQ DATA = HypAnl.HypAnalysis2;
TABLES HypRelDeathInd*StateCd / NOCUM NOCOL NOROW NOPERCENT CHISQ;
RUN;

PROC PRINT DATA = HypRslt.ChiSqResults NOOBS;
RUN;

I would appreciate any help! Thank you.

The code should generate more error messages than the one you are mentioning. Also note that "P-Value" is not a valid name for a sas variable. If you need to have "P-Value" as heading when printing the dataset, use a label:

proc print data = hyprslt.chisqresults noobs label;
  label prob = 'P-Value';
run;

topic Renaming a Column in Proc Freq in New SAS User

Renaming a Column in Proc Freq

Re: Renaming a Column in Proc Freq