CODEWITHSUNDEEP
sasproc
statsguyz
statsguyz

Reputation: 459

Add one additional row to SAS data set

I have the following data:

Person      Variable1        Variable2
001         X32              X45
002         X33              X99

I'd like to add one row to the data set:

Person      Variable1        Variable2
001         X32              X45
002         X33              X99
003         X67              X12

I'd like do so with either a DATA or PROC SQL statement Thanks for any insight

Upvotes: 0

Views: 496

Answers (2)

whymath
whymath

Reputation: 1394

output statement will helps:

data test;
  set test end = eof;
  output;
  if eof then do;
    Person = '003';
    Variable1 = 'X67';
    Variable2 = 'X12';
    output;
  end;
run;

Upvotes: 1

Richard
Richard

Reputation: 27498

SQL INSERT statement works

  insert into mydata values ('003', 'X67', 'X12');

Upvotes: 1

Related Questions