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: 
ch835
‎02-19-2022
  • 2 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: merging many to many datasets with varying data

by Calcite | Level 5 in SAS Programming
‎02-17-2022 09:14 PM
‎02-17-2022 09:14 PM
Sorry, think perhaps this example would be clearer:   Table A   IdentifierCode      Year      Rating  CN045                  2000       B CN045                  2001       C CN045                  2003       A     Table B  IdentifierCode      Year     Alternate Code CN045                   2001    336     So basically after sorting both Tables A and B by identifier code, tried to merge both    data tablemerged; merge TableA TableB; by IdentifierCode; run;   (this is after PROC SORT of both tables A and B by IdentifierCode)      The result is in tablemerged: IdentifierCode      Year      Rating         Alternate Code CN045                  2000       B CN045                  2001       C CN045                  2003       A CN045                   2001                         336     However, would like the result to be following based on Table A:   IdentifierCode      Year      Rating    Alternate Code CN045                  2000       B          336 CN045                  2001       C          336 CN045                  2003       A           336   So basically, just based on single line item, the alternate code can be populated into Table A based on Identifier Code.   Assuming that merging by Year variable (so looking for similar year 2000 with 2000) is not important; just match by IdentifierCode..    Thank you!                 ... View more

merging many to many datasets with varying data

by Calcite | Level 5 in SAS Programming
‎02-17-2022 10:41 AM
‎02-17-2022 10:41 AM
Hi all, am relatively news to SAS Programming and would like to check what would be the code for the possibility of obtaining the merged code as specified below?   TABLE A  (reference table)   Year          Identifier Code         Rating 2000                NM056            B 2002                NM056            A 2004                NM056            C 2005                NM056            B 2007                NM056            C   TABLE B   Year         Identifier Code         Alternative Code 2000                NM056            336 2001                NM056            336 2002                NM056            336 2006                NM056            336 2007                NM056            336     Looking at returning the following (merged code)    TABLE A   Year                Identifier Code           Rating             Alternative Code 2000                NM056                        B                      336 2002                NM056                        A                      336 2004                NM056                        C                      336 2005                NM056                        B                      336 2007                NM056                        C                      336 *Note years are also based on Table A, reference table   Have tried the standard merge function by Table A and B, sorted by Identifier Code but the results are not as specified..    Thank you!    ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎02-19-2022 06:22 AM
Quick links