Date: Mon, 2 May 2005 07:11:20 -0400
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Dennis Diskin <ddiskin@GMAIL.COM>
Subject: Re: Append Datasets and add an additional variable
Content-Type: text/plain; charset=ISO-8859-1
Something like the below untested code should do it. This could be put
in a macro to make it easier for various months.
retain _day 1;
do while (not _in(_day));
_day + 1;
rundate = mdy(1,2005,_day);
On 5/1/05, sa polo <email@example.com> wrote:
> Hi All,
> I have a bunch of datsets like ----
> I need to read all these datasets into one dataset say abcdjan05(this dataset does not exist),
> an additional variable called rundate needs to be added to
> the abcdjan05 dataset which has the date(01jan05 02jan05......) from each of the datasets along with the other variables already present in the datasets so that we know the origins of each variable.
> Any help is much appreciated as always.