Sorry. try this one: data have; input VARIABLE_A :VARIABLE_B :$2. VARIABLE_C ; cards; 1 aa 123 2 aa 235 3 bb 453 4 dd 111 5 ss 123 6 sf 234 7 ad 234 8 ae 675 9 ss 222 10 ss 123 11 ee 877 12 aa 123 13 aa 235 14 bb 453 15 dd 111 16 ss 123 17 sf 234 18 ad 234 19 ae 675 20 ss 222 21 ss 123 22 ee 877 23 ss 123 24 bb 453 25 dd 111 26 ss 123 27 sf 234 28 ad 234 29 ae 675 ; proc sql outobs=10; create table random10 as select * from have where variable_a not in (1,2,3,4,5) order by ranuni(99); reset outobs=15; create table random10_15 as select * from have where variable_a in (1,2,3,4,5) union all select * from random10; quit; proc sort data=random10_15;by variable_a; proc print;run;
... View more