topic Re: proc format in SAS Programming

proc format

archibald — Wed, 27 Apr 2016 01:01:05 GMT

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

Re: proc format

Reeza — Wed, 27 Apr 2016 01:10:30 GMT

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?

Re: proc format

archibald — Wed, 27 Apr 2016 01:35:48 GMT

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

Re: proc format

Ksharp — Wed, 27 Apr 2016 01:46:40 GMT

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.

Re: proc format

Reeza — Wed, 27 Apr 2016 01:47:48 GMT

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';

Re: proc format

stat_sas — Wed, 27 Apr 2016 01:53:15 GMT

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;