Date:         Mon, 14 May 2007 08:32:46 +0100
Reply-To:     Guido T <cymraegerict@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Guido T <cymraegerict@GMAIL.COM>
Subject:      Re: [sug-l] Help Reqd : Using Call Execute
Comments: To: SAS_learner <proccontents@gmail.com>
In-Reply-To:  <c2192a610705110658o45512e6fy33e5e456400481f2@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

Hi,

I'd put all the CALL EXECUTE stuff into one string variable, it can
help with debugging.  The problem is most likely due to AE not being
on the input dataset.  You'll either have to live with the error or
set AE to missing before the SET statement.  If AE is a numeric, it
will just be a simple assignment, if it's character then you'll need
to set the length of the AE field to avoid trucation.

Given AE looks like an important field that really should be on the
dataset, perhaps you should look in SASHELP.VCOLUMN to determine which
datasets have all the columns that are required ...

proc sql;
    create table datasets as
        select libname, memname
        from sashelp.vcolumn
    where libname eq 'FROM' and upcase(name) in ('AE,'CONMED',MHIS', 'PE')
    group by libname, memname
    having count(*) eq 4
    ;

DATASETS should just contain the names of the datasets that have all
of the requried field.

Regards
++ Guido

On 11/05/07, SAS_learner <proccontents@gmail.com> wrote:
> This guys posted it somewhere may be some body might help him in this forum
>
> ---------- Forwarded message ----------
> From: naveen kumar <naveen.badugu@gmail.com>
> Date: May 11, 2007 3:29 AM
> Subject: [sug-l] Help Reqd : Using Call Execute
> To: The sug-l mailing list <sug-l@listserv.unc.edu>
>
> data _null_;
>       set sashelp.vtable(where=(libname='FROM'));
>       call execute('data TARGET.'||memname||';');
>       call execute('keep AE CONMED MHIS PE;');
>       call execute('set FROM.'||memname||';');
>       call execute('run;');
> run;
>
> After running this code I get
> The variable AE in keep has never been referenced. How to make this error
> free.
>
> ---
> The Research Triangle SAS Users' Group(RTSUG)website:
> http://rtpnet.org/~rtsug
> ---
> You are currently subscribed to sug-l as: proccontents@gmail.com
> The List Administrator is Malachy J. Foley: Foley@UNC.EDU
> To post to the group list, address your email to: SUG-L@listserv.unc.edu
> To subscribe to the group's listserv, click here:
> http://lists.unc.edu/read/all_forums/subscribe?name=sug-l
>
>
> To unsubscribe send a blank email to
> leave-15666425-9174284D@listserv.unc.edu
>