topic Re: Labels not appearing in proc freq in SAS Procedures

Labels not appearing in proc freq

msinclair — Fri, 09 Nov 2012 18:42:37 GMT

Hi,

I am using SAS 9.3 and for some reason my labels are not appearing on my variables when I do a general Proc Freq. They appear fine with a Proc Print or Proq Freq/Chisq. I have even looked at the Dataset contents to make sure the label appears and it does.

Here is my code:

data PTSD;

set WWR.Adult_Baseline;

if PCLTotalScore_PRE ge 30 then PCLpre30=1;

else if PCLTotalScore_PRE lt 30 then PCLpre30=0;

if PCLTotalScore_PRE ge 50 then PCLpre50=1;

else if PCLTotalScore_PRE lt 50 then PCLpre50=0;

label PCLpre30="High Distress (Cut-off of 30)"

PCLpre50="High Distress (Cut-off of 50)";

run;

proc format;

value servicemembercleanft 0="Civilian Parent" 1="Service Member";

value yes_noft 0='No' 1='Yes';
run;

proc freq data=PTSD;

tables servicememberclean*PCLpre30 servicememberclean*PCLpre50/list missing;

format servicememberclean servicemembercleanft. PCLpre30 PCLpre50 yes_noft.;

run;

Re: Labels not appearing in proc freq

art297 — Fri, 09 Nov 2012 20:52:18 GMT

You can get what you want by modifying the template that is used. Take a look at:

http://support.sas.com/kb/23/350.html

Re: Labels not appearing in proc freq

msinclair — Fri, 09 Nov 2012 23:00:13 GMT

Thank you for this.

However, I have never used Proc Template so I do not understand which parts need to be altered to get my variable labels to show up. Any suggestions?

Re: Labels not appearing in proc freq

art297 — Sat, 10 Nov 2012 00:15:50 GMT

If you run the code in that example, you will see that their use of proc template does (I think) precisely what you are trying to accomplish.

Re: Labels not appearing in proc freq

Cynthia_sas — Sat, 10 Nov 2012 02:39:18 GMT

Hi:

The only issue is that the example uses the OneWayFreqs output object, but the OP created output using the LIST option, which changes the output object that is used. The output object used for LIST output is OneWayList. So while the general method would be the same, the template that needs to change would be different.

It might be easier to use PROC TABULATE, since it uses labels by default. Or, possibly easier than learning TABULATE, is to make an output dataset with PROC FREQ and then using PROC PRINT with a LABEL option to print the dataset from FREQ.

cynthia

Re: Labels not appearing in proc freq

art297 — Sat, 10 Nov 2012 04:47:02 GMT

Cynthia,

Thanks for pointing that out, but I think there is a simpler alternative. How about?:

options validvarname=any;

proc freq data=PTSD (rename=(PCLpre30="High Distress (Cut-off of 30)"n

PCLpre50="High Distress (Cut-off of 50)"n));

tables servicememberclean*"High Distress (Cut-off of 30)"n

servicememberclean*"High Distress (Cut-off of 50)"n

/list missing;

format servicememberclean servicemembercleanft.

"High Distress (Cut-off of 30)"n

"High Distress (Cut-off of 50)"n yes_noft.;

run;

Re: Labels not appearing in proc freq

Cynthia_sas — Sat, 10 Nov 2012 14:16:12 GMT

Art:

Very clever! As long as you're willing to use that type of naming convention, it is way easier than changing the table template!

cynthia

Re: Labels not appearing in proc freq

msinclair — Tue, 13 Nov 2012 15:38:19 GMT

Thank you both so much. I just tried it and it worked!!