05-14-2014 11:46 AM
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.
05-14-2014 12:03 PM
Sorry exporting as a space delimited file and the code used is
*exporting the file;
call symput('output_file', compress("'"||"&location."||"impute_18_Secondhalf2"||'.bgl'||" ' "));
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.
05-14-2014 11:56 AM
Also CONTENT sometimes causes problems such as text fields containing what ever your OS interprets as an end of line or new line character.