how to solve this problem?

Sathiskumar_D — Fri, 19 Apr 2019 07:50:57 GMT

%macro accountreport(State=);
proc sql;
title "&title";
create table mydata as
select Acct_ID,Name,birthday format ddmmyy8.0,Sex,State format $char8.,Cust_Type,Product,Balance,Last_Tran_Date=symget('tran_date')
from myprj2.profile2;
quit;
%mend accountreport;

ERROR: Expression using equals (=) has components that are of different data types.

proc content of the data is attached..

Re: how to solve this problem?

Kurt_Bremser — Fri, 19 Apr 2019 08:17:48 GMT

always make sure that your Base SAS code works before putting it in a macro
your macro is totally useless, as the macro parameter is never used in the macro, therefore remove the macro definition. You don't need it.
this causes your problem:

Last_Tran_Date=symget('tran_date')

When used in the select (and not in a where), it will result either in a zero (condition not met) or a 1 (condition is met).

BUT: last_tran_date is numeric, while the result of the symget() function is always of type character, and proc sql does not do type conversions on the fly (as the data step does), so this can't work.

You need to convert the result of your symget() to a proper SAS date value, and I guess you wanted this condition to be part of a where clause. How you convert depends on the contents of &tran_date.

topic how to solve this problem? in New SAS User

how to solve this problem?

Re: how to solve this problem?