LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (June 1999, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Wed, 23 Jun 1999 11:44:31 -0400
Reply-To:   "Paul M. Dorfman" <sashole@EARTHLINK.NET>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   "Paul M. Dorfman" <sashole@EARTHLINK.NET>
Organization:   KInPh
Subject:   Re: Adding rows to SAS dataset
Comments:   To: Peter_Baade@HEALTH.QLD.GOV.AU
Content-Type:   text/plain; charset=koi8-r

Peter Baade <Peter_Baade@HEALTH.QLD.GOV.AU> wrote:

>Given that I have a SAS dataset with, say, 100 rows with 5 variables. Is there a simple way to add another row >to that dataset (to make it 101 rows) with values for each of those five variables?

Peter,

The simplest and, I guess, the most direct way is to use SQL:

DATA A; INPUT A B $ C D $; CARDS; 1 A 3 B 2 C 4 D 5 E 6 F ; RUN;

PROC SQL; ** insert; INSERT INTO A VALUES (7 'G' 8 'H'); ** show result; SELECT * FROM A; QUIT;

A B C D ---------- 1 A 3 B 2 C 4 D 5 E 6 F 7 G 8 H

Kind regards, ======================= Paul M. Dorfman Jacksonville, FL =======================


Back to: Top of message | Previous page | Main SAS-L page