结果:找到“export excel”相关内容19个,排序为按回复时间降序,搜索更多相关帖子请点击“高级”
Excel Importing & Exporting Text Data
3 个回复 - 1273 次查看
By Scott Hartshorn
This book shows how to import and
export different types of data from Excel. The focus is on working with common data types that you are most likely to see, including CSV fo ...
2018-10-4 09:29 - ekscheng - Excel
Excel Importing & Exporting Text Data
23 个回复 - 2703 次查看
Excel Importing & Exporting Text Data: Quickly Turn Raw Data Into Excel Tables (Data Analysis With Excel) by Scott Hartshorn
English | March 10, 2016 | ASIN: B01CUSXRL8 | 45 Pages | AZW3/MOBI/EPUB/ ...
2016-3-16 23:21 - igs816 - 量化投资
SAS多个数据集导出到同一个Excel中是用proc export出错
4 个回复 - 2599 次查看
%macro
export(db=, sheet=);
proc
export data=&db. outfile="E:\\x.xlsx"
dbms=xlsx replace label;
sheet="&sheet.";
quit;
%mend
export;
export一百多个数据集,会出现文件已损坏的报 ...
2021-12-24 15:21 - 橘子汽水好好喝 - SAS专版
export导出excel无法覆盖
3 个回复 - 2839 次查看
用
export语句导出的
excel,用一样的语句和路径,但无法覆盖之前导出的那一份,有解决方法吗,代码如下:
PROC EXPORT DATA=temp
OUTFILE= "C:\Users\Administrator\Desktop\temp.xlsx"
...
2016-5-26 12:15 - zorro2004 - SAS专版
SAS9.3(64位)用Proc Export导出Excel遇到的问题
9 个回复 - 12987 次查看
SAS9.3 用Proc Export导出Excel遇到问题,代码如下:
PROC EXPORT DATA =test
OUTFILE= "C:\SAS Data&Programe\Data\Finical\test.xlsx"
DBMS=EXCEL2010 LABEL REPLACE ;
SHEET="t ...
2012-5-2 22:21 - nll_011 - SAS专版
export 导出的excel sheet名字包含特殊字符
15 个回复 - 9682 次查看
各位高手
proc
export data=sashelp.class outfile="D:\class.xls";
sheet="班级-成绩@";
run;
导出的
excel sheet名字中,短杆和@都被转换成了下划线,怎么保证特殊字符不被转换成下划线
比如我这里的-和 ...
2013-12-6 14:11 - Imasasor - SAS专版
求助,export 产生excel问题,今天内选出最佳答案
1 个回复 - 1379 次查看
大家好,我想使用proc
export生成Excel 文件,但是如何能控制Excel 中每个列的宽度?有什么选项可以解决?
我的代码如下:
proc
export data=one outfile="c:\myfolder\data1.xls" dbms = xls replace;
run ...
2011-12-2 09:54 - pinggu2688 - SAS专版
question about export sas figure into excel
2 个回复 - 1470 次查看
i used ods to generate
excel files from SAS (ods html file="tem.xls"). it
worked well with the proc means procedure but for proc freq procedure, the
figure saved in
excel is not well organized ...
2010-3-22 23:10 - rockfido - 商业数据分析