Dear all,
I have two datasets, HAVE and TEMP (quite many observations)
HAVE has the variables
FileNO | PRODUCT | Date_PMT | PMT_AMOUNT |
TEMP has the same as TEMP variables plus two more
FileNO | PRODUCT | Date_PMT | PMT_AMOUNT | STATUS PRD | PMT_DTL_NO |
The issue is that vars STATUSPRD and PMTDTLNO do not exist in HAVE (then I would have one-to-one maching)
My goal is to compare "Total PMT AMOUNT" by PRODUCT and by QTR_YR (can be derived from var Date_PMT)
from both Datasets.
I tried a FULL JOIN but one-to -many joins occur.
Then I run PROC TABULATE but now I have distorted "Total PMTAMOUNT" due to one-to -many joins.
I have attached a png that shows various cases (before the FULL JOIN)
Any suggestions /hints will be more than welcome.
Thanking you in advance.
Are the file number and the product number the same for a given record across HAVE and TEMP? If so, then is it as simple as a compound key?
select
have.fileno,
have.product.
have.date_pmt,
have.pmt_amount,
temp.date_pmt,
temp.pmt_amount
from
have inner join temp on have.fileno = temp.fileno and have.product = temp.product
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.