topic Re: put statement when writing out to csv in SAS Programming

put statement when writing out to csv

kimdukes77 — Fri, 10 Jan 2020 13:59:02 GMT

Hello,

I have inherited some code that uses a put statement within data _null_ step to write out to csv. Is there any way to prevent the put statement from writing out values to the log? Thanks

Log

83129 data _null_;
83130 set sashelp.class;
83131 put name;
83132 run;

Alfred
Alice
Barbara
Carol
Henry
James
Jane
Janet
Jeffrey
John
Joyce
Judy
Louise
Mary
Philip
Robert
Ronald
Thomas
William
NOTE: There were 19 observations read from the data set SASHELP.CLASS.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

Re: put statement when writing out to csv

DWilson — Fri, 10 Jan 2020 14:17:10 GMT

@kimdukes77 wrote:
Hello,

I have inherited some code that uses a put statement within data _null_ step to write out to csv. Is there any way to prevent the put statement from writing out values to the log? Thanks

Log
83129 data _null_;
83130 set sashelp.class;
83131 put name;
83132 run;
Alfred
Alice
Barbara
Carol
Henry
James
Jane
Janet
Jeffrey
John
Joyce
Judy
Louise
Mary
Philip
Robert
Ronald
Thomas
William
NOTE: There were 19 observations read from the data set SASHELP.CLASS.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

Assuming you're sure your code runs without errors, you can try adding:

options nonotes;

to just before your data _null_ step

and then add

options notes;

to just after your data _null_ step

You might be able to just use options nosource / options source instead; I'm not sure which one will suppress the PUT info being copied to the log.

Re: put statement when writing out to csv

Astounding — Fri, 10 Jan 2020 14:24:09 GMT

The usual way to write values to a file instead of the log is to redirect them yourself using the FILE statement:

data _null_;
set sashelp.class;

file "path to the file where you want the PUT messages written";
put name;
run;

Re: put statement when writing out to csv

kimdukes77 — Fri, 10 Jan 2020 14:24:57 GMT

Thank you for the response. I probably (definitely) should have mentioned in my original post that I have tried nonotes, nosource and nosource2 and none of those options work. Values are still written out to the log. I suspect I will need to write out log to a txt file (not the preferred option) or update the code to use proc report or print instead of _null_ and put.

Re: put statement when writing out to csv

kimdukes77 — Fri, 10 Jan 2020 14:31:18 GMT

Amazing thank you! A simple and elegant solution to what I foolishly assumed was a complex problem!

Re: put statement when writing out to csv

Kurt_Bremser — Fri, 10 Jan 2020 14:32:00 GMT

If you don't want data in the log, remove (or comment) the put statement. Right now, the put statement explicitly forces SAS to write to the log.