fedsql request

[ajulio4]

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.

[SASJedi · Accepted solution]

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. 

1. Use QSYSFUNC to mask the dashes in the formatted text.
2. 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.

[ajulio4]

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