Date: Tue, 19 Jul 2005 07:28:24 -0600
Reply-To: Alan Churchill <SASL001@SAVIAN.NET>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Alan Churchill <SASL001@SAVIAN.NET>
Subject: Re: combining data between different data sets
In-Reply-To: <1121778660.774110.44020@o13g2000cwo.googlegroups.com>
Content-Type: text/plain; charset="US-ASCII"
What are the sizes of the datasets? This is a critical factor.
Thanks,
Alan
Savian
"Bridging SAS and Microsoft Technologies"
http://www.savian.net
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of rss
Sent: Tuesday, July 19, 2005 6:11 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: combining data between different data sets
Hi,
I'm trying to add data from 1 data set to another without having to
merge the data together. Consider the following:
First data set:
tot_ tot_
Obs DATE tot_div sales purchases cashstart cashend
1 2002-12-31 0.00 9617609 -9617604 0.00 5.00
2 2003-01-31 17028.50 789484 -991358 5.00 -184840.50
3 2003-02-28 20471.25 667704 -687500 -184840.50 -184165.25
4 2003-03-31 12244.84 760469 -729916 -184165.25 -141367.42
5 2003-04-30 12764.50 0 0 -141367.42 -128602.92
Second dataset:
Obs DATE TICKER startshare endshare trade
1 2002-12-31 *$$$ 0 -9617609 -9617609
41 2003-01-31 *$$$ -9617609 -9617609 0
81 2003-02-28 *$$$ -9617609 -9617609 0
121 2003-03-31 *$$$ -9617609 -9617609 0
161 2003-04-30 *$$$ -9617609 -9617609 0
Problem: set startshare and endshare to =tot_cashstart and tot_cashend
but just for when ticker = '*$$$'. I was told I have to merge the two
data sets and there must be some other way.
Thanks for your help
