I need to ask one more question under this subject.
The following code that gives me exactly what I want also shown below in a picture of Excel. For transparancy reasons, I would also like to put the unit of measurement int the code. However, I cannot find the unit that gives exactly the same result. I've tried with CM, IN, MM, PCT, PX, PT.
What unit am I using when I don't specify?
libname RESULTS "C:\Temp";
goptions device=png;
ods excel
file="%sysfunc(pathname(RESULTS))\Exempel SASdata.xlsx"
;
ods excel
options(sheet_name = "Tabell 1"
sheet_interval='none'
flow='header,data'
start_at = "B2"
absolute_column_width = "6,15,6,6,10,10")
;
proc odstext;
p 'Tabell 1. Class'
/ style =[fontsize=8pt fontfamily=roboto fontweight=bold];
run;
%let dsid=%sysfunc(open(sashelp.class));
%let nobs=%sysfunc(attrn(&dsid.,nlobs));
%let dsid=%sysfunc(close(&dsid.));
proc report
data = sashelp.class
style(header)=[foreground= #1E00BE
bordertopcolor = #1E00BE
bordertopstyle = solid
bordertopwidth = 10
borderbottomcolor = #1E00BE
borderbottomstyle = solid
borderbottomwidth = 10
backgroundcolor= #ffffff
fontsize=8pt fontfamily=roboto]
style(column)=[fontsize=8pt fontfamily=roboto
vjust=c
foreground= #1E00BE]
;
columns Name Sex Age Height Weight;
define Name
/ display
style(header)={just=l
borderrightcolor = #1E00BE
borderrightstyle = solid
borderrightwidth = 5}
style(column)={just=l
borderrightcolor = #1E00BE
borderrightstyle = solid
borderrightwidth = 5};
define Sex
/ display
style(header)={just=l
borderrightcolor = #1E00BE
borderrightstyle = solid
borderrightwidth = 5}
style(column)={just=l
borderrightcolor = #1E00BE
borderrightstyle = solid
borderrightwidth = 5};
define Age
/ analysis
style(header)={just=r
borderrightcolor = #1E00BE
borderrightstyle = solid
borderrightwidth = 5}
style(column)={just=r
borderrightcolor = #1E00BE
borderrightstyle = solid
borderrightwidth = 5};
define Height
/ analysis
style(header)={just=r
borderrightcolor = #1E00BE
borderrightstyle = solid
borderrightwidth = 5}
style(column)={just=r
borderrightcolor = #1E00BE
borderrightstyle = solid
borderrightwidth = 5};
define Weight
/
analysis
style(header)={just=r}
style(column)={just=r};
compute weight;
count+ 1;
if count^= &nobs then
do;
if mod(count,2)=0 then
do;
call define(_row_, "style", "style={background=#EDEDFF}");
end;
end;
else if count= &nobs then
do;
if mod(count,2)=0 then
do;
call define(_row_, "style", "style={background=#EDEDFF borderbottomcolor= #1E00BE borderbottomwidth=10}");
end;
else if mod(count,2)^=0 then
do;
call define(_row_, "style", "style={borderbottomcolor= #1E00BE borderbottomwidth=10}");
end;
end;
endcomp;
run;
ods excel close;
... View more