topic Re: how to create SAS file after proc sql? in SAS Programming

how to create SAS file after proc sql?

ybz12003 — Thu, 01 Jun 2017 01:48:02 GMT

Hello:

How to generate a SAS file after proc sql? Thanks.

proc sql;
select score from test1
intersect all
select score from test2;
quit;

Re: how to create SAS file after proc sql?

mkeintz — Thu, 01 Jun 2017 02:00:26 GMT

Precede the SELECT clause with a CREATE TABLE clause:

proc sql;

create table mytable as

select score from test1

intersect all

select score from test2;

quit;

Re: how to create SAS file after proc sql?

Reeza — Thu, 01 Jun 2017 03:29:42 GMT

The documentation is pretty good for SQL - see the section titled 'Creating Tables'

https://support.sas.com/documentation/cdl/en/sqlproc/69822/HTML/default/viewer.htm#titlepage.htm

Re: how to create SAS file after proc sql?

ybz12003 — Thu, 01 Jun 2017 12:10:54 GMT

My SAS version is 9.3, not 9.4

Re: how to create SAS file after proc sql?

ballardw — Thu, 01 Jun 2017 19:52:31 GMT

@ybz12003 wrote:

My SAS version is 9.3, not 9.4

It won't hurt to look at basics of SQL documentation. The basic elements such as Create Table , Select, From, Group By and where clauses haven't changed drastically since SAS 6.8. There may be as few additional features here and there but just as the data step, except for adding new functions, changes slowly so does the base SQL definition.

And if you hunt around you will find the version 9.3 documentation on the SAS support website as well.

I would also ask why the online help was not installed with your installation. Does the F1 key bring up anything for SAS?

Re: how to create SAS file after proc sql?

Reeza — Thu, 01 Jun 2017 22:06:10 GMT

@ybz12003 wrote:

My SAS version is 9.3, not 9.4

It really doesn't matter for this topic, the major difference is with FEDSQL and MEDIAN function, neither of which you appear to be using. And you can find the same section in the 9.3 documentation, if you choose to look.