Hi !
I'm trying to use a macro variable as part of a column name. The main problem is that the query builder encloses the column name in simple quotes, and therefore doesn't recognise the macro variable as such.
Here is what I have :
a macro variable defined by a user prompt (which can be used, I checked) : YEAR
and a column name which should be : "AGE_&YEAR" => AGE_2010, AGE_2011...
If I try this, SAS writes the following code : AS '"AGE_&YEAR"'... Is there a way to remove those simple quotes ? Other than writing a program, I mean...
Thanks !
... View more