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
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!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.