topic randomly access a observation from data set in SAS Enterprise Guide

randomly access a observation from data set

deleted_user — Fri, 13 Feb 2009 10:17:22 GMT

proc sql;
insert into TableA select * from TableB where obsnum=2;
quit;

i have to fetch row no 2 from TableB and append it to TableA.

here obsnum is not working pleae tell me other option..

Re: randomly access a observation from data set

GertNissen — Fri, 13 Feb 2009 10:35:08 GMT

PROC surveyselect data=TableB method=srs n=4 out=sample1;
RUN;

proc append data=sample1 base=TableA; run;

Re: randomly access a observation from data set

deleted_user — Fri, 13 Feb 2009 13:24:32 GMT

proc sql;
insert into TableA select * from TableB(obs=2 firstobs=2) ;
quit;