hello - can anyone advise as to why I am getting null values from my case statement? My final output should contain a column that I have added titled "Product _Categories" and every obs should have "MA; MAPD; DSNP" as the Product_Categories. When I run the table with the case statement I get Null's. Thanks for taking a look and offering a suggestion     proc sql; create table RTS2023 as select distinct * from medicaresalesagencies3 where Certification_Status in ('Ready To Sell 2023') ;quit; proc sql; alter table work.RTS2023 add Product_Categories1 char 14; quit; proc sql; create table RTS_Sunfire as select distinct *, case when Product_Categories1 is null then "MA; MAPD; DSNP" end as Product_Categories from RTS2023 ;quit; ... View more

hello, i use the below code (proc sql and proc report) to create the calcs in my table. I am trying to solve for having the total % Change not be a sum of the % Change column but be a percentage of the total in the 2 columns. it should be 628/1391=45.14% rather than a total of that column. Can someone advise on how to solve for this? proc sql; create table FBMI_APPTS5_Output2 as select distinct Agency_Type, Newly_Appointed as New_Appoint, RTS_2023 as RTS2023, RTS2023/New_Appoint as '% Change'n format=percent10.2 from FBMI_APPTS5_Output; quit; proc report data=FBMI_APPTS5_Output2 nowd split='|' /* spanrows */ style(header) = [font=("Arial",10.0pt) vjust=middle just=center background=%RGB(0,145,204) foreground=whitesmoke font_weight=bold] style(column) = [font=("Arial",8.58pt) bordercolor=%RGB(242,242,242) ]; cols Agency_Type New_Appoint RTS2023 '% Change'n; define Agency_Type / "Agency | Type" order=data ; define New_Appoint / "Newly Appointed | for PY 2023" style(column)={vjust=c just=c cellwidth = 1in} order=data; define RTS2023 / "New RTS 2023" order=data ; define '% Change'n / "% Change" style(column)={vjust=c just=c cellwidth = 1in} ; rbreak after /summarize style=[fontweight=bold]; /* Compute block used to create table title */ compute before _page_/style=[font=("Arial",12.5pt) vjust=middle just=center background=whitesmoke foreground=%RGB(0,145,204) font_weight=bold borderbottomcolor=%RGB(242,242,242)]; line "Comparison of New Agents"; /*%sysfunc(intnx(day,%sysfunc(today()),-7),worddate20.);*/ endcomp; compute Agency_Type; I + 1; if mod(i,2) eq 1 then call define(_row_, "style", "style=[background=%RGB(230,230,230)]"); endcomp; compute after; Agency_Type = 'Total'; call define (_row_,'style','style=[backgroundcolor=lightgray foreground=black]'); endcomp; run;   ... View more

I have the following list of numeric phone numbers and I want to convert them to standard phone number. Can someone recommend the best code for this? I cannot figure out where to even start with this.           ... View more

I have the following proc sql and output below.  I am trying to solve for remove duplicates by pulling in the INDV_CHNL_PTNR_ID with the MAX (Cert_Ranking). The Cert_Ranking column comes from a case statement I created in the original table. The having clause I am using is not working. Does anyone have any suggestions?  proc sql; create table test as select distinct * from MedicareSalesAgencies having max(Cert_Ranking) and indv_chnl_ptnr_id ; quit;   INDV_CHNL_PTNR_ID Cert_Ranking 29 11 29 3 29 2 29 11 29 3 29 2 29 11 29 3 29 2 29 11 29 3 29 2 34 3 34 2 34 3 34 2 34 3 34 2 34 3 34 2 34 3 34 2 34 3 34 2 34 3 34 2 34 3 34 2       ... View more