|Date: ||Tue, 16 Apr 1996 10:19:00 -0700|
|Reply-To: ||Christopher Scott <Christopher_C_Scott@CCMAIL.FH.COM>|
|Sender: ||"SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>|
|From: ||Christopher Scott <Christopher_C_Scott@CCMAIL.FH.COM>|
|Subject: ||Help on automating flat file|
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.