Hello everyone   I'm trying to colour code some values on Proc Report using compute, but I can't get it right and cannot understand why it's not working.   Based on the example below, I'd need RCVD to change colour based on the value of NEWC   data TEST; input WD EXPD RCVD RCVD_ALL NEWC $; datalines; -1 49 49 56 Y 01 26 26 77 Y 02 77 45 0 N 03 71 0 0 N 04 44 0 0 N ; RUN; proc report data=TEST missing nowd; column (WD, ( EXPD RCVD RCVD_ALL)); define WD / 'Working Day' across NOZERO ORDER=DATA; define EXPD / analysis 'Expd' missing; define RCVD / analysis 'Rcvd' missing; define RCVD_ALL / analysis 'Rcvd all' missing; compute RCVD; if NEWC = "Y" then do; call define (_col_,"style", "style={background=green}"); end; else if NEWC = "N" then do; call define (_col_,"style", "style={background=red}"); end; endcomp; run; quit; ps: I cannot indicate specific columns (i.e. _c1_ etc as the table can expand or contract based on the values received)   Many thanks ... View more

Hello everyone   I'm trying to display two rows in Proc Report (across) as headers; however, if the cell for one row does not contain any data, the value from the other row won't be displayed either.   Hopefully the below example will explain it better:   data TEST; input ENTRY $ WD DAY VALUE; datalines; E1 -1 NULL 12 E1 01 20200803 51 E1 02 20200804 45 E1 03 20200805 15 E1 04 20200806 1 E1 09 2020081 32 E1 10 20200814 11 E1 11 20200817 65 ; run; proc report data=TEST nowd; column ENTRY WD, DAY, VALUE; define WD / 'Working Day' across NOZERO ORDER=DATA; define DAY /'' across; define ENTRY / group 'ENTRY'; define VALUE / '' group; quit;   The report won't show WD= -1 because the correspondent DAY is null.   How can I force it to show it anyway?   Many thanks ... View more

Hello all   I'm trying to create a calendar showing the working days, but I'm having an issue with one condition.   I create a "count" column that increases the value only if the day is a working day (and if it's a non working day, it gets the same value of the latest working day.)   That works well, but I then would like to assign -1 if the first day of the month is a non working day (and it should then move to 1 once it gets to the first working day).   Below is  as extract of the data and the code I'm using: for 201903 this works fine, but for example for 201906 I'd like to see -1 for the first tow days, then  1,2,3 etc for the working days.   Basically, I don't want to see the 00; instead it should move from -1 to 1   data WORK.DATE; input DAY MONTH WORKING_DAY $; datalines; 20190101 201901 NO 20190102 201901 YES 20190103 201901 YES 20190104 201901 YES 20190105 201901 NO 20190106 201901 NO 20190107 201901 YES 20190108 201901 YES 20190109 201901 YES 20190202 201902 NO 20190203 201902 NO 20190204 201902 YES 20190205 201902 YES 20190206 201902 YES 20190207 201902 YES 20190301 201903 YES 20190302 201903 NO 20190303 201903 NO 20190304 201903 YES 20190305 201903 YES 20190306 201903 YES 20190307 201903 YES 20190601 201906 NO 20190602 201906 NO 20190603 201906 YES 20190604 201906 YES 20190605 201906 YES 20190606 201906 YES 20190607 201906 YES 20190608 201906 NO 20190609 201906 NO 20190610 201906 YES ; run; data BDU_TRGR.DATE2; set WORK.DATE; by MONTH DAY; if first.MONTH and WORKING_DAY = "NO" then count=-1; if first.MONTH and WORKING_DAY = "YES" then count=1; else if WORKING_DAY = "YES" then count+1; WD=count; drop count; format WD z2.; run;   any help would e greatly appreciated!   thanks   ... View more

Hello   I'm creating a chart with proc sgplot; the x axis is quite "busy" and I'd like to display only , say, every other value. Below is an example of my chart.   data Test; input Year Vol1 Vol2; datalines; 1960 685.47 568.05 1961 734.91 610.25 1962 726.01 535.76 1963 767.21 646.79 1964 891.71 768.08 1965 969.26 840.59 1966 995.15 744.32 1967 943.08 786.41 1968 985.21 825.13 1969 968.85 769.93 1970 842.00 631.16 1971 950.82 797.97 1972 1036.27 889.15 1973 1051.70 788.31 1974 891.66 577.60 1975 881.81 632.04 1976 1014.79 858.71 1977 999.75 800.85 1978 907.74 742.12 1979 897.61 796.67 1980 1000.17 759.13 1981 1024.05 824.01 1982 1070.55 776.92 1983 1287.20 1027.04 1984 1286.64 1086.57 1985 1553.10 1184.96 1986 1955.57 1502.29 1987 2722.42 1738.74 1988 2183.50 1879.14 1989 2791.41 2144.64 1990 2999.75 2365.10 1991 3168.83 2470.30 1992 3413.21 3136.58 1993 3794.33 3241.95 1994 3978.36 3593.35 1995 5216.47 3832.08 1996 6560.91 5032.94 1997 8259.31 6391.69 1998 9374.27 7539.07 1999 11497.12 9120.67 2000 11722.98 9796.03 2001 11337.92 8235.81 2002 10635.25 7286.27 2003 10453.92 7524.06 2004 10854.54 9749.99 2005 10940.55 10012.36 2006 12510.57 10667.35 2007 14164.53 12050.41 2008 13058.20 6547.05 2009 10605.70 6440.08 2010 11655.0 9596.04 2011 12928.5 10362.3 2012 13588.7 12221.2 ; run; proc sgplot data=TEST; vbar Year / response=Vol1 nostatlabel fillattrs=(color=lightblue) transparency=0.1; /* vline actg_dt / response=expected nostatlabel /*y2axis*/*/ lineattrs=(thickness=3 color=deeppink pattern=dash) /*transparency=0.1*/; xaxis display=(nolabel) type=discrete; keylegend; run; I've tried all the options (at least I think!) in xaxis, but can't find the right one.   many thanks in advance   ... View more

Hello   I'm trying to return the Date field in lower case, but only the day and month - so in the below example I'd like to see 01 Jan, 02 Jan etc..   data Test; input Day Vol; datalines; 20200101 685.47 20200102 734.91 20200103 726.01 20200104 767.21 20200104 891.71 ; run; PROC SQL; CREATE TABLE TEST1 AS SELECT Input( Put( Day, 8.), yymmdd8.) FORMAT=DATE5. AS Day, Vol FROM TEST; QUIT; I've tried all the options with WORDDATX, WORDDATE but I can't find the way to only show day and month.   (of course LOWCASE is not an option as it's not a Char)   thanks in advance ... View more