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.
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.
Secure your spot at the must-attend AI and analytics event of 2024: SAS Innovate 2024! Get ready for a jam-packed agenda featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events.
Register by March 1 to snag the Early Bird rate of just $695! Don't miss out on this exclusive offer.