topic Re: No Output Table being Generated in SAS Programming

No Output Table being Generated

joebacon — Wed, 24 Oct 2018 17:07:24 GMT

Hi all,

This is a very basic question but I cannot understand why no output table is being generated as of late.

A simple code to test this was used:

proc sort data=pg1.storm_summary out=Storm_sort;
where basin = 'na' or basin='NA';
by MaxWindMPH ;
run;

However, in neither my output nor my results viewer am I getting an output table which is problematic because I don't want to change my base data set for the project I am working on.

Thanks in advance

Re: No Output Table being Generated

novinosrin — Wed, 24 Oct 2018 17:11:12 GMT

Try this and let us know


proc sort data=pg1.storm_summary out=Storm_sort;
where upcase(strip(basin)) = 'NA';
by MaxWindMPH ;
run;

proc print data=Storm_sort(obs=100);
run;

Re: No Output Table being Generated

Reeza — Wed, 24 Oct 2018 17:17:32 GMT

Post the log. Is there any message about no open destination?

Re: No Output Table being Generated

SuryaKiran — Wed, 24 Oct 2018 17:17:38 GMT

What does your log say?

Re: No Output Table being Generated

joebacon — Wed, 24 Oct 2018 17:19:54 GMT

This definitely works when I proc print, but the output tables used to generate off of PROC SORT.

Is this a setting that changed that i was unaware?

Re: No Output Table being Generated

joebacon — Wed, 24 Oct 2018 17:20:58 GMT

108 proc sort data=pg1.storm_summary out=Storm_sort;
109 where basin = 'na' or basin='NA';
110 by MaxWindMPH ;
111 run;

NOTE: There were 488 observations read from the data set PG1.STORM_SUMMARY.
WHERE basin in ('NA', 'na');
NOTE: The data set WORK.STORM_SORT has 488 observations and 12 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.02 seconds
cpu time 0.01 seconds

---------

The table is being created but not showing without prompting it with proc print. I should've specified before, but is there a way to change this?

Re: No Output Table being Generated

SuryaKiran — Wed, 24 Oct 2018 17:25:55 GMT

If your using SAS EG then check if you have '0' mentioned as shown in below screenshot (Tools>Options>Results). Add a number there instead of 0

Re: No Output Table being Generated

joebacon — Wed, 24 Oct 2018 17:32:58 GMT

I was running SAS 9.4 (base sas) but I think I am just going to switch over.

Thank you for the help!

Re: No Output Table being Generated

Reeza — Wed, 24 Oct 2018 17:39:38 GMT

AFAIK by default PROC SORT doesn't actually print any output as far as I know. The data set is sorted but there should not be any output regardless of what version you're using.

Re: No Output Table being Generated

SuryaKiran — Wed, 24 Oct 2018 17:45:38 GMT

@Reeza I don't this this is true when OUT= option is mention in PROC SORT. Correct me if I'm wrong.

Re: No Output Table being Generated

Reeza — Wed, 24 Oct 2018 17:56:08 GMT

@SuryaKiran wrote:

@Reeza I don't this this is true when OUT= option is mention in PROC SORT. Correct me if I'm wrong.

It still does not print any output with OUT= option. The OUT= in this case directs the sorted data set to a new data set, not the same name.

It's possible this behaved differently in SAS EG or Studio, but I suspect not, unless it was built into a task, but then I'd bet the code still shows a PROC PRINT after as well.

Re: No Output Table being Generated

SuryaKiran — Wed, 24 Oct 2018 18:03:26 GMT

Make sense, thanks for the explanation.