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.


Main Page Test

From sasCommunity
Jump to: navigation, search
banner_text.gif banner_image.jpg

Welcome to sasCommunity.org! - 2012 Conference Chair

icon_globe_large.gif

Requests for Applications for the SAS Global Forum 2012 Conference Chair now being accepted. Read more ...

Announcing - registration is NOW OPEN for SAS Global Forum 2009.

See the archive of prior Main Page articles.


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




Join sasCommunity.org Get Involved Sasopedia Events User Groups

View the web-site usage statistics and the definition of terms used in that report.