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

[tianerhu]

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 ?

[ballardw · Accepted solution]

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.

[Kurt_Bremser]

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

[tianerhu]

Thanks a lot.

[tianerhu]

Thanks.

[tarheel13]

are you talking about proc sql? 

[tianerhu]

yes, proc sql .

[SASKiwi]

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;

[tianerhu]

Thank you .