I am trying to create a simple report to capture all the REVIEWTYPEs (e.g., EKG, Cytology) within a medical department (MDDEPT; e.g., ANES, CARD, REHB).

I am capturing this data from a flat file with SEGTYPE=S0. Other than changing this MFD into a hierarchical layout, I have written a small table request to try to capture these procedures within their department.

Is there another way I can get this information in report with code?

The code and the current MFD are captioned below.

{
TABLE FILE PRIMETBLCASETRACKING
HEADING CENTER
" REVIEWTYPE BY MDDEPT
" FOR ECT "
" DATE: &DATEtrMDYY "
" "
SUM REVIEWTYPE
BY MDDEPT SKIP-LINE
BY REVIEWTYPE NOPRINT
-*ON MDDEPT SKIP-LINE
WHERE MDDEPT EQ 'ANES' OR 'CARD' OR 'CTSR' OR 'EMER' OR 'ENDO'
OR 'FMED' OR 'GILB' OR 'IMED' OR 'NEON' OR 'PATH'
OR 'PEDS' OR 'PSYC' OR 'PSYO' OR 'PULM' OR 'RADI'
OR 'RADO' OR 'REFF' OR 'REBH' OR 'SURG' OR 'VASC' OR 'WOMN';
WHERE REVIEWTYPE NE '.';
END
-RUN
}

Here is the Master File
{
FILENAME=PRIMETBLCASETRACKING, SUFFIX=EDA, $
SEGMENT=PRIMETBLCASETRACKING, SEGTYPE=S0, $
FIELDNAME=REVIEWER, ALIAS=REVIEWER, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME='CASE#', ALIAS='CASE#', USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME='TRACK#', ALIAS='TRACK#', USAGE=I11, ACTUAL=I4, $
FIELDNAME=DATE_ASSIGNED, ALIAS=DATE_ASSIGNED, USAGE=HYYMDS, ACTUAL=HYYMDS, MISSING=ON,
TITLE='Date Assigned', $
FIELDNAME=PHYSICIAN, ALIAS=PHYSICIAN, USAGE=A50V, ACTUAL=A50V,
MISSING=ON, $
FIELDNAME=DATE_RETURNED, ALIAS=DATE_RETURNED, USAGE=HYYMDS, ACTUAL=HYYMDS, MISSING=ON, TITLE='Date Returned', $
FIELDNAME=NEVERRETURNED, ALIAS=NEVERRETURNED, USAGE=I11, ACTUAL=I4, $
FIELDNAME=RESENT, ALIAS=RESENT, USAGE=I11, ACTUAL=I4, $
FIELDNAME=NEVERRETURNEDOLD, ALIAS=NEVERRETURNEDOLD, USAGE=I11, ACTUAL=I4, $
FIELDNAME=REVIEWED, ALIAS=REVIEWED, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=MDDEPT, ALIAS=MDDEPT, USAGE=A4V, ACTUAL=A4V,
MISSING=ON, $
FIELDNAME=REVIEWTYPE, ALIAS=REVIEWTYPE, USAGE=A20V, ACTUAL=A20V,
MISSING=ON, $
}

Thanks!

A couple of suggestions:

1. As Tom Flynn suggested, change SUFFIX=EDA to SUFFIX=FIX, or is it comma-delimited?
2. Double-check the ACTUAL lengths. I am concerned about the V formats.
3. Either add a DATASET parameter to the master or a FILEDEF in the program to identify where the actual file resides.

Maybe you can post a row of your data as an example. Also indicate what error you are getting.