Problem exporting a file of many columns

[purfield]

Hi all,

I was just wondering has anyone come across this problem and how did they resolve it.

I currently have a file of 1910 columns and when I export this using SAS 9.3 not all of the columns are exported, however if I was to do this in SAS 9.1 it is exported fine. As all computers have now been upgraded to SAS 9.3 I was just wondering has anyone over come this problem?

It really isnt ideal to split in two if it can be avoided.

Many thanksx

[Reeza]

What are you exporting to, Excel, CSV? And how are you exporting?

[purfield]

Sorry exporting as a space delimited file and the code used is

*exporting the file;

%let location=Y:\6047\Deidre\GWAS\sequence\chr18_seq\imputation\;

data _NULL_;

   call symput('output_file', compress("'"||"&location."||"impute_18_Secondhalf2"||'.bgl'||" ' "));

run;

quit;

filename file1 &output_file. lrecl=1048576;

proc export outfile=file1 dbms=dlm data=unrelated replace; run;

So SAS will perfectly export the first 900 columns or so but is missing the remainder.

[ballardw]

Have the lengths of your variables changed? If so LRECL may need an increase.

[ballardw]

Also CONTENT sometimes causes problems such as text fields containing what ever your OS interprets as an end of line or new line character.