BookmarkSubscribeRSS Feed
Midi
Obsidian | Level 7

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. 

5 REPLIES 5
alexal
SAS Employee

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

VDD
Ammonite | Level 13 VDD
Ammonite | Level 13

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.

 

Midi
Obsidian | Level 7

But the Thing is ,It's a CSV file , not an Excel one .

 

Is the limitation pose the same problem ?

 

Thank you.

 

Midi
Obsidian | Level 7
This is exactly it.
Midi
Obsidian | Level 7
I want to export it to a file.

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

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
  • 5 replies
  • 2263 views
  • 0 likes
  • 3 in conversation