Help using Base SAS procedures

Problem exporting a file of many columns

Reply
Occasional Contributor
Posts: 6

Problem exporting a file of many columns

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

Super User
Posts: 18,569

Re: Problem exporting a file of many columns

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

Occasional Contributor
Posts: 6

Re: Problem exporting a file of many columns

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.

Super User
Posts: 10,871

Re: Problem exporting a file of many columns

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

Super User
Posts: 10,871

Re: Problem exporting a file of many columns

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

Ask a Question
Discussion stats
  • 4 replies
  • 190 views
  • 0 likes
  • 3 in conversation