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: 
accesnh
‎04-23-2019
  • 5 Posts
  • 0 Likes Given
  • 0 Solutions
  • 1 Likes Received

Re: Custom Sorting

by Fluorite | Level 6 in New SAS User
‎04-16-2019 03:16 PM
‎04-16-2019 03:16 PM
There is the same amount of records in each data set.  Also, I used UPPER to make everything the same case as well as compressed the data to remove any special characters.  Right now, each data set contains ~20,000 records.   I've never had to do something like this so I've been searching various online resources all day, but have yet to find a solution. ... View more

Custom Sorting

by Fluorite | Level 6 in New SAS User
‎04-16-2019 02:59 PM
‎04-16-2019 02:59 PM
I'm attempting to use COMPGED to compare names in two different data sets.  However, there's a large portion of the data that has the names in reverse order.  In order for the COMPGED to be more accurate, I'd like to sort the names in alphabetical order, but i'm having no luck doing so.   Have: NameSource1        NameSource2 JOHNSMITH          SMITHJOHN   Want: Sort(NameSource1)        Sort(NameSource2) HHIJMNOST                      HHIJMNOST ... View more

Re: How to concatenate multiple rows into one row with concatenated co...

by Fluorite | Level 6 in SAS Enterprise Guide
‎03-06-2019 11:53 AM
‎03-06-2019 11:53 AM
the 60119 and 60118 was a typo.  The above mentioned code worked perfectly.  No, the CSC will never be a duplicate because I'm making that a distinct field in a prior query.  Thanks! ... View more

How to concatenate multiple rows into one row with concatenated column

by Fluorite | Level 6 in SAS Enterprise Guide
‎03-06-2019 09:59 AM
1 Like
‎03-06-2019 09:59 AM
1 Like
I'm normally a point and click EG user, so I'm having trouble writing the code to produce the following results by writing code.    One issue I have is each ID_NUM can have an unknown count of CSC's associated to it.    work.DO Office ID_NUM Date of Birth BOSS_ID CSC 06 0233673 9/15/2010 60118 175X 06 0233673 9/15/2010 60118 152X 06 0233673 9/16/2010 60119 280X 06 0549153 5/18/1999 60321 921X 06 0549153 5/18/1999 60321 929X   to...   work.DO_NEW Office ID_NUM Date of Birth BOSS_ID CSC_NEW 06 0233673 9/15/2010 60118 175X, 152X, 280X 06 0549153 5/18/1999 60321 921X, 929X   Thanks for any help provided! ... View more

Create Total Row with Percentage

by Fluorite | Level 6 in SAS Enterprise Guide
‎07-27-2018 11:28 AM
‎07-27-2018 11:28 AM
    I created a list data report in a project that I run in the Excel Add-In.  I'm wondering if there's a way to create a percentage off of the total row that i created.  I would like to add in the percentage 634/1910 in the red circled box.  Can this be done within the List Data task or does this have to be coded in separately? Thanks for any help! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎04-23-2019 03:03 PM
Likes from
View All
Quick links