Customizing PROC PRINT Output with the STYLE= Option
We can use different styles to change overall look of any output which produce thru proc print, proc report & proc tabulate by using STYLE=OPTION in proc step.
Syntax:- PROC PRINT STYLE(location-list) = {style-attribute = value};
Location – List like
DATA (all the data cells)
HEADER ( the column headers (variable names))
OBS (the data in the OBS column, or ID column if using an ID statement)
OBSHEADER (the header for the OBS or ID column)
TOTAL (the data in the totals row produced by a SUM statement)
GRANDTOTAL (the data for the grand total produced by a SUM statement)
Example:-
DATA DS;
SET SASHELP.CLASS;
RUN;
PROC SORT DATA=DS;
BY SEX;
RUN;
ODS HTML FILE=”C:\Documents and Settings\Administrator\Desktop\sas\Demo.htm”;
PROC PRINT STYLE(DATA) = {BACKGROUND = pink};
/*PROC PRINT STYLE(HEADER) = {BACKGROUND = pink};*/
/*PROC PRINT STYLE(OBS) = {BACKGROUND = pink};*/
/*PROC PRINT STYLE(OBSHEADER) = {BACKGROUND = pink};*/
/*PROC PRINT STYLE(TOTAL) = {BACKGROUND = pink};*/
/*PROC PRINT STYLE(GRANDTOTAL) = {BACKGROUND = pink};*/
PROC PRINT DATA=DS NOOBS;
VAR NAME SEX AGE HEIGHT WEIGHT;
BY SEX;
SUMBY SEX;
SUM HEIGHT WEIGHT;
Title c=red f=Arial h=7 ‘ Student Data’;
Title2 c=red f=Arial h=7 ‘Stansys Software Solutions’;
Footnote j=l c=green f=’comic sans ms’ h=7 ‘Generated by Mr. Krishna ‘;
RUN;
ODS HTML CLOSE;
In above example style is applying for entire table(for all variables one style)
But if you want to apply different styles for different variables see below program.
Syntax:-VAR variable / STYLE(location-list) = {style-attribute = value};

ODS HTML FILE=”C:\Documents and Settings\Administrator\Desktop\sas\DEMO.HTM”;
PROC PRINT DATA=DS NOOBS;
VAR NAME/STYLE(DATA)={BACKGROUND=RED FOREGROUND=YELLOW} ;
VAR SEX ;
VAR AGE ;
VAR HEIGHT ;
VAR WEIGHT;
BY SEX;
SUMBY SEX;
SUM HEIGHT WEIGHT;
Title c=red f=Arial h=7 ‘ Student Data’;
Title2 c=red f=Arial h=7 ‘Stansys Software Solutions’;
Footnote j=l c=green f=’comic sans ms’ h=7 ‘Generated by Mr. Krishna ‘;
RUN;
ODS HTML CLOSE;

ODS HTML FILE=”C:\Documents and Settings\Administrator\Desktop\mysas\DEMO.HTM”;
PROC PRINT DATA=DS NOOBS;
VAR NAME/STYLE(DATA)={BACKGROUND=yellow FOREGROUND=RED} ;
VAR SEX /STYLE(HEADER)={BACKGROUND=CYAN} ;
VAR AGE /STYLE(DATA)={BACKGROUND=orange FOREGROUND=BLUE} ;
VAR HEIGHT /STYLE(DATA)={BACKGROUND=GWH } ;
VAR WEIGHT/STYLE(HEADER)={BACKGROUND=MAGENTA} ;
BY SEX;
SUMBY SEX;
SUM HEIGHT WEIGHT;
Title c=red f=Arial h=7 ‘ Student Data’;
Title2 c=red f=Arial h=7 ‘Stansys Software Solutions’;
Footnote j=l c=green f=’comic sans ms’ h=7 ‘Generated by Mr. Krishna ‘;
RUN;
ODS HTML CLOSE;

Using Macros in Proc Print
%global repdate;
Proc sql;
Connect to oracle as Krishna (USER=Stanmis PASSWORD=”{sas001}QzBycDByX3Qz”
PATH=demprod);
Create table repo as
Select * from connection to Krishna
(
Select to_char(to_date(sysdate-1),’dd-Mon-yyyy’) as repdate from dual
);
Disconnect from Krishna;
Quit;
Data _null_;
Set repo;
kx=repdate;
Call symput(‘repdate’,kx);
Put kx ;
Run;
PROC IMPORT
DATAFILE=”C:\Documents and Settings\Stan\Desktop\Demographic_data.csv”
OUT=My_SAS.DEMOGRAPHIC_DATA DBMS=CSV REPLACE;
RUN;
PROC SORT DFATA= My_SAS.DEMOGRAPHIC_DATA;
BY ZONE;
RUN;
PROC FORMAT LIB=My_SAS;
VALUE $GEN ‘F’=’RED’
‘M’=’GREEN’;
RUN;
ODS PDF
FILE=”C:\Documents and Settings\Stan\Desktop\Reports\Demographic.PDF” NOTOC;
PROC PRINT DATA=My_SAS.DEMOGRAPHIC_DATA NOOBS DOUBLE N
LABEL SPLIT=’*’ UNIFORM ROUND;
LABEL ZONAL_HEAD=ZONAL*MANAGER
REGIONAL_MANAGER = REGIONAL*MANAGER
EMP_NAME=EMPLOYEE*NAME;
VAR REGION REGIONAL_MANAGER EMP_NAME INCOME SEX/style=[background=$GEN.];
ID ZONE ZONAL_HEAD;
BY ZONE ZONAL_HEAD;
PAGEBY ZONE;
SUMBY ZONE;
SUM INCOME;
Title c=red f=Arial h=7 ‘ Employee Demographic Data’;
Title2 c=red f=Arial h=7 ‘Stansys Software Solutions’;
Footnote j=l c=green f=’comic sans ms’ h=7 “Generated by Mr. Krishna on &repdate”;
RUN;
ODS PDF CLOSE;