BookmarkSubscribeRSS Feed
dwights
Fluorite | Level 6

I'm trying to append a macro variable's value to a macro list, Can someone please let me know if it's possible. TIA

 

 

%macro  BestDeveloper(table1);





proc sql;

select developer_id into :DevelopersList separated by ' ' from table1;

quit;





%let best_developer = 1125863416;



/*    Code to append macro variable best_developer's value to the macro-list DevelopersList    */                                                



/*

***********Unrelated code*********     */





%mend;

%BestDeveloper(developerTable);



1 REPLY 1
Amir
PROC Star

Do you mean something like the following:

 

proc sql noprint;
   select
      name
   into
      :name_list separated by ' '
   from
      sashelp.class
   ;
quit;

%let extra_name = ZZZ;

%let name_list = &name_list &extra_name;

%put name_list = &name_list;

 

Amir.

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

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
  • 5474 views
  • 3 likes
  • 2 in conversation