PROC REPORT DATA=MASTER_DST_REMOTE_XSELL_FINAL nowd spanrows style(report)=[JUST=CENTER OUTPUTWIDTH=95% CELLSPACING=2 BORDERCOLOR=BLACK BORDERWIDTH=2] STYLE(HEADER)={BORDERCOLOR=BLACK FOREGROUND=WHITE BACKGROUND=purple FONT=("zurich BT",11pt)} STYLE(COLUMN)={TAGATTR="WRAP" JUST=CENTER FONT=("zurich BT",08pt) OUTPUTWIDTH=0.05IN FOREGROUND=BLACK BORDERCOLOR=BLACK}; TITLE FONT="Zurich BT" bold height=6 "<U>DATE-WISE NTB/ETB ONBOARDING SUMMARY </U>" JUSTIFY=CENTER; TITLE2 FONT="Zurich BT" bold height=2 "<U>Report Run Date: &sysdate. Time: &SYSTIME</U>" JUSTIFY=RIGHT; col (DATE) ('DST' DST_NTB 'DST_ETB(AC)'N 'DST_ETB(LC)'N) ('X-SELL' 'X-SELL_NTB'N 'X-SELL_ETB(AC)'N 'X-SELL_ETB(LC)'N) ('REMOTE' 'REMOTE_ETB(LC)'N) ('GRAND TOTAL' TOTAL_NTB 'TOTAL_ETB(AC)'N 'TOTAL_ETB(LC)'N); define DATE/"DATE" order order=data style(column)=[font=("zurich BT",9pt) backgroundcolor= whitesmoke]; define DST_NTB/group ANALYSIS display"NTB" style(column)=[font=("zurich BT",9pt) backgroundcolor= lightblue]; define 'DST_ETB(AC)'N/group ANALYSIS display"ETB(AC)" style(column)=[font=("zurich BT",9pt) backgroundcolor= lightblue]; define 'DST_ETB(LC)'N/group ANALYSIS display"ETB(LC)" style(column)=[font=("zurich BT",9pt) backgroundcolor= lightblue]; define 'X-SELL_NTB'N/group ANALYSIS display"NTB" style(column)=[font=("zurich BT",9pt) backgroundcolor= lightgoldenrodyellow]; define 'X-SELL_ETB(AC)'N/group ANALYSIS display "ETB(AC)" style(column)=[font=("zurich BT",9pt) backgroundcolor= lightgoldenrodyellow]; define 'X-SELL_ETB(LC)'N/group ANALYSIS display"ETB(LC)" style(column)=[font=("zurich BT",9pt) backgroundcolor= lightgoldenrodyellow]; define 'REMOTE_ETB(LC)'N/group ANALYSIS display"ETB(LC)" style(column)=[font=("zurich BT",9pt) backgroundcolor= lightcoral]; define TOTAL_NTB/group ANALYSIS "NTB" style(column)=[font=("zurich BT",9pt) backgroundcolor= lightgreen]; define 'TOTAL_ETB(AC)'N/group ANALYSIS "ETB(AC)" style(column)=[font=("zurich BT",9pt) backgroundcolor= lightgreen]; define 'TOTAL_ETB(LC)'N/group ANALYSIS"ETB(LC)" style(column)=[font=("zurich BT",9pt) backgroundcolor= lightgreen]; /* compute */ compute DST_NTB; if DST_NTB<10 then call define(_col_, "style", "style={background=red}"); endcomp; compute 'DST_ETB(AC)'N; if 'DST_ETB(AC)'N<10 then call define(_col_, "style", "style={background=red}"); endcomp; compute 'DST_ETB(LC)'N; if 'DST_ETB(AC)'N<10 then call define(_col_, "style", "style={background=red}"); endcomp; compute 'X-SELL_NTB'N; if 'X-SELL_NTB'N<10 then call define(_col_, "style", "style={background=red}"); endcomp; compute 'X-SELL_ETB(AC)'N; if 'X-SELL_ETB(AC)'N<10 then call define(_col_, "style", "style={background=red}"); endcomp; compute 'X-SELL_ETB(LC)'N; if 'X-SELL_ETB(LC)'N<10 then call define(_col_, "style", "style={background=red}"); endcomp; compute 'REMOTE_ETB(LC)'N; if 'REMOTE_ETB(LC)'N<10 then call define(_col_, "style", "style={background=red}"); endcomp; rbreak after /summarize ol skip; compute after ; if _BREAK_ eq '_RBREAK_' then do; DATE = 'Total'; CALL DEFINE(_row_ ,"style","style=[BACKGROUND=lightorange FOREGROUND=WHITE]"); end; endcomp; RUN; It's doing exactly what I want but at the end I need a grand total and its doing this. In the columns where I didnt apply compute its showing the total but In the columns where condition <10 is applied its turning that in red too. Any solutions. Please! help 😐  ... View more

Suppose I have Date 25Dec2022 and I have declared it as date. Now I want it to increment the date every time I run it. After running the code it should be 26Dec2022 and Again If we ran that code it should be 27Dec2022 and so on.. Can anyone suggest how should I proceed with it. I think INTNX function would be useful but how would I automate this process After I have declared it once. ... View more

The below code is throwing an error as below: Invalid date/time/datetime constant '01-09-2022:00:00:00am'dt. proc sql; create table dummy as Select * from MR where 'Date Of approval'n GE '01-09-2022:00:00:00am'dt. AND 'Date Of approval'n LE '30-11-2022:00:00:00am'dt.; quit;  How should I proceed? ... View more

data want; infile "&path\sample.csv" delimiter = ',' missover firstobs = 2 DSD lrecl = 32767; format IP $15.; format date yymmdd10.; format time hhmm.; format zone $5.; format cik $7.; format accession $20.; format extension $30.; format code $3.; format size 10.; input IP $ date time zone $ cik $ accession $ extension $ code $ size ; run; What will this code does? Can anyone Explain? I was trying to replace variable names in the CSV file is this correct and I don't want to use Replace. ... View more