topic Re: The CREATE TABLE statement generates a table only as output, not as a report in SAS Programming

The CREATE TABLE statement generates a table only as output, not as a report

tianerhu — Wed, 20 Apr 2022 19:03:29 GMT

I have two question:

1, what is the difference between output and report ?

2, how do I check the result when I create a table ?

Re: The CREATE TABLE statement generates a table only as output, not as a report

ballardw — Wed, 20 Apr 2022 19:16:23 GMT

Typically a Report is read by people. Data sets (I assume that is what you mean by output) are used as input to other program elements such as analysis or another report.

How to check: depends on what you are checking. If specific calculations provide example data and see if the result matches expectations; if presence/absence of specific values the variety of tools: proc freq to display counts of values, subsetting the data set with where or if statements to see if any records meet/ fail to meet requirement of values.

Re: The CREATE TABLE statement generates a table only as output, not as a report

Kurt_Bremser — Wed, 20 Apr 2022 19:41:48 GMT

To not forget the most simple method of checking a result dataset: open it in a viewtable window and look at it.

Re: The CREATE TABLE statement generates a table only as output, not as a report

tarheel13 — Wed, 20 Apr 2022 20:30:31 GMT

are you talking about proc sql?

Re: The CREATE TABLE statement generates a table only as output, not as a report

tianerhu — Wed, 20 Apr 2022 22:05:25 GMT

yes, proc sql .

Re: The CREATE TABLE statement generates a table only as output, not as a report

SASKiwi — Wed, 20 Apr 2022 22:57:25 GMT

If you want to create a report from PROC SQL just remove the CREATE TABLE part of your query:

proc sql; * Table ;
  create table want as 
  select *
  from have;
quit;

proc sql; * Report ;
  select *
  from have;
quit;

Re: The CREATE TABLE statement generates a table only as output, not as a report

tianerhu — Thu, 21 Apr 2022 00:14:14 GMT

Thank you .

Re: The CREATE TABLE statement generates a table only as output, not as a report

tianerhu — Thu, 21 Apr 2022 00:14:45 GMT

Thanks a lot.

Re: The CREATE TABLE statement generates a table only as output, not as a report

tianerhu — Thu, 21 Apr 2022 00:16:16 GMT

Thanks.