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:
>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.
Check out the FORCE option on the PROC APPEND statement.