ods graphics on/reset;
ods excel file="graficoshistogramas.xlsx" path="F:\REMOVED TO DEIDENTIFICATION\"
style=sty_custom;
proc sql noprint;
select name into :hist_state1-
from dictionary.columns
where upper(libname)='WORK'
and upper(memname)='MERGE0'
and type='num';
quit;
%let nobs=&sqlobs;
%macro generate_histogram;
%do i=1 %to &nobs;
proc sgplot data=WORK.MERGE0;
title "Histograma de &&&hist_state&i";
histogram &&&hist_state&i;
run;quit;
%end;
%mend;
%generate_histogram; 120
121 ods graphics on/reset;
122 ods excel file="graficoshistogramas.xlsx"
122! path="F:\REMOVED TO DEIDENTIFICATION\"
----
22
76
ERROR 22-322: Syntax error, expecting one of the following: ;,
ANCHOR, AUTHOR, BOX_SIZING, CATEGORY, CLOSE,
COMMENTS, CSSSTYLE, DOM, DPI, FILE, GFOOTNOTE,
GTITLE, IMAGE_DPI, KEYWORDS, NOGFOOTNOTE,
NOGTITLE, OPTIONS, SASDATE, STATUS, STYLE,
SUBJECT, TEXT, TITLE, WORK.
ERROR 76-322: Syntax error, statement will be ignored.
123 style=sty_custom;
124
125 proc sql noprint;
126 select name into :hist_state1-
127 from dictionary.columns
128 where upper(libname)='WORK'
129 and upper(memname)='MERGE0'
130 and type='num';
131 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
132
133 %let nobs=&sqlobs;
134
135
136 %macro generate_histogram;
137
138 %do i=1 %to &nobs;
139
140 proc sgplot data=WORK.MERGE0;
141 title "Histograma de &&&hist_state&i";
142 histogram &&&hist_state&i;
143 run;quit;
144
145
146 %end;
147
148 %mend;
149
150 %generate_histogram;
NOTE: PROCEDURE SGPLOT used (Total process time):
real time 0.18 seconds
cpu time 0.01 seconds
NOTE: There were 29 observations read from the data set
WORK.MERGE0.
NOTE: PROCEDURE SGPLOT used (Total process time):
real time 0.18 seconds
cpu time 0.01 seconds
NOTE: There were 29 observations read from the data set
WORK.MERGE0.
NOTE: PROCEDURE SGPLOT used (Total process time):
real time 0.17 seconds
cpu time 0.06 seconds
NOTE: There were 29 observations read from the data set
WORK.MERGE0.
NOTE: PROCEDURE SGPLOT used (Total process time):
real time 0.17 seconds
cpu time 0.00 seconds
NOTE: There were 29 observations read from the data set
WORK.MERGE0.
NOTE: PROCEDURE SGPLOT used (Total process time):
real time 0.17 seconds
cpu time 0.00 seconds
NOTE: There were 29 observations read from the data set
WORK.MERGE0.
NOTE: PROCEDURE SGPLOT used (Total process time):
real time 0.17 seconds
cpu time 0.00 seconds
NOTE: There were 29 observations read from the data set
WORK.MERGE0.
NOTE: PROCEDURE SGPLOT used (Total process time):
real time 0.17 seconds
cpu time 0.00 seconds
NOTE: There were 29 observations read from the data set
WORK.MERGE0.
NOTE: PROCEDURE SGPLOT used (Total process time):
real time 0.17 seconds
cpu time 0.03 seconds
NOTE: There were 29 observations read from the data set
WORK.MERGE0.
NOTE: PROCEDURE SGPLOT used (Total process time):
real time 0.17 seconds
cpu time 0.00 seconds
NOTE: There were 29 observations read from the data set
WORK.MERGE0.
NOTE: PROCEDURE SGPLOT used (Total process time):
real time 0.17 seconds
cpu time 0.04 seconds
NOTE: There were 29 observations read from the data set
WORK.MERGE0.
Hi everyone, Hope you are doing well, I'm not being able to use ODS Excel on my SAS. When I try, the graphs are correctly generated, but no excel file is generated, with no error messages displayed. I can use other ODS like rtf and pdf with no issue. One thing that I believe may be my problem is that the "excel" word entered after ODS does not get blue, while rtf and pdf after ODS become blue. I can even generate an excel file (with .xlsx) using ODS RTF, but it will not open. I appreciate any suggestions, Many thanks for considering my request. Best wishes
... View more
