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: 
billsut1961
‎03-24-2023
  • 3 Posts
  • 0 Likes Given
  • 1 Solutions
  • 0 Likes Received

Re: Merging/Joining 2 Datasets Where 1 Column has Blanks

by Fluorite | Level 6 in SAS Programming
‎03-21-2023 01:28 PM
‎03-21-2023 01:28 PM
I apologize for taking so long to respond.  I was under pressure to get this completed so I went to another guru in my building.  He gave me a good start and the result is below.  Thank you for trying to help but I don't think I articulated the problem well enough to you.   PROC SQL; CREATE TABLE LANGUAGE_COMBINED AS SELECT CASE WHEN A.ASC IS NOT NULL AND B.ASC IS NOT NULL THEN 'MATCH' WHEN A.ASC IS NOT NULL THEN 'PULL_OUT' WHEN A.ASC IS NULL AND B.ASC IS NULL THEN 'DELETE' ELSE 'REFRESH' END AS MATCH_STATUS ,COALESCE(A.ASC,B.ASC) AS ASC ,COALESCE(A.LANGUAGE_CODE,B.LANGUAGE) AS CODE ,A.* ,B.* FROM PULL_OUT_DATA as a FULL OUTER JOIN REFRESH_FIXED_OUTPUT AS B ON A.ASC EQ B.ASC AND A.LANGUAGE_CODE EQ B.LANGUAGE ; QUIT; ... View more

Re: Merging/Joining 2 Datasets Where 1 Column has Blanks

by Fluorite | Level 6 in SAS Programming
‎03-20-2023 11:12 AM
‎03-20-2023 11:12 AM
There are more variables in both datasets.  I only showed these for simplification.  I have to keep the blank values which is why I said I need my output to look like the merged dataset.  Each person has a different number of records.  I need the values in Lang_SourceA to line up with the values in Lang_sourceB without changing the order in Lang_SourceB because these are in order for a reason.  Dataset 1 is input from the customer and the order they used was just random.  I'm now trying to come up with code that will loop through each group/person.  I'm sure I'll need to use arrays but haven't figured it out yet. ... View more

Merging/Joining 2 Datasets Where 1 Column has Blanks

by Fluorite | Level 6 in SAS Programming
‎03-20-2023 10:31 AM
‎03-20-2023 10:31 AM
Hello.  I'm using SAS 9.4.  I have 2 datasets with an example shown below.   Dataset 1                                                                 Dataset 2   Person  Lang_SourceA                                          Person  Lang_SourceB Bob       RU                                                             Bob       SP Bob       SP                                                             Bob       RU Bob                                                                         Bob       GE Bob                                                                         Bob      UK Sam                                                                        Sam     CM Sam      CM                                                            Sam     GE Sam                                                                        Sam     UK Sally      RU                                                             Sally    SP Sally                                                                        Sally    UK Sally                                                                        Sally    RU   I want the final merged dataset to look like this.  The order of Lang_SourceB must stay the same.  Lang_SourceA needs to be reordered within each person to match the value in Lang_SourceB:   Person  Lang_SourceA  Lang_SourceB Bob       SP                     SP Bob        RU                    RU Bob                                 GE Bob                                 UK Sam      CM                    CM Sam                               GE Sam                               UK Sally                               SP Sally                               UK Sally     RU                     RU   I have tried many variations of merge and Proc SQL with no good results.  I would greatly appreciate any suggestions you can provide.   Thank you in advance. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎03-24-2023 06:47 AM
Quick links