The example below provides a count of police department positions by class code and title, across agency/unit and sex. The data is as of 10/31/1994.
The report utilizes the COLUMNS command to specify the order of the columns and to force columns to appear if the value for that column is zero. The values stated for the COLUMNS act as screening statements, so a separate screening statement for specific agency/unit codes is not needed.
-* SELECT THE 1994 AN FILE FOR THIS REPORT
EX JANPS
TABLE FILE AN
HEADING CENTER
"SAN JOSE STATE UNIVERSITY"
"POSITION COUNT BY CLASS FOR UNIVERSITY POLICE DEPARTMENT"
"DATA AS OF 10-31-94"
COUNT AN:POSIT16
ACROSS AN:AGYUNIT AS ''
COLUMNS 260745 AND 260789 AND 896100 AND
896102 AND 260200 AND 896300
ACROSS AN:SEX AS '' COLUMNS M AND F
BY AN:CLASS AS CLASS
BY PS:TITLEA AS TITLE
ON TABLE COLUMN-TOTAL ROW-TOTAL
END