SAS Community,   I am trying to distribute records from a statewide dataset into smaller datasets that represent regions in the state. The variable I am looking at is pfi and using the IN operator, I am seeking to match values to output observations into the regialonal datasets.   I am gtting a SAS error about a dataset already being open for output. I don't see the coding error or know of a limitiation that would trigger the error.   Here is the log:   99 option mrecall mautosource noimplmac; 100 /* Change libname path to local work folder */ 101 102 LIBNAME obs 'D:\Data\SPARCS\DiagProc\Work'; NOTE: Libref OBS was successfully assigned as follows: Engine: V9 Physical Name: D:\Data\SPARCS\DiagProc\Work 103 %global sqlyr1; 104 %global longdate; 105 %LET sqlyr1=2014; *4 digit year being EVALUATED (no quotes); 106 %LET longdate=April 1, 2016; 107 108 %macro year2; 109 %global sqlyr2; 110 %let sqlyr2=%eval(&sqlyr1+1); 111 %mend year2; 112 113 %year2; 114 DATA obs.wny_ip_dx_pr_w_avg 115 obs.fl_ip_dx_pr_w_avg 116 obs.cny_ip_dx_pr_w_avg 117 obs.ne_ip_dx_pr_w_avg 118 obs.hv_ip_dx_pr_w_avg 119 obs.ne_ip_dx_pr_w_avg 120 obs.nyc_ip_dx_pr_w_avg 121 obs.li_ip_dx_pr_w_avg 122 obs.unknown; 123 124 SET obs.final_ip_dx_pr_w_avg; 125 126 IF pfi IN ('000037','000039','000066','000098','000102','000103','000111','000114','000207','000213', 127 '000216','000218','000267','000280','000292','000339','000340','000565','000574','000581', 128 '000583','000718','001153','003067') 129 THEN OUTPUT obs.wny_ip_dx_pr_w_avg; 130 ELSE IF pfi IN ('000116','000118','000393','000409','000411','000412','000413','000414','000471','000671', 131 '000676','000678','000858','000866','000870','000873','001028','001158','005785') 132 THEN OUTPUT obs.fl_ip_dx_pr_w_avg; 133 ELSE IF pfi IN ('000012','000085','000158','000362','000367','000377','000379','000383','000397','000401', 134 '000589','000598','000599','000628','000630','000635','000636','000727','000798','000804', 135 '000812','000815','000817','000977','009059','000042','000043','000058','000128') 136 THEN OUTPUT obs.cny_ip_dx_pr_w_avg; 137 ELSE IF pfi IN ('000001','000002','000004','000005','000135','000146','000165','000170','000174','000303', 138 '000309','000324','000325','000330','000482','000484','000739','000746','000755','000756', 139 '000818','000829','000831','000848','000851','001005','008554','009250','009431') 140 THEN OUTPUT obs.ne_ip_dx_pr_w_avg; 141 ELSE IF pfi IN ('000180','000181','000192','000694','000699','000704','000708','000752','000775','000776', 142 '000779','000968','000971','000989','000990','001002','001039','001045','001046','001047', 143 '001061','001072','001097','001098','001099','001117','001122','001124','001129','001133', 144 '001138','001139') 145 THEN OUTPUT obs.hv_ip_dx_pr_w_avg; 146 ELSE IF pfi IN ('001164','001165','001168','001169','001172','001175','001176','001178','001186','001286', 147 '001288','001293','001294','001301','001304','001305','001306','001309','001315','001318', 148 '001320','001324','001437','001438','001439','001445','001446','001447','001450','001453', 149 '001454','001456','001458','001460','001463','001464','001465','001466','001469','001473', 150 '001486','001487','001626','001628','001629','001630','001633','001635','001637','001638', 151 '001639','001692','001737','001738','001740','003058','003376','003975','009700') 152 THEN OUTPUT obs.nyc_ip_dx_pr_w_avg; 153 ELSE IF pfi IN ('000245','000490','000511','000513','000518','000527','000528','000541','000550','000551', 154 '000552','000563','000885','000889','000891','000895','000896','000913','000924','000925', 155 '000938','000943') THEN OUTPUT obs.li_ip_dx_pr_w_avg; 156 ELSE OUTPUT obs.unknown; 157 RUN; ERROR: Data set OBS.NE_IP_DX_PR_W_AVG is already open for output. NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set OBS.WNY_IP_DX_PR_W_AVG may be incomplete. When this step was stopped there were 0 observations and 23 variables. WARNING: The data set OBS.FL_IP_DX_PR_W_AVG may be incomplete. When this step was stopped there were 0 observations and 23 variables. WARNING: The data set OBS.CNY_IP_DX_PR_W_AVG may be incomplete. When this step was stopped there were 0 observations and 23 variables. WARNING: The data set OBS.NE_IP_DX_PR_W_AVG may be incomplete. When this step was stopped there were 0 observations and 23 variables. WARNING: The data set OBS.HV_IP_DX_PR_W_AVG may be incomplete. When this step was stopped there were 0 observations and 23 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.03 seconds   ... View more

