Hello, I hope this makes sense I would like to create the following table by grouping IPA_Num and IPA_Name: IPA_Num         IPA_Name                                       Commercial Medicare IP0000002001 SUTTER INDEPENDENT PHYSIC 1                  1   Instead, I am getting the below results IPA_Num         IPA_Name                                       Commercial Medicare IP0000002001 SUTTER INDEPENDENT PHYSIC 1 IP0000002001 SUTTER INDEPENDENT PHYSIC                      1   Code /*Create unique list of IPA's from the enrollment file*/ Proc SQL; Create table enroll_IPA as Select distinct memberenrollmentcustomcode2 as IPA_Num, UPPER(memberenrollmentcustomcode4) as IPA_Name, "" as Commercial, "" as Medicare, (CASE When PayerCode in('C',) AND ProductCode in ('H','S','K') THEN 'Commercial' When PayerCode in ('RR', 'NR', 'RM') AND ProductCode in('H') Then 'Medicare' ELSE 'XX' END) FORMAT=$30. AS Product From enroll.ENROLLMENT_BIS_FINAL_COLLAPSED Order by IPA_Num, IPA_Name ; Quit; Data enroll_IPA1 ; set enroll_IPA; if Product = 'XX' then delete; if Product = 'Commercial' then Commercial=1; if Product = 'Medicare' then Medicare=1; Drop Product; run; ... View more

Hi, I read the previous solutions on this board on removing a character from a string, but I still do not understand it.   I have a field called Code and in this field, there are some "." that I would like to remove (J.045). The below is what I have so far, but it does not work: Data VSD22; Set VSD21; Code=tranwrd(Code,'.',''); end;   Thank you in advance ... View more