topic Re: what option to display data step execution/resovle values in LOG in SAS Procedures

what option to display data step execution/resovle values in LOG

RajasekharReddy — Wed, 22 Apr 2015 04:29:18 GMT

Hi ,

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

regards,

Rajasekhar Reddy

Re: what option to display data step execution/resovle values in LOG

art297 — Wed, 22 Apr 2015 04:39:08 GMT

For $100: What is "put" and or "putlog"

Re: what option to display data step execution/resovle values in LOG

PhilC — Wed, 22 Apr 2015 14:32:21 GMT

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:

putlog var=;

use this to report all variables to the log:

putlog _all_;

Message was edited by: Philip Coltharp

Re: what option to display data step execution/resovle values in LOG

ballardw — Wed, 22 Apr 2015 15:12:43 GMT

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:

data new;

Infile datasource;

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;

run;

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.