Your query is being pushed into the remote database. So the data references need to point to data in that database.
Teradata is not going to recognize any SAS librefs or SAS datasets.
Tutorial on turning a program into a macro
https://github.com/statgeek/SAS-Tutorials/blob/master/Turning%20a%20program%20into%20a%20macro.md
@nid197 wrote:
Hi Tom,
Yes the above query gave me the results but i am just looking an efficient and less time consuming way to do it..i have to write the same query for all the other tables.this makes the program quite lengthy.can i do it using macros or so any loops.i believe we cant update multiple teradata tables at the same time.and even if we can the variables to be updated in those tables are not same they are different.some tables have 5 variable to be updated some just have 1.
I hope you get my question now.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.