topic sas studio PROC export in SAS Programming

sas studio PROC export

agabru0 — Sun, 18 Nov 2018 21:46:18 GMT

when execute the code below the file fails to open as an excel file.

Make,Model,Type,Origin,DriveTrain,MSRP,Invoice,EngineSize,Cylinders,Horsepower,MPG_City,MPG_Highway,Weight,Wheelbase,Length
Acura,MDX,SUV,Asia,All,"$36,945","$33,337",3.5,6,265,17,23,4451,106,189



proc export data=sashelp.cars
            outfile=_dataout
            dbms=csv replace;
run;

%let _DATAOUT_MIME_TYPE=text/csv;
%let _DATAOUT_NAME=cars.csv;

Re: sas studio PROC export

Reeza — Mon, 19 Nov 2018 03:10:25 GMT

Well, you're not generating an Excel file, you're generating a CSV, it can open in Excel or in a text editor or a browser these days as well. I'm guessing the browser is opening it directly?

PS. Please don't post your text in a code block, it sort of defeats the purpose of a code block when you put text and it makes less legible since it forces you to scroll to the side to read it all.

Re: sas studio PROC export

agabru0 — Mon, 19 Nov 2018 08:05:08 GMT

how do I overcome the problem,

Re: sas studio PROC export

agabru0 — Mon, 19 Nov 2018 08:13:08 GMT

In SAS Studio I need the output in excel, not CSV. I've tried changing CSV to XLS in the code below but it didn't work

Re: sas studio PROC export

Reeza — Mon, 19 Nov 2018 15:51:56 GMT

Change DBMS to XLSX and try making sure you have a file extension. I wasn't sure if you were using some other sort of output process giving your filename.

@agabru0 wrote:

In SAS Studio I need the output in excel, not CSV. I've tried changing CSV to XLS in the code below but it didn't work

Re: sas studio PROC export

agabru0 — Thu, 22 Nov 2018 09:09:37 GMT

I have MS office (excel 7) installed so I cant use DBMS=XLSX. Is there another workaround?

Re: sas studio PROC export

andreas_lds — Thu, 22 Nov 2018 11:37:14 GMT

@agabru0 wrote:

I have MS office (excel 7) installed so I cant use DBMS=XLSX. Is there another workaround?

Please post the log with the error message showing that dbms=xlsx is working.

Re: sas studio PROC export

agabru0 — Thu, 22 Nov 2018 13:11:11 GMT

dbms=xlsx is not working because i have excel 7 and the file extension is xls. is ther a work around

Re: sas studio PROC export

Peter_C — Thu, 22 Nov 2018 13:13:41 GMT

Upgrade your office