cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
chemph
‎01-15-2016
  • 3 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Manipulating whole claim instead of claim line

by Calcite | Level 5 in SAS Programming
‎01-14-2016 06:04 PM
‎01-14-2016 06:04 PM
This doesn't seem to work. I get the same table I had to begin with. The other lines in the claim are not being populated appropriately ... View more

Re: Manipulating whole claim instead of claim line

by Calcite | Level 5 in SAS Programming
‎01-14-2016 05:13 PM
‎01-14-2016 05:13 PM
So currently, it's applying it only on the rows where the if statement is true. I want it applied to every row so long as the claim number(INT_CLM_NUM) is the same   I want the desired output to look like this (only when the if statement is true):   INT_CLM_NUM                CLM_LINE_NUM           MAP_CD              TOS_CAT1_CD                   TOS_CAT2_CD 123456789012345             0010                                 173                         FAC_IP                                 MATER 123456789012345             0020                                 174                         FAC_IP                                 MATER 123456789012345             0030                                  250                        FAC_IP                                 MATER 123456789012345             0040                                  300                        FAC_IP                                 MATER 888888888888888             0010                                  133                       FAC_IP                                   888888888888888             0020                                  216                        FAC_IP                                  777777777777777             0010                                  170                        FAC_IP                                 MATER 777777777777777             0020                                  412                        FAC_IP                                 MATER ... View more

Manipulating whole claim instead of claim line

by Calcite | Level 5 in SAS Programming
‎01-14-2016 04:41 PM
‎01-14-2016 04:41 PM
Hi all,   I need some help manipulating a dataset I have.   In a data step, the code below produces the table that follows   DATA Out.tmp1a; set out.tmp1;   if TOS_CAT1_CD = 'FAC_IP' and MAP_CD in ('170','171','172','173','174','175','179') then TOS_CAT2_CD = 'MATER'; else TOS_CAT2_CD = ‘UNKNOWN’;   RUN;   INT_CLM_NUM                CLM_LINE_NUM              MAP_CD              TOS_CAT1_CD                   TOS_CAT2_CD   123456789012345             0010                                       173                         FAC_IP                                 MATER 123456789012345             0020                                       174                         FAC_IP                                 MATER 123456789012345             0030                                       250                         FAC_IP 123456789012345             0040                                       300                         FAC_IP 123456789012345             0050                                       410                         FAC_IP                 Although the produced table is right, I want to rewrite my code to affect every claim (INT_CLM_NUM) that meets the criteria listed instead of the claim line(CLM_LINE_NUM)   So in this case, TOS_CAT2_CD should equal ‘MATER’ for every row in the table.   I’m having trouble figuring out how to write this.   Thank you for the help ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎01-15-2016 02:33 PM
Quick links