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.


Tips Talk:Two steps in one with Proc SQL – summarize and create macro variable

From sasCommunity
Jump to: navigation, search

good tip. --Don Henderson 14:23, 1 June 2011 (UTC)


good tip .. but .. two things: (1) why name the output variable and (2)why not use noprint? i.e.

 proc sql noprint;
   select count(sex) into :male_cnt 
     from sashelp.class
       where sex = 'M';
 quit;

--Art T 22:38, 1 June 2011 (UTC)


Nice tip.--Murphy Choy From Singapore 02:40, 6 June 2011 (UTC)


Murphy: I think we will be promoting undesirable programming skills if we promote this one before Sunil responds to my concerns.--Art T 19:49, 6 June 2011 (UTC)


Hi Art. Yes, I agree with your enhancements since naming the output variable and printing the Proc SQL result are not required. Shall I modify the tip? How does this work? --Sunil Gupta, 05:17, 20 June 2011


Promoted --Art T 14:28, 20 June 2011 (UTC)