Date: Fri, 2 Apr 2004 07:34:52 -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?
Content-Type: text/plain; charset="us-ascii"
Ross,
No! Removing the FORCE will cause Append to produce an error message annd
stop. See the last sentence in my previous msg.
Dennis
"Ross, Michael D" <michael.ross@astrazeneca.com>
04/01/2004 11:20 AM
To: "'diskin.dennis@kendle.com'" <diskin.dennis@kendle.com>
cc: SAS-L@LISTSERV.UGA.EDU
Subject: RE: Append Question?
Thanks. If I remove the FORCE option - do you think that would do the
trick also?
-----Original Message-----
From: diskin.dennis@kendle.com [mailto:diskin.dennis@kendle.com]
Sent: Thursday, April 01, 2004 11:00 AM
To: Ross, Michael D
Cc: SAS-L@LISTSERV.UGA.EDU
Subject: Re: Append Question?
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
