topic Re: Facility to download output in text delimited format using STP in SAS Enterprise Guide

Facility to download output in text delimited format using STP

Akash93 — Wed, 02 Feb 2022 17:54:00 GMT

Hi Team,
I want to download output in text delimited format using Sas Stp. I have cracked downloading in CSV,Excel and RTF with below code.

data _null_;

rc =stpsrv_header('Content-type','application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
rc = stpsrv_header('Content-disposition','attachment;filename=Test.csv');
run;

ods listing close;

ods tagsets.csv body=_webout style=sasweb;

proc print data=Transaction_Detail_dt_acct noobs;
title 'test1 excelxp mimetype=application/vnd.ms-excel';
run;

ods tagsets.csv close;

Please suggest.

Regards,
Akash

Re: Facility to download output in text delimited format using STP

Kurt_Bremser — Thu, 03 Feb 2022 08:51:01 GMT

Try using a data step with _webout in the FILE statement.

Re: Facility to download output in text delimited format using STP

Akash93 — Sat, 12 Feb 2022 16:04:44 GMT

Thanks Kurt_Bremser..It helped me to achieve required output.