topic Re: Inserting new row into dataset in SAS Procedures

Inserting new row into dataset

R_Win — Tue, 24 Nov 2009 10:28:20 GMT

Hi,

Data X;
Input id$;
cards;
A
B
D
E
Run;

output:
A
B
C
D
E
F

now i want to insert C after B.with out splitting the dataset

Re: Inserting new row into dataset

andreas_lds — Tue, 24 Nov 2009 11:38:07 GMT

Your problem can be solved by using IF- and OUTPUT-statement:
[pre]
data x;
set x;
output; /* (1) */
if id = 'B' then do;
id = 'C';
output;
end;
run;[/pre]
(1): Automatic output is disabled as soon as one output-statement is coded.

Re: Inserting new row into dataset

abdullala — Tue, 24 Nov 2009 15:57:44 GMT

I dont think you can achieve that within one data-input-cards-... step for this purpose. use proc sql insert into and order. this should do both inserting and sorting in one step systematically.