ok. And update A with information from B?
If A is registered in metadata the standard Table Loader should be able to do this.
Hi Linush,
Both Table A and B are registered in the metadata.
A B
groupid element pf group id element pf
I would like to compare the element and pf of both the tables A and B. if both match, i want to assign A.gorupid= B.group id. If the columns are not matching, I want to assign a new value to A.groupid using surrogate key generator.
Regards,
Sheeba Swaminathan
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 16. Read more here about why you should contribute and what is in it for you!
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.