04-22-2015 12:29 AM
what option to display data step execution /resolve values in LOG window
like we use MPRINT, SYMBOLGEN in Macro to see resolve values in log file
i want to see data step (like Do loop values )execution /resolve values in log file
04-22-2015 10:32 AM
If this is base SAS then put and putlog. I don't know of any data step options, and I don't believe one exists. Of course the use of data steps are meant to process large amounts of data, so when reporting the value(s) of a variable(s) every time a data step loops would create even larger log files.
use putlog, especially if you are using put to output to a file.
use this to report the value of a single variable to the log:
use this to report all variables to the log:
Message was edited by: Philip Coltharp
04-22-2015 11:12 AM
As mentioned you can generate LOTS of output; But PUT is conditional so if you are looking for specific values or combinations of value or missing values you can selectively report on them.
A brief example:
input <input a bunch of variables from the data source>;
if DateOfBirth > DateOfService then put "ERROR: Date of Birth after Date of Service for ID " Idvar dateofbirth dateofservice;
So I get a message in the log that we have some error related to two dates and identifying information.
Added benefit, if you start the message with ERROR: or WARNING: in upper case with the colon then the text in the log will appear with the colors you have set for error or warnings, default red and yellow respectively.