proc format

[archibald]

Hi all,

I added the format option in my code to get the complete label of the variables, but it does not seem to work . see output below. Any idea? Thanks.

proc tabulate data=school ;
tables (math phys philo grd)*sum*f=10.0, all ;
format  math mathematics. phys physics. philo philosophy. grd grade.;
var math phys philo grd;
run;

 

math 124

phys  231

philo   79

grd   106

[Reeza]

A touch confused. 

Formats are used to control the display of a variables values. I've variable math has the values math101, math102

Labels are used to control the display of a variable name ie math='Mathematics'

Your output and description don't seem to match, which are you trying to do?

[archibald]

Sorry about the confusion. only half ofthe ouput was displayed. 

anyway, this is how  my output looks like

        sum

math 124

phys  231

philo   79

grd   106

but I want 

                    sum

mathematics 124

physics          231

philosophy      79

grade            106

[Reeza]

Given your code try labels then, instead of format. 

If if that doesn't work please post a sample of your input data set. 

Label math='Mathematics';

[stat_sas]

Formats will not be a solution for this. Just use variable labels in table statement to get the full text. Try this.

proc tabulate data=school ;
tables (math='mathematics' phys='physics' philo='philosophy' grd='grade')*sum*f=10.0, all ;
var math phys philo grd;
run;

[Ksharp]

proc tabulate data=school ;
tables (math='mathematics'  phys='physics'   philo='philosophy'  grd='grade' )*sum*f=10.0, all ;

var math phys philo grd;
run;

It is variable label, has nothing to do with FORMAT.