Date: Sun, 30 Apr 2006 11:49:10 -0500
Reply-To: "Gregg P. Snell" <sas-l@DATASAVANTCONSULTING.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Gregg P. Snell" <sas-l@DATASAVANTCONSULTING.COM>
Subject: Re: How to automatically change data name in SET?
Content-Type: text/plain; charset="us-ascii"
There certainly is. Here is one solution you can write and execute with
nothing more than base SAS to avoid the arcane and obscure scl:
proc sql noprint;
select memname into :datasets separated by " "
where libname="SUBRO" and memname like "MYDATA%";
You may need to tweak the where clause to be sure it selects only the tables
you are interested in.
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of lei
Sent: Sunday, April 30, 2006 10:04 AM
Subject: How to automatically change data name in SET?
I have a question. I have a few datasets, say mydata1, mydata2,
mydata3, till mydata&M where M is dymically changing according to
month. For example in March M=3, in April M=4.
So I wrote a program like this but got error message
DO I = 1 TO &m;
The effect I want to achieve is that, for example, for m = 3
for m = 4, it becomes
Is there any way to do this?