Desktop productivity for business analysts and programmers

Using macro variable to rename column in query builder

Reply
N/A
Posts: 1

Using macro variable to rename column in query builder

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 !
Respected Advisor
Posts: 4,130

Re: Using macro variable to rename column in query builder

Hi

Tried out what you've described. The code generated looks actually like:
'"AGE_&YEAR"'n

This 'n' means that the string is interpreted as literal. Seems that SAS R&D was quite thoughtful in allowing us to define all kind of variable names but didn't anticipate your use case.
Haven't found any option like "treat variable names as literals" which could be unchecked so I believe the current version of EG's query builder doesn't allow you what you try to do.

You could define the variable label this way though by passing the macro var without quotes: AGE_&YEAR

HTH
Patrick
Ask a Question
Discussion stats
  • 1 reply
  • 141 views
  • 0 likes
  • 2 in conversation