The Teradata Team at my company created the Permanent table for me, supposedly. I actually don't know where that table is located on the server either... which I feel is a problem as well. I'm still quite a beginner at SAS programing and I don't feel adequate to alter the code... I'm lost at times on what to replace, and where... When I asked the same Teradata Team for a base code to use, they sent me the code below... I took it and tweaked it, but no matter what add ons they suggested, my code still has errors. So I'm at a point where I feel quite lost. I almost want to abandon my attempt at this... yet I'll soon have 60,000+ Member_Key's that I'll need to pull claims data for. This is the purpose that I want the permanent table up and running. I have no clue another work around to this... if there is another solution besides using a permanent table, please let me know. Base Code from the Teradata Team: This is what we did for another project. %let userid=yourid; %let passtera=yourpass; %let edlsrvr=DWTEST2; ** wlpedl for production **; %let edldb= dbname; libname edluat teradata user=&userid. password=&passtera. TDPID=&edlsrvr. SCHEMA=&edldb.; proc sql exec feedback stimer; create table edluat.ANY_NAME_YOU_WANT(FASTLOAD=yes) as select * from Your_SAS_table; quit;
... View more