topic Re: help with syntax error in SAS Programming

help with syntax error

LMSSAS — Thu, 18 Nov 2021 17:37:21 GMT

Can someone look at this portion of my code below; I'm getting the following errors. I have been at this all morning and cannot get the code to run. Thank you in advance for any advice

intck('month', input('Appointment Effective Date'n, anydtdte10.), input('Appointment Expiration Date'n, anydtdte10.)) as month_dif,
case
when calculated month_dif lt 36 then "Presumed Correct"
when calculated month_dif ge 37 then "Create New Start Date"
end as 'new_start_dt_id_1'n,
case
when calculated month_dif ge 37 then intnx('month', 'Appointment Expiration Date'n, -24, 's')
end as 'new_start_dt'n format=date9.,
case
when calculated 'new_start_dt'n ge today() then "Unknown"
else "" end as 'future_dt_id'n

Re: help with syntax error

Reeza — Thu, 18 Nov 2021 17:46:37 GMT

Can you show the actual log instead of just the error screenshot?
The log is usually more informative.

Also, please include the whole query, not just the portion.

Re: help with syntax error

LMSSAS — Thu, 18 Nov 2021 18:02:57 GMT

Reeza - Thank you for the response. This is my first time posting in the SAS community and am not sure what is too much and not enough. Below the Log I also posted the full query

proc sql;
36 create table Inactive_DFS as
37 Select
38 'Licensee Name'n,
39 'License Number'n,
40 input('Appointment Effective Date'n, anydtdte10.) AS 'Appointment Effective Date'n FORMAT=DATE9.,
41 input('Appointment Expiration Date'n, anydtdte10.) AS 'Appointment Expiration Date'n FORMAT=DATE9.,
42 input('Appointment Status Date'n, anydtdte10.) AS 'Appointment Status Date'n FORMAT=DATE9.,
43 'Appointing Entity Number'n,
44 'Appointment TYCL number'n,
45 NPN Number,
______
22
46 intck('month', input('Appointment Effective Date'n, anydtdte10.), input('Appointment Expiration Date'n, anydtdte10.))
_ _ _
79 79 79
200 200
46 ! as month_dif,
ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, (, *, **, +, ',', -, '.', /, <, <=, <>, =, >, >=, ?, AND, AS,
CONTAINS, EQ, EQT, FROM, GE, GET, GT, GTT, LE, LET, LIKE, LT, LTT, NE, NET, OR, ^=, |, ||, ~=.

ERROR 79-322: Expecting a ).
ERROR 200-322: The symbol is not recognized and will be ignored.

47
48 case
49 when calculated month_dif lt 36 then "Presumed Correct"
____
22
76
ERROR 22-322: Syntax error, expecting one of the following: a name, ;, (, ',', '.', ANSIMISS, AS, CROSS, EXCEPT, FULL, GROUP,
HAVING, INNER, INTERSECT, JOIN, LEFT, NATURAL, NOMISS, ORDER, OUTER, RIGHT, UNION, WHERE.

ERROR 76-322: Syntax error, statement will be ignored.

50 when calculated month_dif ge 37 then "Create New Start Date"
51 end as 'new_start_dt_id_1'n,
52 case
53 when calculated month_dif ge 37 then intnx('month', 'Appointment Expiration Date'n, -24, 's')
54 end as 'new_start_dt'n format=date9.,
55 case
56 when calculated 'new_start_dt'n ge today() then "Unknown"
57 else "" end as 'future_dt_id'n
58
59 From INACTIVE_06020_05687_87022_33461
60 where NPN Number in (&NATL_PDCR_NB.)
61 ;
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
62 Quit;
NOTE: The SAS System stopped processing this step b

proc sql;
create table Inactive_DFS as
Select
'Licensee Name'n,
'License Number'n,
input('Appointment Effective Date'n, anydtdte10.) AS 'Appointment Effective Date'n FORMAT=DATE9.,
input('Appointment Expiration Date'n, anydtdte10.) AS 'Appointment Expiration Date'n FORMAT=DATE9.,
input('Appointment Status Date'n, anydtdte10.) AS 'Appointment Status Date'n FORMAT=DATE9.,
'Appointing Entity Number'n,
'Appointment TYCL number'n,
NPN Number,
intck('month', input('Appointment Effective Date'n, anydtdte10.), input('Appointment Expiration Date'n, anydtdte10.)) as month_dif,
case
when calculated month_dif lt 36 then "Presumed Correct"
when calculated month_dif ge 37 then "Create New Start Date"
end as 'new_start_dt_id_1'n,
case
when calculated month_dif ge 37 then intnx('month', 'Appointment Expiration Date'n, -24, 's')
end as 'new_start_dt'n format=date9.,
case
when calculated 'new_start_dt'n ge today() then "Unknown"
else "" end as 'future_dt_id'n

From INACTIVE_06020_05687_87022_33461
where NPN Number in (&NATL_PDCR_NB.)
;
Quit;

Re: help with syntax error

Reeza — Thu, 18 Nov 2021 18:15:21 GMT

NPN Number needs the quotes and N as well, ie

'NPN Number'n

EDIT: note this is in more than one place in your code so you need to fix all of them.

Re: help with syntax error

Reeza — Thu, 18 Nov 2021 18:18:21 GMT

And just a last note, if you're working with an imported file, it's a good idea to set the following options so that you don't have spaces in the names. It makes life easier.

option validvarname=v7;

The default in Studio is Any which allows spaces in names but makes it a pain to work with.

Re: help with syntax error

LMSSAS — Thu, 18 Nov 2021 18:22:54 GMT

Thank you, I appreciate it. When I make your suggested change, I get the following errors all referencing the below where staement: I went through the intck statement and changed the 'lt' and 'ge' to < or > and still get the same error. DO you have any recommendation for this?

where 'NPN Number'n in (&NATL_PDCR_NB.)

ERROR: Function INTNX requires a numeric expression as argument 2.
ERROR: Character expression requires a character format.
ERROR: Expression using greater than or equal (>=) has components that are of different data types.

Re: help with syntax error

LMSSAS — Thu, 18 Nov 2021 18:26:13 GMT

Thank you for this!!

Re: help with syntax error

Reeza — Thu, 18 Nov 2021 18:33:41 GMT

It was easy to find that first error because SAS underlined it.
If you post the whole log it makes it very easy to see exactly where the error is.

I suspect it's here:
when calculated month_dif ge 37 then intnx('month', 'Appointment Expiration Date'n, -24, 's')

You need to convert it as you did in the INTCK calculations or add the key word CALCULATED to use the newly converted variable.

Appointment Expiration date isn't a date as you convert it earlier

Re: help with syntax error

LMSSAS — Thu, 18 Nov 2021 18:35:56 GMT

I will make sure moving forward that I copy the log for every new error and question.

Thank you again for your time today !!!

Re: help with syntax error

Kurt_Bremser — Thu, 18 Nov 2021 20:28:33 GMT

And when you post logs, use this button:

This will keep the horizontal position of markers.

The "little running man" next to it is for SAS code, it provides coloring similar to the Enhanced Editor.

Re: help with syntax error

LMSSAS — Thu, 18 Nov 2021 20:35:01 GMT

Thank you, I will use these.
i appreciate the inforamtion