<DD6E10E7633DD111A1CF00805FEA74BE5F045D@xcgca009.b2.masd.northgrum.com> X-LSVTag: From: "Chamberlain, Rex" <CHAMBRE@mail.northgrum.com> X-LSVTag: To: SAS-L@VM.MARIST.EDU, "'Jennie Sauer'" <Jennie_Sauer@USGS.GOV> X-LSVTag: Subject: RE: Adding an observation to an existing dataset X-LSVTag: Date: Tue, 14 Apr 1998 09:15:06 -0700 X-LSVTag: X-Priority: 3 X-LSVTag: Return-Receipt-To: "Chamberlain, Rex" <CHAMBRE@mail.northgrum.com> X-LSVTag: MIME-Version: 1.0 X-LSVTag: X-Mailer: Internet Mail Service (5.0.1458.49) X-LSVTag: Content-Type: text/plain To: $PEER$ <SAS-L@VTVM1.CC.VT.EDU>

Jennie,

Try:

Data One; *read your input data; run;

Data Two; set one; output; *output the input record; if one="d" then do; one="d"; *set values for your added obs; two="d"; three="d"; output; *output your added obs; end; run;

Let me know if this helped, Rex Chamberlain

> ---------- > From: Jennie Sauer[SMTP:Jennie_Sauer@USGS.GOV] > Reply To: Jennie Sauer > Sent: Tuesday, April 14, 1998 9:15 AM > To: SAS-L@VM.MARIST.EDU > Subject: Adding an observation to an existing dataset > > Hi everyone, > > I'd like to be able to add an observation to an already existing > SAS > dataset. The new observation will be based on variables in the > existing > SAS dataset. > > For example: > > Dataset #1 > Variables: one two three > Obs. 1 a b c > Obs. 2 b c a > Obs. 3 d c a > > New data set based on something like--If variable 1 = d then... > Variables: one two three > Obs. 1 a b c > Obs. 2 b c a > Obs. 3 d c a > Obs. 4 a a a > > Thanks for any help. > > Jennie Sauer > jennie_sauer@usgs.gov >