Hi Everyone,
I have a Table1 with 3items with some charges
Table1:
Name Amount
Item 1 $500
Item 2 $260
Item 3 $800
When I get input file with Table 2 I need compare the values betrween Table 1 and Table 2 and if there any changes in Amount I need to update Table 1 with change.
Table2:
Name Amount
Item 1 $500
Item 2 $260
Item 3 $100
When I compare Table1 with Table 2 there is difference in amount for Item3.
So I have to update Table1 as follows: (instead of $800 in amount for Item3 I need to write $100)
Table1:
Name Amount
Item 1 $500
Item 2 $260
Item 3 $100
How can I do it using SAS Data Integration Studio?
Used Modify function. That worked well. Thanks everyone
Used Modify function. That worked well. Thanks everyone
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.