Date:         Thu, 1 Apr 2004 11:00:14 -0500
Reply-To:     diskin.dennis@KENDLE.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Dennis Diskin <diskin.dennis@KENDLE.COM>
Subject:      Re: Append Question?
Comments: To: "Ross, Michael D" <michael.ross@ASTRAZENECA.COM>
Content-Type: text/plain; charset="us-ascii"

Yes Ross, that's exactly what happens. You are using the FORCE option in
the append which tells it to procede even though the two files are
different.
If you raelly want the maximum number of variables, you are going to have
to do a datastep and SET the two files together.

HTH,
Dennis Diskin





"Ross, Michael D" <michael.ross@ASTRAZENECA.COM>
Sent by: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
04/01/2004 10:52 AM
Please respond to "Ross, Michael D"


        To:     SAS-L@LISTSERV.UGA.EDU
        cc:
        Subject:        Append Question?


Hi All,

This array gets run after each of my programs. The first program has 16
variables appended to totrep, however, the next program has 25 variables
and
is only appending 16. Will PROC APPEND drop variables on the second run if
they are not on the Base file?

PROGRAM 1:

Data Report (keep=outvar1-outvar16);
'some Code';
run;


proc append base=totrep
data=report(keep=outvar1-outvar&MAXOUT)
force;
run;

PROGRAM 2:

Data Report (keep=outvar1-outvar25);
'some Code';
run;

proc append base=totrep
data=report(keep=outvar1-outvar&MAXOUT)
force;
run;

Mike