topic Re: Is There Any Way To Export A large DataSet of more than 100MB from SAS (Remote Machine) to Local in SAS Programming

Is There Any Way To Export A large DataSet of more than 100MB from SAS (Remote Machine) to Local ?

Midi — Wed, 18 Dec 2019 15:17:30 GMT

Hello EveryOne , I'm Working on a remote working development machine , and i have a large dataset that weights more than 100MB and i want to export it to my local Pc (as an xlsx File) , is there a practical way to do it ? , thank you .

Re: Is There Any Way To Export A large DataSet of more than 100MB from SAS (Remote Machine) to Local

Kurt_Bremser — Wed, 18 Dec 2019 15:27:20 GMT

100MB is most probably more rows than Excel can even work with.

Re: Is There Any Way To Export A large DataSet of more than 100MB from SAS (Remote Machine) to Local

Midi — Wed, 18 Dec 2019 15:29:11 GMT

well , in reality they are only 8000 rows.

Re: Is There Any Way To Export A large DataSet of more than 100MB from SAS (Remote Machine) to Local

PaigeMiller — Wed, 18 Dec 2019 15:35:03 GMT

and how many columns?

Excel has a maximum of 16,384 columns

What are you going to do with this data on the local machine? Are you going to use SAS? Or Python or R or C++? It makes a difference.

Re: Is There Any Way To Export A large DataSet of more than 100MB from SAS (Remote Machine) to Local

Midi — Wed, 18 Dec 2019 15:36:59 GMT

Hello , There Are 3000 columns approximately , and i'm going to use miner on my local machine.

thx.

Re: Is There Any Way To Export A large DataSet of more than 100MB from SAS (Remote Machine) to Local

Kurt_Bremser — Wed, 18 Dec 2019 15:52:34 GMT

What kind of miner needs an Excel file as input?

Re: Is There Any Way To Export A large DataSet of more than 100MB from SAS (Remote Machine) to Local

PaigeMiller — Wed, 18 Dec 2019 15:57:48 GMT

@Midi wrote:

Hello , There Are 3000 columns approximately , and i'm going to use miner on my local machine.

thx.

I guess I would like (and I guess @Kurt_Bremser would like) you to provide details of the project, give a full explanation, rather than releasing one piece of information (that we don't understand, what is "miner"?) at a time. If we have that, we might be able to give you a reasonable recommendation on what to do.