Hi all, I'm not sure if there is any solution that i might have missed out, but just looking for some help. I am trying to make my column variables dynamic. The code is as follows: %Let len = 7;
%Let col = TEST;
%Let colano = %col%str(_ANONMY);
Data help;
Set Work.dataset;
&colano = cats(of new1 - new&len)
Run;
This line: &colano = cats(of new1 - new&len) returns me an error message of ERROR 180-322: Statement is not valid or it is used out of proper order. Is there anyway i can work around it? There are other parts of the code that i would require to use &col elsewhere, which explains why i need 2 lines of macro to separately define them. (I opened OPTIONS SYMBOLGEN and the macro &len seems to be working fine.) Thanks for your time to those who are reading this!
... View more