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
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: