How to insert data in speicfic observation(nth observation) in a dataset.?
Hi ...
Do you mean you want to add a row to a dataset after a specific observation???
If yes...Here is the way..
data test;
input id name$;
cards;
100 aaa
101 bbb
103 ddd
;
run;
Now i want to add a row after 2nd observation.
data test1;
set test;output;
if _n_=2 then do;
id=102;
name="ccc";
output;
end;
run;
proc print;
run;
Thanks&Regards..
Sanjeev.K
Hi ...
Do you mean you want to add a row to a dataset after a specific observation???
If yes...Here is the way..
data test;
input id name$;
cards;
100 aaa
101 bbb
103 ddd
;
run;
Now i want to add a row after 2nd observation.
data test1;
set test;output;
if _n_=2 then do;
id=102;
name="ccc";
output;
end;
run;
proc print;
run;
Thanks&Regards..
Sanjeev.K
Thanks a lot.I need that..
Nope..
please mark my answer as a correct answer..
Thanks..
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and save with the early bird rate—just $795!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.