fedsql request

ajulio4 — Thu, 15 Feb 2024 14:45:59 GMT

Hello,

i have a macro variable in numeric. like &jour = 23040,

In CAS i try to find line where dateColumn > &jour bu i have the error :

ERROR: Operator is not unique: DATE > INTEGER

Can someone help me plz.

Re: fedsql request

SASJedi — Thu, 15 Feb 2024 15:33:36 GMT

FedSQL is pretty strictly ANSI compliant. Expressions require date constants to be written in ANSI-standard format - DATE'YYYY-MM-D'. The raw SAS date number must be formatted properly and surrounded by single quotes. You can use PUTN to format the value, but the dashes will be misinterpreted as a minus sign if you use %SYSFUNC to execute the PUTN function, and macro code won't execute if surrounded by single quotes.

Use QSYSFUNC to mask the dashes in the formatted text.
Use the %TSLIT macro to allow the macro code to resolve before adding the necessary single quotes.

Example:

data jours;
  input jour;
datalines;
23038
23039
23040
23041
23042
;

%let Aujourdhui=23040;
proc FedSQL;
select * 
	from jours
	where jour>=date%tslit(%qsysfunc(putn(&Aujourdhui,yymmddd10.)));
;
quit;

Hope this helps.

Re: fedsql request

ajulio4 — Fri, 16 Feb 2024 08:30:29 GMT

Hello. thks you so much. It helps and it works

topic Re: fedsql request in SAS Programming

fedsql request

Re: fedsql request

Re: fedsql request