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 .
100MB is most probably more rows than Excel can even work with.
well , in reality they are only 8000 rows.
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.
Hello , There Are 3000 columns approximately , and i'm going to use miner on my local machine.
thx.
What kind of miner needs an Excel file as input?
@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.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.