I'm really struggling here to figure out exactly how I can accomplish something that seems rather simple with a macro.
I am using manipulating multiple datasets which are named very similarly. Basically something along the lines of text01text01, then the next would be text01text02 and so on, until text02text01, etc. The "text" part doesn't change, just the numbers. Right now, it takes a lot of code to accomplish this, such as:
data text01text01;
set here.text01text01;
var x=var y;
...
run;
data text01text02;
set here.text01text02;
var x=var y;
...
run;
So...how do I setup a macro so I don't have to repeat this code for every dataset I read in? I have looked around and tested some things out but I'm having trouble putting a macro into the name of the dataset. Anyone have any suggestions?
Thanks in advance,
Michael