Hi Experts, I am running a code and it is showing syntax error. I am unable to spot what is the mistake in the code. Can you please check and let me know? proc sql; create table File_for_the_ticket as select a.*, from work.final_file where non_uk_PC = 0; quit; Error log: 28 29 proc sql; 30 create table File_for_the_ticket as 31 select a.*, 32 from work.final_file ____ 22 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, (, *, **, +, ',', -, /, <, <=, <>, =, >, >=, ?, AND, BETWEEN, CONTAINS, EQ, EQT, FROM, GE, GET, GT, GTT, LE, LET, LIKE, LT, LTT, NE, NET, OR, ^=, |, ||, ~=. 33 where non_uk_PC = 0; _____ 22 76 ERROR 22-322: Syntax error, expecting one of the following: a quoted string, !, !!, &, *, **, +, ',', -, /, <, <=, <>, =, >, >=, ?, AND, AS, BETWEEN, CONTAINS, EQ, EQT, FORMAT, FROM, GE, GET, GT, GTT, IN, INFORMAT, INTO, IS, LABEL, LE, LEN, LENGTH, LET, LIKE, LT, LTT, NE, NET, NOT, NOTIN, OR, TRANSCODE, ^, ^=, |, ||, ~, ~=. ERROR 76-322: Syntax error, statement will be ignored. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 34 quit; ... View more

Hi Experts, I have been trying to find the distinct dcphonenumbers and I have used select distinct but in the output data, it gives me duplicate dcphonenumbers also. Can you please check and suggest what's the mistake in the code? proc sql; create table Dialled_numbers as select distinct a.*, b.dcPhoneNumber from work.confirmed_email as a inner join DIALFILE.tDiallerCalls as b on a.account_number=b.dcaccountnumber; quit; LOG 29 proc sql; 30 create table Dialled_numbers as 31 select distinct 32 a.*, 33 b.dcPhoneNumber 34 35 from work.confirmed_email as a 36 inner join DIALFILE.tDiallerCalls as b on a.account_number=b.dcaccountnumber 37 ; NOTE: Compressing data set WORK.DIALLED_NUMBERS decreased size by 90.69 percent. Compressed is 1679 pages; un-compressed would require 18034 pages. NOTE: Table WORK.DIALLED_NUMBERS created, with 721344 rows and 14 columns.   ... View more

Hi Experts, I am trying to find where the date is not missing and running the code. The code runs successfully but there is not output. Can you please check and let me know what is the mistake I am making? There is nothing in the result and output tab. proc sql; create table confirmed_email as select a.*, b.emailaddress, b.confirmeddate from Live_phone_numbers as a inner join p2scflow.emailaddress as b on a.Accounts_number = b.debt_code where b.confirmeddate is not missing; quit; LOG: 29 proc sql; 30 create table confirmed_email as 31 select a.*, 32 b.emailaddress, 33 b.confirmeddate 34 from Live_phone_numbers as a 35 inner join p2scflow.emailaddress as b on a.Accounts_number = b.debt_code 36 where b.confirmeddate is not missing; NOTE: Compressing data set WORK.CONFIRMED_EMAIL decreased size by 91.42 percent. Compressed is 1009 pages; un-compressed would require 11766 pages. NOTE: Table WORK.CONFIRMED_EMAIL created, with 482398 rows and 13 columns. 37 quit; NOTE: PROCEDURE SQL used (Total process time): ... View more

Hi Expert, I am trying  to find some information from the database and I feel that I have correctly written the code but I am getting error as following columns were not found in the contributing tables. I checked the columns in telephonenumbers database and these columns are available in the telephonenumber tables. Please suggest what is the error. proc sql; create table phone_numbers as select   tnkey as debt_code, tnphone, tntype  from p2scflow.telephonenumbers where tntype = 'D'; quit; error: 29 proc sql; 30 create table phone_numbers as 31 select  tnkey as debt_code, 32 tnphone, 33 tntype  34 from p2scflow.telephonenumbers 35 where tntype = 'D'; ERROR: The following columns were not found in the contributing tables: 'tntype 'n, ' tnkey'n. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 36 quit; ... View more