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