Hi SASkiwi,   You are right, and I do hightlight my industry/domain experience. However, I am seeing that SAS as an analytical tool is losing traction in many industries other than biostatistics and clinical trials. I am too old a dog to learn new tricks, but I have a feeling I may need to bite the bullet and start learning Python, databricks, PowerBI etc. Thanks for your tip, though. Much appreciated! Jit ... View more

Thank you, BallardW, for the pointers. I will change the code to do joins instead. Still waiting for my work space, but will use your suggestions when I am ready to execute. Thanks again! ... View more

Thanks to Tom and LinusH for your responses. I believe the key is to have a dedicated workspace on teradata where temp files could be stored. I have requested this space from the admin. Once I get it, I will try your suggestions again. As of now, the code inserts rows 1 at a time and does not use multi inserts. This is why it's taking so long. The options statement really helped in analyzing this. Thank you. ... View more

Ok, thank you. Will try these options to trace the process. I am still struggling a bit with Tom's suggestion. Will include both your suggestions. Will be out for a few days, but will get back later this week. Thanks again! ... View more

Thank you so much, Tom! Will try this and get back on the thread.   Jit ... View more

Thank you so much for the tip. Will try these options to fine tune and post. ... View more

You are right. I created a lib name for the second database connection and referred to the temp table with a TDWORK prefix. It worked. The only concern is that it's taking a very long time to create the temp table with the set statement. Don't know if that is due to my particular environment, or due to SAS. ... View more

Yes, in the same session. Here is the log.    73 /* Temp Table of SSN to join with BMG */ 74 libname TDWORK teradata SYMBOLGEN: Macro variable USER resolves to  SYMBOLGEN: Macro variable PWORD resolves to  74 ! user="&user.@LDAP" password=&pword tdpid=bmg dbmstemp=yes connection=global; NOTE: Libref TDWORK was successfully assigned as follows: Engine: TERADATA Physical Name: bmg 75 /*proc sql; drop table TDWORK.FDR_TIN_jb; quit;*/ 76 77 data TDWORK.FDR_TIN_jb ; 78 set one_per_good_ssn(obs=100); 79 run;   NOTE: SAS variable labels, formats, and lengths are not written to DBMS tables. NOTE: There were 100 observations read from the data set WORK.ONE_PER_GOOD_SSN. NOTE: The data set TDWORK.FDR_TIN_jb has 100 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 4.12 seconds cpu time 0.02 seconds     80 81 proc sql ; 82 connect using TDWORK ; 83 execute by TDWORK ( 84 create volatile table test as ( 85 select * from FDR_TIN_jb 86 ) with data on commit preserve rows 87 ); 88 quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.05 seconds cpu time 0.00 seconds     89 90 /*proc print data=tdwork.test; run;*/ 91 92 /* Join on SSN to get CUST_NUM */ 93 proc sql ; 93 ! 94 connect to 94 ! teradata(user="&user.@LDAP" password=&pword tdpid=bmg database=Bmgpcust mode=teradata); SYMBOLGEN: Macro variable USER resolves to  SYMBOLGEN: Macro variable PWORD resolves to  95 create table Cust_Mstr_Wk_Curr_Cdb as select * from connection to teradata 96 ( Select 97 a.SSN , 98 b.Cust_Tin , 99 b.Cust_Num , 100 b.Cust_Co_Id 101 from test a, /* Problem in syntax here */ 102 Bmgpcust.Cust_Mstr_Wk_Curr_Cdb b 103 where a.SSN = b.Cust_Tin 104 ); ERROR: Teradata prepare: Object 'test' does not exist. SQL statement was: Select a.SSN , b.Cust_Tin , b.Cust_Num , b.Cust_Co_Id from test a, Bmgpcust.Cust_Mstr_Wk_Curr_Cdb b where a.SSN = b.Cust_Tin. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 105 quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.39 seconds cpu time 0.01 seconds     ... View more

Hi Tom,   I tried this and your code works to create TEST, but it's still giving me the same error when I try to join. ERROR: Teradata prepare: Object 'test' does not exist. ... View more

I meant right-click on the saved jpeg file...outside of SAS, and in my case, in Windows. Sorry, wasn't clear the first time. When right-clicking on the file and choosing properties, there is no other information on the Details tab other than the image dimensions and location. I am trying to embed the image in a google site. Web sites usually require an image ID to embed images. That was my understanding. I may be wrong. ... View more