Date:         Tue, 16 Apr 1996 20:18:52 -0400
Reply-To:     Paul Haugen <phaugen@QIS.NET>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         Paul Haugen <phaugen@QIS.NET>
Organization: EUC Inc.
Subject:      Re: Help on automating flat file

Christopher Scott wrote:
>
>           I have a program that looks at a person's eligibility for health
>      care by month and prints a report showing this eligibility by month,
>      similar to this:
>
>      Name      OCT95     NOV95     DEC95     JAN96     FEB96 ...
>
>      AAAAA       X         X                             X
>      BBBBB                 X         X         X
>      .
>      .
>      .
>
>      where an X shows eligibility and a blank shows not eligible.
>
>           This is easy to do with PROC REPORT by setting the date variable
>      to ACROSS.  Some users request, though, to have this data put into a
>      flat file for import into Excel.  What I have to do is run a PROC
>      TRANSPOSE on the data and manually change the PUT statement to include
>      the months I want to include.
>
>           My question (finally) is what would be the best way to automate
>      the creation of the flat file?  I assume it would be a macro, but my
>      macro programming is not all that great.
>
>      Thanks in advance for any help.Depending on how elegant you need to be,
I would suggest a CLIST to
allocate and run a background job to  execute a SAS module from a job
scheduler or started task.
I've done this and it seems to well enough.  If you want the CLIST shell
I can cook one up for you pretty quickly.  Let me know
 
P. Haugen, Baltimore, MD