exporting data from to *.txt very slow

[MirLuie]

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!

[Kurt_Bremser]

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

[MirLuie]

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?

[Kurt_Bremser · Accepted solution]

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.

[MirLuie]

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

[Reeza]

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