Hi, I'm pretty new to SAS EG.  I am trying to join a table from teradata to a table I created in my work library called Work.jobs.  Below is my code but I get an error.  I put the error below my code.  Orginianlly I was going to try and connect the teradata table to a sequel server table but I wasn't sure if that was possible.  So intead, I created my work.jobs table from sequel server so that I can join it from my local folder to teradata instead.     proc sql; connect to teradata(user="&user.@LDAP" tdpid=whlsp pass="&password."); drop table work.hr; create table work.hr as select * from connection to teradata ( select a.* from WDM_S_HR_NPRIV_S0.VW_CP_PROFILE_PUB a join work.jobs b on a.emplid=b.Job_Owner_empid ); disconnect from teradata; quit;       Error: 43 proc sql; 44 connect to teradata(user="&user.@LDAP" tdpid=whlsp pass="&password."); 45 drop table work.hr; NOTE: Table WORK.HR has been dropped. 46 create table work.hr as 47 select * from connection to teradata ( 48 select a.* 49 from WDM_S_HR_NPRIV_S0.VW_CP_PROFILE_PUB a 50 join work.jobs b on a.emplid=b.Job_Owner_empid 51 52 53 ); ERROR: Teradata prepare: Syntax error, expected something like a name or a Unicode delimited identifier or an 'UDFCALLNAME' keyword or '(' between the 'join' keyword and the 'work' keyword. SQL statement was: select a.* from WDM_S_HR_NPRIV_S0.VW_CP_PROFILE_PUB a join work.jobs b on a.emplid=b.Job_Owner_empid. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 54 disconnect from teradata; NOTE: Statement not executed due to NOEXEC option. 55 quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.42 seconds cpu time 0.01 seconds ... View more

Hi I'm using SAS EG 7.1 (64 bit) and trying to create a libname to access an excel spreadsheet (2016 xlsx) on my local drive.  I believe SAS is also on my machine, not on a server.  Below is the code that I'm using.  I noticed that the libname does create the library called "CAMPLIS" in the server window but it does not contain the worksheet called DATALIST.   I get an error when trying to run a proc contents step on the DATALIST worksheet within the excel preadsheet.    Please see attached screenshots.       Here is my code: options validvarname=v7; libname CAMPLIS xlsx "\\cala801nvs1.wellsfargo.com\C_RBGBBG_Users\galeanfr\My Documents\SAS\Campaigns.xlsx"; proc contents data=CAMPLIS.DATALIST; run; libname CAMPLIS CLEAR;     Here is the error: 1 The SAS System 09:47 Wednesday, July 15, 2020 1 %_eg_hidenotesandsource; MPRINT(_EG_HIDENOTESANDSOURCE): options nonotes; MPRINT(_EG_HIDENOTESANDSOURCE): options nosource; MPRINT(_EG_RESTORENOTESANDSOURCE): options NOTES; MPRINT(_EG_RESTORENOTESANDSOURCE): options SOURCE; 5 %_eg_hidenotesandsource; MPRINT(_EG_HIDENOTESANDSOURCE): options nonotes; MPRINT(_EG_HIDENOTESANDSOURCE): options nosource; MPRINT(_EG_RESTORENOTESANDSOURCE): options NOTES; MPRINT(_EG_RESTORENOTESANDSOURCE): options SOURCE; 40 41 options validvarname=v7; 42 43 libname CAMPLIS xlsx "\\cala801nvs1.wellsfargo.com\C_RBGBBG_Users\galeanfr\My Documents\SAS\Campaigns.xlsx"; NOTE: Libref CAMPLIS was successfully assigned as follows: Engine: XLSX Physical Name: \\cala801nvs1.wellsfargo.com\C_RBGBBG_Users\galeanfr\My Documents\SAS\Campaigns.xlsx 44 45 proc contents data=CAMPLIS.DATALIST; ERROR: File CAMPLIS.DATALIST.DATA does not exist. 46 run; NOTE: Statements not processed because of errors noted above. NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: The SAS System stopped processing this step because of errors. 47 48 libname CAMPLIS CLEAR; NOTE: Libref CAMPLIS has been deassigned. 49 50 %_eg_hidenotesandsource; MPRINT(_EG_HIDENOTESANDSOURCE): options nonotes; MPRINT(_EG_HIDENOTESANDSOURCE): options nosource; MPRINT(_EG_RESTORENOTESANDSOURCE): options NOTES; MPRINT(_EG_RESTORENOTESANDSOURCE): options SOURCE; 65 66 67 %_eg_hidenotesandsource; MPRINT(_EG_HIDENOTESANDSOURCE): options nonotes; MPRINT(_EG_HIDENOTESANDSOURCE): options nosource; MPRINT(_EG_RESTORENOTESANDSOURCE): options NOTES; MPRINT(_EG_RESTORENOTESANDSOURCE): options SOURCE; 70   ... View more