SAS stored process data dump download issue

Akash93 — Tue, 31 May 2022 10:09:16 GMT

Hi Team,

We have developed stored procedure to download data dump in text file with below code.

proc export data=data_download outfile="path" file =_webout

dbms=tab replace;

run;

In output last 11 column names are getting excluded. Means row 1st is blank for these 11 columns and data is flowing for these columns.

I am attaching sample for reference. Please help if there is any solution.

Regards,
Akash

Re: SAS stored process data dump download issue

Tom — Tue, 31 May 2022 10:30:36 GMT

Why did you attach an XLSX file to your question when the SAS code in the question was generating a TEXT file?

PROC EXPORT might have trouble with header lines that are too long. I know PROC IMPORT does.

Fortunately writing a simple text file does not need a PROC. The DATA step can do it by itself. But adding the header line is adds a little complication.

* Write header row ;
proc transpose data=data_download(obs=0) out=names;
  var _all_;
run;
data _null_;
  file _webout dsd dlm='09'x lrecl=1000000;
  set names;
  put _name_ @;
run;

* Append data rows;
data _null_;
  file _webout dsd dlm='09'x lrecl=1000000 mod;
  set data_download;
  put (_all_) (+0);
run;

If you have trouble writing it directly to the _WEBOUT fileref then create a physical file first and copy it.

topic SAS stored process data dump download issue in ODS and Base Reporting

SAS stored process data dump download issue

Re: SAS stored process data dump download issue