Within a data setp I am using a "call execute" like the one below: call execute("proc sql;
insert into leaddata values("||subjid||","||mhterm||","||mhstdtc_dtr||","||mhstdtc_dtr||","||mhstdtc_dtr||","||sitemnemonic||","||mhstdtc2||"d,"||mhendtc2||"d);quit;"); Everything works fine except the last 2 variables mhstdtc2 and mhendtc2, these variables are num type with an informat and format of date9. I receive a note that numeric variables are being converted to character on that line, How should the dates be inserted on the call execute statment. Thanks
... View more