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;
dbms=xlsx is not working because i have excel 7 and the file extension is xls. is ther a work around
how do I overcome the problem,
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
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
I have MS office (excel 7) installed so I cant use DBMS=XLSX. Is there another workaround?
@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.
dbms=xlsx is not working because i have excel 7 and the file extension is xls. is ther a work around
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.