Date: Mon, 14 Nov 2011 06:24:16 -0700
Reply-To: "Adams, Nicholas" <NRAdams@CVTY.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Adams, Nicholas" <NRAdams@CVTY.COM>
Subject: Looping macro linked to spreadsheet
Content-Type: text/plain; charset="US-ASCII"
I currently have a sas program where you enter a group number, start
date, and end date as a macro variable. The program runs through a
bunch of proc sql, data steps, and exports. I babysit the program until
its done, then enter another group number, and dates and run it again.
I'm looking to make my life easier and was wondering if there was a way
I could enter a list of group numbers, start dates, and end dates into a
spreadsheet and have my sas program import this data and loop once
through my program for each row in the spreadsheet. I tried doing some
searches for this topic but couldnt find what I was looking for.
Thanks for any suggestions.
Email Confidentiality Notice: The information contained in this transmission is confidential, proprietary or privileged and may be subject to protection under the law, including the Health Insurance Portability and Accountability Act (HIPAA).
The message is intended for the sole use of the individual or entity to whom it is addressed. If you are not the intended recipient, you are notified that any use, distribution or copying of the message is strictly prohibited and may subject you to criminal or civil penalties. If you received this transmission in error, please contact the sender immediately by replying to this email and delete the material from any computer.