As the first step in the decommissioning of sasCommunity.org the site has been converted to read-only mode.


Here are some tips for How to share your SAS knowledge with your professional network.


Tip of the Day:July 21

From sasCommunity
Revision as of 22:10, 17 July 2011 by Frankfry (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

sasCommunity Tip of the Day

One way to build a concatenated list and store it in a macro variable is to use the RESOLVE function with CALL SYMPUT:

%let namelist=;
data _null_;
    set sashelp.class;
    call symput('namelist', trim(resolve('&namelist'))||' '||trim(name));
run;
%put &namelist;

NOTE: The resulting macro variable must be no longer than 64,000 characters.

This can also be done in PROC SQL:

proc sql noprint;
    select trim(name) into :namelist separated by ' ' from sashelp.class;
quit;

The data step approach may be preferred if additional logic is needed to determine or select the values to be included.

Submitted By Otterm1



Feel free to comment on this tip.


Prior tip - Next tip - Random Tip

Submit a Tip