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 19

From sasCommunity
Jump to: navigation, search

sasCommunity Tip of the Day

Two steps in one with Proc SQL – summarize and create macro variables

Wouldn't be nice to summarize the data and save the results to a macro variable in one Proc SQL step? You can by directing results from the COUNT() summary function to the INTO: keyword. From the Proc SQL code below, all male records are counted and saved to the male_cnt macro variable. While this example shows one summary function and one macro variable, you can also apply other summary functions such as AVG(), MIN(), or MAX() to create three more macro variables. Just remember to separate each summary function and macro variables by commas and maintain the variable order. You still only need to have one INTO keyword.

proc sql noprint;
    select count(sex) into :male_cnt 
    from sashelp.class
    where sex = 'M';
quit;
%put 'Number of Males = ' &male_cnt;

Sunil Gupta


Submitted By Sunil Gupta



Feel free to comment on this tip.


Prior tip - Next tip - Random Tip

Submit a Tip