Hi..
ID | NAME | MARKS |
100 | SANJEEV | 23 |
101 | SRINATH | 25 |
102 | SRIHARI | 28 |
i want to add another row to the above data by using data step ...
Thanks in Advance....
(DATA AFTER ADDING THE ROW)
ID | NAME | MARKS |
---|---|---|
100 | SANJEEV | 23 |
101 | SRIHARI | 25 |
102 | SRINATH | 28 |
103 | SRIKANTH | 30 |
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
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
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?
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.