topic Re: How We can Upload data on server Quickly? in SAS Programming

How We can Upload date on server Quickly?

ImPrasad — Mon, 14 Sep 2015 09:33:29 GMT

Hello Friends,

I am a beginer in SAS.Recently I have checked the option READBUFF while DOWNLOADING the data from SERVER.Which really worked fanatastic.

My questions are as below:

1)Do we have any option to upload the data on server from local machine through SAS.

2)Why I am unable to use readdbuff statement while assigning library on local machine .

E.g.

libname dc "D:\Prasad\DC" readbuff=32000;

error message:

984 libname dc "D:\Prasad\DC" readbuff=32000;
--------
22
ERROR: Libname DC is not assigned.
ERROR: Error in the LIBNAME statement.
ERROR 22-7: Invalid option name READBUFF.

Thanks,

Prasad Devasthali

Business Analyst

HDFC Bank

Re: How We can Upload date on server Quickly?

Kurt_Bremser — Mon, 14 Sep 2015 10:25:11 GMT

READBUFF= is valid only for assigning libnames with SAS/ACCESS for Relational Databases. It is not valid for standard SAS libraries (directories that contain SAS datasets.

Do a google search for "SAS readbuff libname option"

What are you trying to do anyway, in detail?

Re: How We can Upload data on server Quickly?

ImPrasad — Mon, 14 Sep 2015 10:41:14 GMT

What is the wayout then??How could we upload data on server in batch mode?

Re: How We can Upload data on server Quickly?

Kurt_Bremser — Mon, 14 Sep 2015 10:48:05 GMT

Please read my post:

"What are you trying to do anyway, in detail?"

Without further knowledge nobody will be able to give a valid answer to your very unspecific question.

Re: How We can Upload data on server Quickly?

ImPrasad — Mon, 14 Sep 2015 11:22:27 GMT

I want to upload large data on server.Its a bimonthly activity data size is approx. 6 GB and it always take amount of time while loading through data set statement.

Is there any wayout for the same??I have used Readbuff statement while downloading the data from server.Is there any option available for fast ulpoading of data??

Re: How We can Upload data on server Quickly?

Kurt_Bremser — Mon, 14 Sep 2015 11:26:07 GMT

How about simply copying the dataset with SFTP?

Re: How We can Upload data on server Quickly?

SASKiwi — Mon, 14 Sep 2015 20:26:56 GMT

What sort of server do you want to update? If it's a non-SAS server then you could try the INSERTBUFF= option to improve performance.