04-10-2018 12:32 PM
input state $ amt;
proc sort = have out= have1; by state ;run;
proc print = have1 noobs;
Lets say I want to proc export, I want each state to have its own tab without the byline so AL, CA and DE would output to its own tab. I do not want to have to name each state because I may have to do this for all 50 states.
04-10-2018 12:38 PM
proc sort data=sashelp.cars out=cars; by origin; run; ods excel file='demo.xlsx' style=seaside options(sheet_interval='bygroup' sheet_label='Origin'); title; ods noptitle; proc print data=cars noobs label; by origin; run; ods excel close;