topic Re: Problem exporting a file of many columns in SAS Procedures

Problem exporting a file of many columns

purfield — Wed, 14 May 2014 15:46:20 GMT

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

Re: Problem exporting a file of many columns

Reeza — Wed, 14 May 2014 15:51:57 GMT

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

Re: Problem exporting a file of many columns

ballardw — Wed, 14 May 2014 15:56:42 GMT

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

Re: Problem exporting a file of many columns

purfield — Wed, 14 May 2014 16:03:02 GMT

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.

Re: Problem exporting a file of many columns

ballardw — Wed, 14 May 2014 16:13:49 GMT

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