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 (March 1996, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Mon, 25 Mar 1996 15:33:00 MST
Reply-To:     mullinb{DHWTOWERS/TOWERS2/mullinb}@DHW.STATE.ID.US
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         "Brian O. Mullin"
              <mullinb{DHWTOWERS/TOWERS2/mullinb}@DHW.STATE.ID.US>
Subject:      Adding a record to a SAS data set in a D

Hi SAS-Lers I wish to add a record or records to a SAS data set, called MASTER within a Data Step. I have come up with 2 methods, neither of which I like very well. Although, the 2nd is better than the first.

Method 1 Create a second data set, called B using a cards statement, infile, ect and in a third data step use a set statement to read both MASTER and B;

Method 2 Use the insert into statement in Proc SQL . However, given my situation I end up creating a data step after the Proc SQL to perform additional data step operations.

I only need to add 1 record to the data set MASTER and do not really want to create an additional data set, and data step, if it is not necessary. Does any one have any suggestions? Perhaps something akin to SQL's insert into, but in a data step.

Thanks in advance,

---- | | Brian O. Mullin | | Idaho Division of Health, | \ Center for Vital Statistics | |and Health Policy | \ | \/\ \ \ | \/\ / \ / -----/\ / | \ | | | | :) | | Boise | | | | | --------------------------- mullinb{dhwtowers/towers2/mullinb}@dhw.state.id.us


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