
Specify the format search library. The SAS system option FMTSEARCH= adds the
SAS library PROCLIB to the search path that is used to locate formats.
options fmtsearch=(proclib);
Create the $PERISH. format. PROC FORMAT creates a format for Department. This
variable has four different values in the data set, but the format has only two values.
proc format;
value $perish 'p1','p2'='Perishable'
'np1','np2'='Nonperishable';
run;
Specify the report options. By default, the REPORT procedure runs without the
REPORT window and sends its output to the open output destinations.
proc report data=grocery;
Specify the report columns. Department and Sales are separated ...