topic Re: Update table with new values using SAS Data Integration Studio in SAS Programming

Update table with new values using SAS Data Integration Studio

ashna — Tue, 30 Oct 2018 22:48:28 GMT

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?

Re: Update table with new values using SAS Data Integration Studio

JBailey — Wed, 31 Oct 2018 12:14:49 GMT

Hi @ashna

The Table Loader Transformation will do this.

Check out: http://support.sas.com/documentation/cdl/en/etlug/67323/HTML/default/viewer.htm#n12xc125b6bgi2n1y22hohbzoji7.htm

Best wishes,

Jeff

Re: Update table with new values using SAS Data Integration Studio

ashna — Wed, 31 Oct 2018 17:51:54 GMT

Used Modify function. That worked well. Thanks everyone