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: 
eric_balke
‎04-19-2016
  • 6 Posts
  • 4 Likes Given
  • 0 Solutions
  • 0 Likes Received

10 column to 5 column array

by Calcite | Level 5 in SAS Programming
‎07-12-2015 01:25 PM
‎07-12-2015 01:25 PM
Hello, I am trying to convert 10 dx columns per claim into 5 dx columns per claim, duplicating claims when dx's are greater than 5; The data I have is: claim     dx1 dx2 ...dx6....dx10 A          V22  V23....V24....... What I want is: claim     dx1 dx2 dx3 dx4 dx5 A          V22 V23 ................... A          V24 I am having trouble getting the array statements to work properly. Thanks! ... View more

Re: PROC SQL

by Calcite | Level 5 in SAS Programming
‎03-06-2015 06:42 PM
‎03-06-2015 06:42 PM
That worked!  I thought it might be a simple solution...thank you! ... View more

Re: PROC SQL

by Calcite | Level 5 in SAS Programming
‎03-06-2015 06:16 PM
‎03-06-2015 06:16 PM
That's a great idea to use Proc Format to create a format to apply in the Proc SQL select statement.  I will try it out and post back if/when I can get it to work.  Thank you! ... View more

PROC SQL

by Calcite | Level 5 in SAS Programming
‎03-06-2015 05:47 PM
‎03-06-2015 05:47 PM
Hi all, I am performing a data extracting using proc sql, and I have ran into a problem I can't figure out.  I think it may be a recursive join but am having trouble finding the solution.  I am joining 12 tables with left outer joins, but the problem I am having is I need pcp info, rendering md info, and referring md info from a doctors table but they are all joined to my initital table with the same primary key, doctor number. Visually here is a boiled down version of what I have in the billing data: patient_id      pcp     ref_md     rend_md 1                    20         21          22 3                    30          31          Here is what i have for the doctors table: doctor_id          doctor_name          doctor_phone          etc.... 20                         Tom                         33333                    21                         Jane                         44444     22                         Mary                         55555 30                         Andy                         66666 31                         Bill                             77777 What I want to have as the output is: patient_id     pcp     pcp_name     pcp_phone     ref_md     ref_name     ref_phone     rend_md     rend_name     rend_phone 1                    20     Tom               33333               21              Jane          44444          22               Mary                55555 I have to include this along with the 11 other left outer joins in my PROC SQL step also.  Any help is greatly appreciated! ... View more

Re: Retaining value of variable to set another variable within a by-gr...

by Calcite | Level 5 in SAS Programming
‎06-26-2014 01:50 PM
‎06-26-2014 01:50 PM
Above is an image of the actual data.  The first problem which is depicted above is that there can be multiple Bucketing values for a given order.  I need to attribute other lines within the same order to either Bucket or neither depending on the value of prodcat.  The second, and bigger proglem I think, (sorry I wasn't clear in the first question) is that a given prodcat can apply to more than one "Bucketing" category, and the value I assign to Bucketing for a given prodcat depends on the value encountered on the order for Bucketing.  This problem is depicted in the following images.  In the first image, all lines where prodcat is 20 should be assigned a Bucketing value of CPAP, whereas in the second image all lines where prodcat is 20 should be assigned a Bucketing value of BiPAP. Thanks again for your time! ... View more

Retaining value of variable to set another variable within a by-group

by Calcite | Level 5 in SAS Programming
‎06-26-2014 01:15 PM
‎06-26-2014 01:15 PM
Hi all, I have a problem I'm trying to solve and am in the middle of researching it but thought I'd try here as well.  Any help is greatly appreciated. The data set I have is large but the operative fields are as follows: order_no     pc_cat     pc_cat_no 1                    X               21 1                    Y               11 1                  NULL          22 1                 NULL           12 2                    X               21 2                 NULL            22 2                 NULL             3 What I need to do is reset the NULL values to X where pc_cat_no is equal to 22, and set the NULL values to Y where pc_cat_no is equal to 12 (because in the actual data pc_cat_no 12 is related to 11 and pc_cat_no 22 is related to 21), and leave NULL where pc_cat_no is anything else; but the hard part is I need to only search for and replace NULL's based on pc_cat_no within a given order_no. I think it may be the retain function or some variant, but have been unable to crack the code thus far. Thanks! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎04-19-2016 04:38 PM
Likes given to
View All
Quick links