Hello, I'm trying to assign values to a column based on logic that uses the values in another column. I'm using Proc Report, and the logic I'd like to create is something like this: if (Status eq 'WORKED' and PCT_Worked eq 0) then 'N/A' else if Status eq 'AUTOCLSD' then ''. I've added an extra column to my report to show what the final result should look like (green header). The code is below. Thank you. ODS LISTING CLOSE;
ods excel file= "/sas/sasperm18_prod/Fraud/DDA/temp/&FileName" options(sheet_name="SevData") ;;
options missing= 0;
PROC REPORT DATA=Reports.temp_Mon_Final2 NOWD HEADLINE HEADSKIP
contents = "Mon-Alerts by Severity"
style(header) =
[just = c
font_face = arial
font_size = 4
foreground = white
background = gray
protectspecialchars=off] ;
title "Mon Alerts by Severity";
column Severity WORKED_SORT WORKED_STATUS Status (CREATE_YM,(Worked)) PCT_WORKED PCT_WORKED=PCT_WKD;
define Severity / group style(column)= header 'Severity' style={just=l vjust =b } order=internal descending ;
define WORKED_SORT / group style(column)= header 'Sorting' style={just=l vjust =b } NOPRINT;
define WORKED_STATUS / group style(column)= header 'WStatus' style={just=l vjust =b } noprint ;
define Status / group style(column)= header 'Status' style={just=l vjust =b } ;
define CREATE_YM/ across order=internal '' style={just=l vjust =b };
define Worked/ analysis sum '' format=15. style={just=c vjust =b } ;
define PCT_WORKED/ style(column)= header '% Worked' format=5.2 style={just=l vjust =b } missing;
rbreak after /summarize;
compute after ;
Severity="Total" ;
PCT_WORKED.SUM = .;
endcomp;
run;
%runquit;
ods excel close;
%runquit;
... View more