cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
LLOUKINE
a week ago
  • 4 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: use of style to apply color to spanned columns

by Calcite | Level 5 in SAS Procedures
a week ago
a week ago
Unfortunately I cannot update to other version of SAS EG as it is what we have but I will try to look at your other suggestions.  Thank you!   ... View more

Re: use of style to apply color to spanned columns

by Calcite | Level 5 in SAS Procedures
a week ago
a week ago
here is the LOG for the programm you suggested.  The SAS System 09:27 Tuesday, October 1, 2024 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='Program'; 4 %LET _CLIENTPROCESSFLOWNAME='Process Flow'; 5 %LET _CLIENTPROJECTPATH=''; 6 %LET _CLIENTPROJECTPATHHOST=''; 7 %LET _CLIENTPROJECTNAME=''; 8 %LET _SASPROGRAMFILE=''; 9 %LET _SASPROGRAMFILEHOST=''; 10 11 ODS _ALL_ CLOSE; 12 OPTIONS DEV=PNG; 13 GOPTIONS XPIXELS=0 YPIXELS=0; 14 FILENAME EGSR TEMP; 15 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR 16 STYLE=HTMLBlue 17 STYLESHEET=(URL="file:///C:/Program%20Files/SASHome2/SASEnterpriseGuide/7.1/Styles/HTMLBlue.css") 18 NOGTITLE 19 NOGFOOTNOTE 20 GPATH=&sasworklocation 21 ENCODING=UTF8 22 options(rolap="on") 23 ; NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR 24 25 GOPTIONS ACCESSIBLE; 26 proc format library=work; 27 value $hdrcolor 28 'Student name and sex'='lightgreen' 29 'Measurements' = 'gold' 30 ; NOTE: Format $HDRCOLOR has been output. 31 run; NOTE: PROCEDURE FORMAT used (Total process time): real time 0.00 seconds cpu time 0.01 seconds 32 33 proc report data=sashelp.class 34 style(header)= [background=$hdrcolor.] 35 ; 36 columns ('Student name and sex' name sex) ('Measurements' height weight); 37 define name / style=[background=lightgreen]; 38 define sex / style=[background=lightgreen]; 39 define height/ style=[background=gold]; 40 define weight/ style=[background=gold]; 41 run; NOTE: There were 19 observations read from the data set SASHELP.CLASS. NOTE: PROCEDURE REPORT used (Total process time): real time 2.39 seconds cpu time 0.04 seconds 42 43 2 The SAS System 09:27 Tuesday, October 1, 2024 44 GOPTIONS NOACCESSIBLE; 45 %LET _CLIENTTASKLABEL=; 46 %LET _CLIENTPROCESSFLOWNAME=; 47 %LET _CLIENTPROJECTPATH=; 48 %LET _CLIENTPROJECTPATHHOST=; 49 %LET _CLIENTPROJECTNAME=; 50 %LET _SASPROGRAMFILE=; 51 %LET _SASPROGRAMFILEHOST=; 52 53 ;*';*";*/;quit;run; 54 ODS _ALL_ CLOSE; 55 56 57 QUIT; RUN; 58     and RE the picture I just did the screen shot.. ... View more

Re: use of style to apply color to spanned columns

by Calcite | Level 5 in SAS Procedures
a week ago
a week ago
Hi Ballardw, Thanks for your suggestion. However, I tried to apply the format as in your example before and it did not work for me. That is why I posted my question. When I run your code below this morning I also do not see that the spanning columns headers are colored according to the format statement.    ... View more

use of style to apply color to spanned columns

by Calcite | Level 5 in SAS Procedures
2 weeks ago
2 weeks ago
Hi, I am working on the report and I need help with applying the same colors to the headers of the spanning columns. For example I want to add “azure” color to the header cell 'PUBLISHABLE w. FLAGS'.  Also, how I can add a color to the background for the 'Cutoffs Percentages' cell?  Below is my SAS code and the output I got so far. I am looking for a suggestions how I can modify my code to color other header cells in the table below that are not colored now. Thank you!     proc report data=TestData (keep=cycle entity     case Frequency  GeoMean    Deficient_Frequency Deficient_Percent Marginal_Frequency    Marginal_Percent);  column ('PUBLISHABLE w. FLAGS' cycle entity     case) ('Geometric Results'     Frequency  GeoMean    ) ('Cutoffs Percentages' ( 'Deficient (<148 pmol per L)' Deficient_Frequency     Deficient_Percent) ('Marginal (148-220 pmol per L)' Marginal_Frequency    Marginal_Percent )) ;  define cycle/display style(header)={background=azure};  define entity/display style(header)={background=azure};  define case/display style(header)={background=azure};  COMPUTE cycle;  CALL DEFINE(_COL_, "style", "STYLE=[BACKGROUND=azure]");  ENDCOMP;  COMPUTE entity;  CALL DEFINE(_COL_, "style", "STYLE=[BACKGROUND=azure]");  ENDCOMP;  COMPUTE case;  CALL DEFINE(_COL_, "style", "STYLE=[BACKGROUND=azure]");  ENDCOMP; *geomeans;  define Frequency/display 'N' style(header)={background=PAY};  define GeoMean/display style(header)={background=PAY};  define LowerCLGM/display style(header)={background=PAY};  COMPUTE Frequency;  CALL DEFINE(_COL_, "style", "STYLE=[BACKGROUND=PAY]");  ENDCOMP;  COMPUTE GeoMean;  CALL DEFINE(_COL_, "style", "STYLE=[BACKGROUND=PAY]");  ENDCOMP; *Deficient Percent;  define Deficient_Frequency/display style(header)={background=GWH};  define Deficient_Percent/display style(header)={background=GWH};  COMPUTE Deficient_Frequency;  CALL DEFINE(_COL_, "style", "STYLE=[BACKGROUND=GWH]");  ENDCOMP;  COMPUTE Deficient_Percent;  CALL DEFINE(_COL_, "style", "STYLE=[BACKGROUND=GWH]");  ENDCOMP; *marginal Percent;  define Marginal_Frequency/display style(header)={background=PWH};  define Marginal_Percent/display style(header)={background=PWH};  COMPUTE Marginal_Frequency;  CALL DEFINE(_COL_, "style", "STYLE=[BACKGROUND=PWH]");  ENDCOMP;  COMPUTE Marginal_Percent;  CALL DEFINE(_COL_, "style", "STYLE=[BACKGROUND=PWH]");  ENDCOMP;  run;       ... View more
Contact Me
Online Status
Offline
Date Last Visited
a week ago
Quick links