topic Re: Referencing a Summed Column from Proc Tabulate in Proc Report in Developers

Referencing a Summed Column from Proc Tabulate in Proc Report

DavidPhillips2 — Fri, 08 May 2015 14:04:20 GMT

I am formatting data using proc tabulate for when I call the data in proc report. I need to know the name of the columns from proc tabulate to reference them in proc report. This works until I add in the sum feature in proc tabulate. I’m not sure what my variable is called after I add in the sum feature. In this particular scenario the summed variable is students_enrolled_sum. However if I change out the location column with a marco &columnName identifying the column name gets tricky. Without the sum my column name is always n. I tried using labels however the label appears to only be a label and not a name as can be seen in a proc print statement like the print screen.

proc tabulate data=enrollment missing out=enrollment4 FORMAT=COMMA8.;

class location academic_period;

var students_enrolled;

table sum*location='n'*students_enrolled='' sum*students_enrolled=' '*all, academic_period /row=float;

keylabel sum=' ' n=' ';

run;

proc print data=enrollment4;

Re: Referencing a Summed Column from Proc Tabulate in Proc Report

RW9 — Fri, 08 May 2015 14:13:16 GMT

Can you not query the SASHELP.VCOLUMN (DICTIONARY.COLUMNS) information, if _sum is always the suffix then:

proc sql;

select NAME

into :THE_SUM_VAR

from DICTIONARY.COLUMNS

where LIBNAME="WORK" and MEMNAME="ABC";

quit;

Then use the macro variable. If _sum isn't the suffix always, take a list of your variables before and after and remove the before from the after to be left with additional variables.

Re: Referencing a Summed Column from Proc Tabulate in Proc Report

DavidPhillips2 — Fri, 08 May 2015 14:24:43 GMT

I used the concatenate function to combined

location || sum to reference my variables dynamically. This works for me there should be a better way like being able to reference the label name.