Date:         Wed, 29 Nov 2000 20:23:39 GMT
Reply-To:     Charles_S_Patridge@PRODIGY.NET
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Charles Patridge <Charles_S_Patridge@PRODIGY.NET>
Organization: Deja.com - Before you buy.
Subject:      Re: combining/appending/merging datasets

Jeff,

Not knowing what all the SAS variables will be in each output dataset
you are creating in Proc Model,

to combine these datasets into 1 dataset do the following:

 data new_comb;
     set  work.ols
          work.sur
          work.m2sls
          work.m3sls;
 run;

If all datasets do not have the same variables, you will have missing
values where variables are not in each dataset.

HTH,
Charles Patridge
Email: Charles_S_Patridge@prodigy.net


In article <903ma8$1mj$1@news.NERO.NET>,
  "Jeff D. Hamann" <hamannj@ucs.orst.edu> wrote:
> How do you combine multiple data sets into a single dataset. I just
want to
> append four datasets together into a new one... for example....
>
> proc model;
>
>     blah, blah, blah.....
>
>  fit lht_growth ld1_growth logitcr /ols covb fsrsq outest=ols;
>  fit lht_growth ld1_growth logitcr /sur covb fsrsq outest=sur;
>  fit lht_growth ld1_growth logitcr /2sls covb fsrsq outest=m2sls;
>  fit lht_growth ld1_growth logitcr /3sls covb fsrsq outest=m3sls;
>
> run;
> quit;
>
> /* this isn't working... */
> data new_comb;
>     merge work.ols
>             work.sur
>             work.m2sls
>             work.m3sls;
> run;
>
> PROC EXPORT DATA= WORK.new_comb
>             OUTTABLE= 'new fits'
>             DBMS=ACCESS97 replace;
>             DATABASE="D:\model2.mdb";
> RUN;
>
> But when the code executes, the last dataset is the only one that's
> there....
>
> ---------------------------------------------------
> Jeff D. Hamann
> 280 Peavy Hall
> Department of Forest Resources
> Oregon State University
> Corvallis, Oregon 97331-8566 USA
> 541-740-5988
> 541-737-2375
> hamannj@ucs.orst.edu
> Jeff.Hamann@orst.edu
>
> This is the song that never ends
> It goes on and on my friends
> Somebody started singing it
> Not knowing what it was
> Now everybody's singing it
> And it goes on and on because
> This is the song that never ends...
>
>

--
Charles Patridge - PDPC, Ltd.
172 Monce Road - Burlington, CT 06013 USA
Phone: 860-673-9278 or 860-675-9026
Email: Charles_S_Patridge@prodigy.net - Web: www.sconsig.com


Sent via Deja.com http://www.deja.com/
Before you buy.