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
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)