Hello SAS Community: I am trying to highlight (traffic light) a row in ODS PDF output using PROC REPORT if the value of one variable is less than the value of another variable. I want to display the value of the variable of interest and surpress the display of the comparision variable within the same row. All the variables are available in the input dataset but SAS is reporting the following   NOTE: Variable NYPT_cor_p is uninitialized. NOTE: The above message was for the following BY group: Claim Type=I NOTE: Variable NYPT_cor_p is uninitialized. NOTE: The above message was for the following BY group: Claim Type=E NOTE: Variable NYPT_cor_p is uninitialized. NOTE: The above message was for the following BY group: Claim Type=A   I can assure that NYPT_cor_p is populated with valid data similar to what is contained pn PT_cor_p. If anyone can reply with examples I can use I would appreciate it. Thanks.   ODS listing close; options orientation=landscape; ods pdf file="D:\Data\indicator.pdf" style=SASdocprinter notoc; proc report data=paysrc.summary_pct nowindows headline headskip split='*' style(header)=[fontsize=1] style(report)=[bordercolor = black] style(report)=[fontsize=-1] ; options number nonumber nodate center; LABEL claim_type='Claim Type'; BY DESCENDING claim_type ; columns facility _FREQ_ PT_cor PT_cor_p PT_nc PT_nc_p NYPT_cor NYPT_cor_p NYPT_nc NYPT_nc_p; define facility / display 'Facility' style(column)=[fontsize=1]; define _FREQ_ / display 'Discharges' format=comma8. style(column)=[fontsize=1]; define PT_cor / display 'Payment Topology*Correctly*Mapped' format=comma8. style(column)=[fontsize=1]; define PT_cor_p / display '% Payment Topology*Correctly*Mapped' format=5.2 style(column)=[fontsize=1]; define PT_nc / display 'Payment Topology*Incorrectly*Mapped' format=comma8. style(column)=[fontsize=1]; define PT_nc_p / display '% Payment Topology*Incorrectly*Mapped' format=5.2 style(column)=[fontsize=1]; define NYPT_cor / noprint; define NYPT_cor_p / noprint; define NYPT_nc / noprint; define NYPT_nc_p / noprint;   compute PT_cor_p; if (PT_cor_p < NYPT_cor_p) then do; call define (_row_,'style','style={background=LIGR}'); end; endcomp;   run; ods pdf close; ODS listing;   ... View more

SAS Community,   I have seen several good examples of PROC REPORT row highlighting when two colums have certain values but I can't seem to get it to work with my simple dataset.   PT1 SOP1 Count 11 16 1,090 11 BL 160 11 CI 68 11 MA 1,282 12 BL 295 12 CI 348 12 MA 6,821 12 MB 76 21 BL 32 21 CI 54 21 HM 5,208   Columns Properties Column Name  Type  Length  Format  Informat PT1                  Text   5            $5.        $5. SOP1               Text   2            $2.   I want to highlight the last row, PT1 = '21' and SOP='HM'.   Here is excerpt from my PROC REPORT code; ODS listing close; options orientation=landscape; ods html file='d:\temp\demo_3_1.html' style=sasweb; proc report data=paysrc.SW_freq_FACbyPTbyCFI_&clm._&yr. nowindows headline headskip split='*' style(header)=[fontsize=1] style(report)=[bordercolor = black] style(report)=[fontsize=-1] ; options number nonumber nodate center; BY facility; columns PT1 SOP1 COUNT; define PT1 / display 'Payment*Topology 1' style(column)=[fontsize=1]; define SOP1 / display 'Claim Filing*Indicator 1' style(column)=[fontsize=1]; define COUNT / display 'Frequency*Count' format=comma10. style(column)=[fontsize=1]; compute PT1; if PT1 = '21' AND SOP1 = 'HM' then do; call define (_row_,'style','style={background=cx9999cc}'); end; endcomp;   TITLES; FOOTNOTES; RUN;   ods html close; ODS listing;   If anyone has any ideas on what I can try next, I would appreciate hearing from you. Stephen ... View more