LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous (more recent) messageNext (less recent) messagePrevious (more recent) in topicNext (less recent) in topicPrevious (more recent) by same authorNext (less recent) by same authorPrevious page (October 2011, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Thu, 6 Oct 2011 13:44:04 -0500
Reply-To:   Joe Matise <snoopy369@GMAIL.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Joe Matise <snoopy369@GMAIL.COM>
Subject:   Re: conditionally create ads
Comments:   To: Pamela Butler <pamela.butler@sanofi-aventis.com>
In-Reply-To:   <201110061829.p96G7BjN000825@waikiki.cc.uga.edu>
Content-Type:   text/plain; charset=ISO-8859-1

proc sql; select count(variable) into :varcount from datasetname; quit;

%if &variable > 0 %then %do; data want; <whatever>; run; %end;

Assuming you're in a macro. If you're not in a macro, you can do this via CALL EXECUTE in a datastep.

-Joe

On Thu, Oct 6, 2011 at 1:29 PM, Pamela Butler <pamela.butler@sanofi-aventis.com> wrote: > I need to conditionally create a permanent dataset if a particular > variable in my temporary dataset is NOT missing for all observations. Any > suggestions on how to do this? >


Back to: Top of message | Previous page | Main SAS-L page