topic Re: How to Export Large Data Set Using Viya ? in SAS Studio

How to Export Large Data Set Using Viya ?

Midi — Wed, 24 Jul 2019 13:00:00 GMT

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.

Re: How to Export Large Data Set Using Viya ?

alexal — Wed, 24 Jul 2019 13:09:29 GMT

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

Re: How to Export Large Data Set Using Viya ?

VDD — Wed, 24 Jul 2019 13:17:32 GMT

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.

Re: How to Export Large Data Set Using Viya ?

Midi — Wed, 24 Jul 2019 19:18:12 GMT

This is exactly it.

Re: How to Export Large Data Set Using Viya ?

Midi — Wed, 24 Jul 2019 19:19:40 GMT

I want to export it to a file.

Re: How to Export Large Data Set Using Viya ?

Midi — Fri, 26 Jul 2019 13:00:20 GMT

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

Is the limitation pose the same problem ?

Thank you.