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
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
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;
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
I was running SAS 9.4 (base sas) but I think I am just going to switch over.
Thank you for the help!
@Reeza I don't this this is true when OUT= option is mention in PROC SORT. Correct me if I'm wrong.
@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.
Make sense, thanks for the explanation.
What does your log say?
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.