Hi, i am trying to get some data, based on a macro variable, but get the error ERROR: The length of the value of the macro variable LISTA_DESTINATARIOS (65540) exceeds the maximum length (65534). The value has Been truncated to 65534 characters. I tried do make de macro limit bigger with Options mexecsize=800000; Options MVARSIZE =800000; Options MSYMTABMAX=800000; But doesn’t work, i get de error: ERROR 18-12: Option value for SAS option MVARSIZE must be between 0 and 65534 i tried do get de date of using a table instead of a macro variable but the query keep running for ever, a think this happen because of something about get data from oracle tables and sas tables. With macro almost work, i can get the date until reach macro limit. not English native speaker pls be patient I am using SAS Enterprise Guide 7.1 thanks a lot
... View more