p********a
发帖数: 5352 | 1 OPEN的时候每次都要提示 it is in a different format than specified by the
file extension. Verify that file is not corrupted ...
这很ANNOYing，有没有办法不让EXCEL出这个提示呢？我知道它其实是XML。 |
g*****d
发帖数: 526 | 2 呃，用dde。。。
【在 p********a 的大作中提到】
: OPEN的时候每次都要提示 it is in a different format than specified by the
: file extension. Verify that file is not corrupted ...
: 这很ANNOYing，有没有办法不让EXCEL出这个提示呢？我知道它其实是XML。
|
s*******e
发帖数: 1385 | 3 为什么我没有过这种问题，你specify的file name那么是XXXXXX.xls吗？
【在 p********a 的大作中提到】
: OPEN的时候每次都要提示 it is in a different format than specified by the
: file extension. Verify that file is not corrupted ...
: 这很ANNOYing，有没有办法不让EXCEL出这个提示呢？我知道它其实是XML。
|
p********a
发帖数: 5352 | 4 Yes, Excel extensions.
My file was created under unix SAS. Maybe it is because of Unix?
My other files created under Windows don't have such issues.
【在 s*******e 的大作中提到】
: 为什么我没有过这种问题，你specify的file name那么是XXXXXX.xls吗？
|
s*******e
发帖数: 1385 | 5 I don't have this problem with unix SAS either.
【在 p********a 的大作中提到】
: Yes, Excel extensions.
: My file was created under unix SAS. Maybe it is because of Unix?
: My other files created under Windows don't have such issues.
|
p********a
发帖数: 5352 | 6 I used the following codes. Could you help me to take a look and see what is
wrong? Thanks
%let datestamp=%sysfunc(today(),yymmddn8.);
%let datestamp1=%sysfunc(datetime(),datetime20.);
%let datestamp2=%substr(%sysfunc(tranwrd(&datestamp1,:,_)),1,15);
%put &datestamp1 &datestamp2;
ODS listing close;
ODS tagsets.ExcelXP path = "/sassvr1/test_report" file="sassrv1_at_%bquote(
&work1pct.)._&datestamp2._CST.xls"
style=EGDefault options( autofilter='all' embedded_titles='yes' autofit
_height= 'yes'
embedded_footnotes='yes' default_column_width="35, 35" width_fudge='0.75'
TITLE_FOOTNOTE_WIDTH="50" sheet_name= "xxxx Summary");
proc report data=dir_file nowd split="|" missing headline headskip;
title1 "xxxxxx Report";
title2 "Updated on: &datestamp1";
column owner size fdate directory dsn ;
define owner / display "Owner" flow width=10 ;
define size / format=comma10.2 "Size in GB" width=10;
define fdate / format=mmddyy10. "Last Modified Date" width
=10;
define directory / "Directory" width=150;
define dsn / "Dataset Name" width=100;
run;
Quit;
ODS tagsets.excelxp close; |
s*******e
发帖数: 1385 | 7 ODS listing close;
ODS tagsets.ExcelXP path=
Should it be "ODS tagsets.ExcelXP file="
is
bquote(
autofit
【在 p********a 的大作中提到】
: I used the following codes. Could you help me to take a look and see what is
: wrong? Thanks
: %let datestamp=%sysfunc(today(),yymmddn8.);
: %let datestamp1=%sysfunc(datetime(),datetime20.);
: %let datestamp2=%substr(%sysfunc(tranwrd(&datestamp1,:,_)),1,15);
: %put &datestamp1 &datestamp2;
: ODS listing close;
: ODS tagsets.ExcelXP path = "/sassvr1/test_report" file="sassrv1_at_%bquote(
: &work1pct.)._&datestamp2._CST.xls"
: style=EGDefault options( autofilter='all' embedded_titles='yes' autofit
|
p********a
发帖数: 5352 | |
