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: 
Kailash29
‎03-03-2023
  • 6 Posts
  • 4 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: How to find the master key from another column using SAS

by Fluorite | Level 6 in SAS Enterprise Guide
‎03-01-2023 02:22 AM
‎03-01-2023 02:22 AM
If 12 11 occurs then it would be 11 again because 12 is already connected to 11 earlier ... View more

Re: How to find the master key from another column using SAS

by Fluorite | Level 6 in SAS Enterprise Guide
‎02-27-2023 08:33 AM
‎02-27-2023 08:33 AM
Because 16 is already connect to 12 and 12 back tracts towards 11 ... View more

Re: How to find the master key from another column using SAS

by Fluorite | Level 6 in SAS Enterprise Guide
‎02-27-2023 05:38 AM
‎02-27-2023 05:38 AM
Hi Ksharp.. Thanks for your quick response.. When I saw deep into the data, I did find the scenario which you mention: if 16 16 occurs I need the key as 11 and 16 11 occurs as well the key needs to be 11 ... View more

Re: How to find the master key from another column using SAS

by Fluorite | Level 6 in SAS Enterprise Guide
‎02-24-2023 08:28 AM
‎02-24-2023 08:28 AM
16 16 then key will be 11 16 11 scenario will not occur because ID1 value cannot be linked to its lower value in ID2 ... View more

Re: How to find the master key from another column using SAS

by Fluorite | Level 6 in SAS Enterprise Guide
‎02-24-2023 07:26 AM
‎02-24-2023 07:26 AM
ID1 is the master key and values associated with it in ID2 will be linked values. ex : ID1 = 15 and its key is 11 because 15 in ID1 traces back to 12 in ID1 through 15 in ID2 and 12 in ID1 traces back to 11 in ID1 Hence master key for 15 in ID1 will be 11 ... View more

How to find the master key from another column using SAS

by Fluorite | Level 6 in SAS Enterprise Guide
‎02-24-2023 06:42 AM
‎02-24-2023 06:42 AM
I have a table where I have to find the values from each other columns and create a master key My table : ID1 ID2 11 11 11 12 11 13 12 15 12 16 15 17 18 18 18 19 20 21 22 23 22 24     Expected result :    ID1 ID2 Key 11 11 11 11 12 11 11 13 11 12 15 11 12 16 11 15 17 11 18 18 18 18 19 18 20 21 20 22 23 22 22 24 22   Key column needs to be generated as shown in column, how do I achieve using SAS EG. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎03-03-2023 05:50 PM
Likes given to
View All
Quick links