BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Hi

I've a macro variable created with

%let valqtr = 08q2;

I want to create a straight up variable referencing the macro value

example:

pstqtr = "&valqtr";

The result i intend to get is

pstqtr = 08q2

Please tell me how i can do that
1 REPLY 1
Peter_C
Rhodochrosite | Level 12
it would have been helpful to know what you have tried....
In what context do you want to use this macro variable?
Would it be in a where clause, logic test, assignment statement, E.G., WRS, ....?

Have you tried
pstqtr = "&valqtr" ;

or

pstqtr = "%sysfunc( inputn(&valqtr, yyq4))";
How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 879 views
  • 0 likes
  • 2 in conversation