Inserting new row into dataset

[R_Win]

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

[andreas_lds]

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.

[abdullala]

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.