DATA Step, Macro, Functions and more

How We can Upload date on server Quickly?

Reply
Occasional Contributor
Posts: 12

How We can Upload date on server Quickly?

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

Super User
Posts: 6,946

Re: How We can Upload date on server Quickly?

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?

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Occasional Contributor
Posts: 12

Re: How We can Upload data on server Quickly?

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

Super User
Posts: 6,946

Re: How We can Upload data on server Quickly?

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Occasional Contributor
Posts: 12

Re: How We can Upload data on server Quickly?

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??

 

Super User
Posts: 6,946

Re: How We can Upload data on server Quickly?

How about simply copying the dataset with SFTP?

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Super User
Posts: 3,111

Re: How We can Upload data on server Quickly?

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.

Ask a Question
Discussion stats
  • 6 replies
  • 323 views
  • 0 likes
  • 3 in conversation