topic Re: exporting data from to *.txt very slow in SAS Procedures

exporting data from to *.txt very slow

MirLuie — Sun, 30 Sep 2018 17:23:24 GMT

Good Evening!

I want to export a dataset to *.txt containing 6 "normal" columns and 1.700.000 rows.. It takes almost 2,5 hours.. Sometimes SAS EG even freezes and collapses. What am im doing wrong? Or is it normal?

Thanks!

Re: exporting data from to *.txt very slow

Kurt_Bremser — Sun, 30 Sep 2018 17:31:01 GMT

Please show the code, and column attribute information (eg output from proc contents).

Re: exporting data from to *.txt very slow

MirLuie — Sun, 30 Sep 2018 18:20:58 GMT

sorry for the late Reply.. my eg collapsed again 😞

i dont know the Code.. i just "click" Export as *txt.. column attribute Information is attached..

But I realized that some column lengthare too Long.. is this the Problem?

Re: exporting data from to *.txt very slow

Kurt_Bremser — Sun, 30 Sep 2018 18:31:48 GMT

That one column of maximum length (32767) is killing you. It means SAS tries to write ~55 Gigabyte of text file.

Without that column, you'd only need 356 MB.

Re: exporting data from to *.txt very slow

MirLuie — Sun, 30 Sep 2018 18:59:13 GMT

Thanks! I am wondering how can this happend? I did not set a the max length to this extent..

Re: exporting data from to *.txt very slow

Reeza — Sun, 30 Sep 2018 23:00:07 GMT

I'm guessing you never likely set it anywhere so it assumed a default somewhere.