BookmarkSubscribeRSS Feed
Jambo
Calcite | Level 5
Hello,
I want to know if it is possible to download for example ten files( . CSV) from sas studio to my local machine?
Now i use the option to click in my file and then upload to my local machine but I have many files likes twenty files so I dont want to do this for each files becaude its's so long
Mayby I can use proc export but I dont know how... Please help me
Thank u
2 REPLIES 2
tarheel13
Rhodochrosite | Level 12

https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=proc&docsetTarget=n045uxf...

 

There's the documentation for proc export. You could write a macro with a do loop or else just write the macro and call it for every dataset you want to export.

ballardw
Super User

@Jambo wrote:
Hello,
I want to know if it is possible to download for example ten files( . CSV) from sas studio to my local machine?
Now i use the option to click in my file and then upload to my local machine but I have many files likes twenty files so I dont want to do this for each files becaude its's so long
Mayby I can use proc export but I dont know how... Please help me
Thank u

One of the 'joys" of client/server is that often the server side doesn't play well with your local computer. So if you are working in an environment like that, where you can't write proc export to write one file to your local machine then you won't be able to do multiple files without additional actions.

 

One possibility would be creating some network disk share location where both your local computer and the server have access to. This might be easiest if your admins are helpful and your overall system is flexible enough. Security often raises its head in these situations about who has what access where and how though. You might be able to create share from your local computer but getting the server to see it may be tricky.

 

Another might involving writing the files to a folder on the server and then possibly you can use a manual step to copy the whole folder.

 

Grumpy old fart comment: I have to laugh in a curmudgeonly fashion about point and click 20 times is "too long" for a computer operation. I used to have to punch a deck of cards and hand them to an assistant at the computer center to run a job. They would wait until they had a number of jobs that used the same compiler so they would run faster. Quite often turn around was measured in hours.

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 782 views
  • 0 likes
  • 3 in conversation