How to Export Large Data Set Using Viya ?

[Midi]

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. 

[alexal]

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

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]

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

Is the limitation pose the same problem ?

Thank you.

[Midi]

This is exactly it.

[Midi]

I want to export it to a file.