topic adding a row by using DATA step in SAS Programming

adding a row by using DATA step

kuridisanjeev — Wed, 25 Jan 2012 17:59:57 GMT

Hi..

i want to add another row to the above data by using data step ...

Thanks in Advance....

(DATA AFTER ADDING THE ROW)

Linlin — Wed, 25 Jan 2012 18:12:38 GMT

How about:

data have;

input ID$ NAME $ MARKS ;

cards;

100 SANJEEV 23

101 SRINATH 25

102 SRIHARI 28

;

data want;

length name $ 8;

set have end=eof;

output;

if eof then do;

id='103';

name='SRIKANTH';

marks=30;

output;

end;

run;

proc print;run;

Obs name ID MARKS

1 SANJEEV 100 23

2 SRINATH 101 25

3 SRIHARI 102 28

4 SRIKANTH 103 30

Linlin

imanojkumar1 — Fri, 04 Nov 2016 11:11:40 GMT

What if I want to add a row before first row in the above sample data?

Also if I sort it by Names and then want to imput a row before first row, how can it be done?

marcomonti — Fri, 16 Mar 2018 14:10:54 GMT

Try with double dataset in set statement:
data want;
set have1
have2;
run;

note:have1 and have2 should have same PDV.