How would I change my proc report code so that instead of displaying "Division=East" it just displays "East". I basically just want to remove the "Division=" piece. Also, is there a way to remove the line that displays between groups?
data mydata;
infile datalines dlm="|";
Length Dept_Description $ 40 Division $5 Units 4;
Input Dept_Description Division Units;
datalines;
Red|East|1234
Blue|East|2546
Green|West|8495
Yellow|West|5162
;
title "report 1";
proc report data=mydata;
column Dept_Description Units;
by Division;
run;
Current Output
report 1
Division=East
Dept_Description Units
Red 1234
Blue 2546
--------------------------------------------------------------------------------
report 1
Division=West
Dept_Description Units
Green 8495
Yellow 5162
Desired Output
report 1
East
Dept_Description Units
Red 1234
Blue 2546
report 1
West
Dept_Description Units
Green 8495
Yellow 5162
One way:
options nobyline; title "report 1"; title3 #byval(division); proc report data=mydata; column Dept_Description Units; by Division; run;title; options byline; /*reset*/
I believe that's the BY title. You can specify NOBYLINE option and then customize it yourself.
http://www2.sas.com/proceedings/sugi23/Coders/p75.pdf
One way:
options nobyline; title "report 1"; title3 #byval(division); proc report data=mydata; column Dept_Description Units; by Division; run;title; options byline; /*reset*/
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.