This first example shows
how you can read the large HP Neoview table, FLIGHTS98, to create
and populate a SAS data set, SASFLT.FLT98:
libname sasflt 'SAS-library';
libname net_air neoview DSN=air2 user=louis
pwd=fromage schema=FLIGHTS;
proc sql;
create table sasflt.flt98
as select * from net_air.flights98
(bulkextract=YES bl_system=FLT0101);
quit;
This next example shows
how you can append the contents of the HP Neoview table, ALLFLIGHTS,
to an existing SAS data set, SASFLT.FLT98. The BL_USE_PIPE=NO option
forces
SAS/ACCESS Interface to HP Neoview to read data from a flat
file, as specified in the BL_DATAFILE= option. Rather than deleting
the data file, BL_DELETE_DATAFILE=NO causes the engine to leave it
after the extract has completed.
proc append base=sasflt.flt98
data=net_air.allflights
(BULKEXTRACT=YES
BL_DATAFILE='/tmp/fltdata.dat'
BL_USE_PIPE=NO
BL_DELETE_DATAFILE=NO);
BL_SYSTEM=FLT0101
run;