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..
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.