SAS Studio

Write and run SAS programs in your web browser
BookmarkSubscribeRSS Feed
bhaskarkothavt
Obsidian | Level 7

Dear SAS Community,

I'm encountering an error while running a PROC EXPORT step in SAS Studio using Viya 4. The step attempts to export a dataset with approximately 1 million observations and 38 columns to a CSV file. I'd greatly appreciate your assistance in resolving this issue.
Here's the specific error message I'm receiving :

bhaskarkothavt_0-1721135275227.png

Here is the code that i used:

filename exprt filesrvc folderpath="/AAI/College of Engineering/Data Requests" filename="Policy91_CE_Final_Data.csv";

proc export
data=final_data
dbms=csv
outfile=exprt
replace;
run;

Additional Information:

I've verified that the user running SAS Studio has write permissions to the target directory.
No other applications are currently using the target CSV file.
I've double-checked the file path specified in the PROC EXPORT statement for any typos.
Has anyone else encountered a similar issue when exporting large datasets with PROC EXPORT in Viya 4? Any insights or suggestions would be extremely helpful.

Thank you for your time and support!

Best Regards,
Bhaskar

 

6 REPLIES 6
ballardw
Super User

Are there any file size limits in place? Total user space allocations? That one file is likely to be well over 30Mb and may be having issues with space allotment.

ChrisHemedinger
Community Manager

I see that you are exporting to your SAS Content folders and not to a native file system. Is that what you want? Where will this CSV file be needed?

 

If you have access to an a file storage location instead, I'd try to export to there. If you want to export this only to ultimately download it, maybe you can use a temp file location instead.

Register for SAS Innovate 2025!! The premier event for SAS users, May 6-9 in Orlando FL. Sign up now for the best deals!
bhaskarkothavt
Obsidian | Level 7
Currently we have windows file server as storage location but we cannot able to connect using viya directly so we end moving it SAS Contents and downloading.
ChrisNZ
Tourmaline | Level 20

Ask your administrator if there is a 30 second timeout limit.

bhaskarkothavt
Obsidian | Level 7
We checked the timeout limit as 3600
SASKiwi
PROC Star

I suggest you try testing your EXPORT program on Viya 4 storage. If it works there reliably then you can assume the problem lies with Windows folder share and is not actually a SAS problem.

sas-innovate-white.png

Our biggest data and AI event of the year.

Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.

Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

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
  • 6 replies
  • 1816 views
  • 1 like
  • 5 in conversation