topic Re: How can I avoid printing result tables in data step or proc SQL in SAS Enterprise Guide

How can I avoid showing result tables from data step or proc SQL in the Process Flow

imanojkumar1 — Fri, 11 Nov 2016 10:36:20 GMT

When I run the following code...

Data Have01;
  Input MyVar $ Date Date9.;
  Format Date Date9.;
  Datalines;
z101    04JAN16
z102    08JAN16
z103    12JAN16
;
Run;

Data Dates01 (Keep=Date);
  Format Date Date9.;
  Do i=0 To 365;
    Date=IntNX('day','01JAN2016'd,i);
	Output;
  End;
Run;

Proc SQL;
  Create Table Var As Select Distinct MyVar From Have01 Order By MyVar;
Quit;

Proc SQL;
  Create Table Want01 As Select * From Var, Dates;
Quit;

I get the following results...

Is there any method that the result on workspace should be only HAVE01 and all other tables should not appear? I just want end result table to be there and not other three. Something like this..

Thanks.

Re: How can I avoid printing result tables in data step or proc SQL

Kurt_Bremser — Fri, 11 Nov 2016 10:35:34 GMT

Use proc delete to remove datasets that are no longer needed. EG usually detects this from the log.

Re: How can I avoid printing result tables in data step or proc SQL

RW9 — Fri, 11 Nov 2016 10:42:45 GMT

Well, I don't know EG that well, but I suppose after your code you could add:

proc datasets lib=work;
  delete dates01 var;
quit;
run;

However that being said, looking at your code I don't see the reasoning in all those datasets simply:

data have;
  input myvar $ date date9.;
  format date date9.;
  datalines;
z101    04JAN16
z102    08JAN16
z103    12JAN16
;
run;

data want;
  set have;
  format mydate date9.;
  do mydate="01JAN2016"d to "31DEC2016"d;
    output;
  end;
run;

Achieves the same result? What is the point of the variable "date" in the have? Also, not a good idea to call things VAR and DATE as these are keywords, use something descriptive of your data.

Re: How can I avoid printing result tables in data step or proc SQL

imanojkumar1 — Fri, 11 Nov 2016 11:12:52 GMT

Ohh I got it... first I tried..

proc datasets lib=work;
delete HAVE01 DATE01 VAR;
quit;

Then I tried... and It worked.....

Proc Delete Data = work.Date01 work.Have01 work.VAR; *This will delete these datasets in work;
run;

Thanks for helping.

Re: How can I avoid printing result tables in data step or proc SQL

Kurt_Bremser — Fri, 11 Nov 2016 11:10:53 GMT

Just do

proc delete data=
  have01
  date01
  var
;
run;

The syntax is described here: DELETE Procedure