How to import a large dataset to a library

[rodrichiez]

Hello guys,

I need some help. I have a sas dataset on my desktop, it has more than 31 millions of rows and a 8.66 gb size. I successfully opened it inside a blank sas guide project, but I need to save the all table into a library, I am using export table but it takes too long. 

Any idea? Please help.

[Reeza]

PROC COPY?

proc copy in=work out=myLibrary;
select dataSetName;
run;

It will take time regardless depending on your network connection.

[SASKiwi]

Use the Upload Data Files to Server Task in EG. This will copy your dataset up to the SAS server where you can store it in a SAS library.

[Zeeshansaiyad]

PROC IMPORT Statement. The IMPORT procedure reads external data and writes the data to a SAS data set. ... A fileref is a SAS name that is associated with the physical location of the output file.