Hello Everyone .
I'm New to SaS and so to SAS viya , and i have a large data set to export (it includes 7 million obervations) , but the thing is , so far the only way to export it through SaS viya was to split it into multiple subsets , and it's not very convenient i have to say.
So , does anyone know how this Could be Achieved ?
Thank you in advance.
@Midi ,
Let me clarify something. There is a table that has been loaded to the CAS server, that you want to export to a file? I'm getting it right?
when you say sheets I auto think Excel.
Your issue is Excel limits not SAS.
Exporting to CSV, TXT or such will work with 500 million + records. But xls has its own limits so MS needs to address those issues in the limits.
But the Thing is ,It's a CSV file , not an Excel one .
Is the limitation pose the same problem ?
Thank you.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.