topic Re: renaming in proc Freq in Statistical Procedures

renaming in proc Freq

hjjijkkl — Fri, 25 Sep 2020 16:29:29 GMT

How do I rename Number_of_surveys to Number of surveyswhich is without underscore

proc freq data=nSubj ;
tables Number_of_surveys/ NOCUM ;
run;

Re: renaming in proc Freq

novinosrin — Fri, 25 Sep 2020 16:45:16 GMT

options validvarname=any;
proc freq data=nSubj(rename=(Number_of_surveys='Number of surveys'n)) ;
tables 'Number of surveys'n/ NOCUM ;
run;

Re: renaming in proc Freq

Reeza — Fri, 25 Sep 2020 17:04:02 GMT

Why not use a label instead?

It means you'll have to type out the name with the spaces and quotes and N each time otherwise? 'Number of Surveys'n is now your new variable name.

label number_of_surveys = 'Number of Surveys';

If you want more control over your output from PROC FREQ I suggest using PROC TABULATE instead.

Re: renaming in proc Freq

hjjijkkl — Fri, 25 Sep 2020 17:05:29 GMT

Thank you!

Re: renaming in proc Freq

hjjijkkl — Fri, 25 Sep 2020 17:28:21 GMT

I have used it and using the Label name changes the the label "Frequency count" that is automatically generated with the freq table not the variable "number_of_surveys" when used proc freq