Date:         Thu, 8 Nov 2007 22:10:57 -0500
Reply-To:     Ken Borowiak <EvilPettingZoo97@AOL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ken Borowiak <EvilPettingZoo97@AOL.COM>
Subject:      Re: appending SAS dataset with an addition of new column

On Fri, 9 Nov 2007 01:45:47 -0000, Sri <subhadrasri@GMAIL.COM> wrote:

>Hi All,
>I have been trying this for the past couple of days and decided to
>take advise from those who have already been there and did that!
>I have a shell script that runs on daily basis and executes 10
>different SAS programs during the process. When SAS datasets are
>created, they are appended every day to the previous day's datasets
>and the data is preserved for 180 days. Now, i have to add a new
>variable to one of the datasets. But when i append to the previous
>dataset, it gives me a warning saying that the variable is not present
>in the base dataset, therefore it is dropped! Other than using SET
>statement (i don't want to use SET because everyday i have to append
>the data to the previous days data, by using set i will be using lot
>of memory resources), is there a way for me to achevie it? For time-
>being, i changed the new dataset name, but i bet it's a crude way and
>there are many better ways out there to aheive it.
>Please respond to my email at your earliest possible convenince.
>
>Thank you


Sri,

Check out the FORCE option on the PROC APPEND statement.

HTH,
Ken