Is anyone of you know SAS LANGUAGE
Is the
Proc sql innobs=1 ; is the statement who let the user request to get the only one rows from the Oracle SQL REQUEST or for the SAS DATA SET only one row
for instance table 1 has got 50000 rows
when we do
proc sql innobs=1 ;
proc sql;
select * from table 1 ;
quit ;
Does SAS make the entire CURSOR for 5000 rows and place the all rows in the SASWORK and take the only one row for the display of the result ??
Or Does SAS make place the one row in the SAS WORK ???
Thanks for the reply
Sidnet