Hi, I have a problem defining a label.
The dataset contains a variable called 'Month' formatted as numbers;
when I use the following code:
proc freq data=mylib.history;
table month;
title 'PRoc freq without format';
run;
I get the following output:
PRoc freq without format 227
The FREQ Procedure
Season
Cumulative Cumulative
MONTH Frequency Percent Frequency Percent
__________________________________________________
1 10 8.33 10 8.33
2 10 8.33 20 16.67
3 10 8.33 30 25.00
4 10 8.33 40 33.33
5 10 8.33 50 41.67
However, I'd like to change the name of the column 'Month' by "Active Months". For that; I used the command label:
proc freq data=mylib.history;
table month;
title 'PRoc freq without format';
label month ='Active Months';
run;
However, the label 'month' is not changed, instead, my proposed new lable appears on top of the output, like a title:
Active Months
Cumulative Cumulative
MONTH Frequency Percent Frequency Percent
_______________________________________________
1 10 8.33 10 8.33
2 10 8.33 20 16.67
3 10 8.33 30 25.00
What I'm doing wrong? I also tried adding a label in the DATA procedure, but with the command PROC FREQ, still I got the name of the original variable and the label I want on top of the table, instead of replacing the name of 'month'.
Kind regards
Karolus