topic Re: How to add new data to an existing dataset in EG? in SAS Enterprise Guide

How to add new data to an existing dataset in EG?

Andalusia — Wed, 13 Oct 2021 09:35:49 GMT

This is my current dataset (an example so you can reproduce my case, the real one is much bigger):

data have;
infile datalines truncover;
input type $ model $;
datalines;
XX-1 Light
XX-2 Heavy
XX-3 Heavy
XX-4 Heavy
XX-5 Slim
XX-6 Light
XX-7 Heavy
;

I want to add two lines of data to it:

XX-8 Light
XX-9 Slim

Re: How to add new data to an existing dataset in EG?

Kurt_Bremser — Wed, 13 Oct 2021 10:20:51 GMT

Create a new dataset, and append it:

data have;
infile datalines truncover;
input type $ model $;
datalines;
XX-1 Light
XX-2 Heavy
XX-3 Heavy
XX-4 Heavy
XX-5 Slim
XX-6 Light
XX-7 Heavy
;

data new;
infile datalines truncover;
input type $ model $;
datalines;
XX-8 Light
XX-9 Slim
;

proc append
  base=have
  data=new
;
run;