3. REPORTS › 3.1 Standard Analysis Reports › 3.1.1 Setting Report Options › 3.1.1.2 Report Options Examples
3.1.1.2 Report Options Examples
The following examples are possible report parameter
specifications coded by the CA MICS System Administrator:
Example 1
TIMESPAN DETAIL
CYCLE 01
IDMSID CV09
Select observations from the DETAIL 01 time-span where the
IDMSID is CV09.
Example 2
TIMESPAN DETAIL
CYCLE 01
SYSID MYPC
ACCT1 ABC123
ZONE 1
ZONE 2
DATE 01JUN86
Select observations from the DETAIL 01 time-span where the
SYSID is MYPC, the first IDMS account code is ABC123, the
ZONE is either 1 or 2, and the date is 01JUN86.
Example 3
TIMESPAN DAYS
CYCLE 01
STIME 08:00:00
ETIME 16:59:59
BY ACCT1
Select observations from the DAYS 01 time-span where the TIME
of the observation is between 8 a.m. and 4:59:59 p.m.,
summarize by the first IDMS account code, and create a
separate report for each summarization.
Example 4
TIMESPAN DAYS
CYCLE 01
CYCLE 02
CYCLE 03
CYCLE 04
CYCLE 05
CYCLE 06
SDATE 01JAN86
EDATE 05JAN86
SAS IF IDMTYPE='B';
BY ACCT1
BY ACCT3
Select observations from the DAYS time-span for cycles 01
through 06 with dates between the first and fifth of January
1986 inclusive, which represent IDMS transactions submitted
through Batch. Then summarize the observations by the first
and third IDMS account codes and create a report for
transactions with ACCT1 and a report for transactions with
ACCT3.