topic Re: Select * from PROC SQL? in SAS Procedures

Select * from PROC SQL?

ybz12003 — Thu, 09 Feb 2017 16:02:45 GMT

Hello:

I have a syntax error code show below. I would like to select all of the previous variables from the old table 1 to create a new one table 2, with condition TH=1. I don't know why it didn't work?

504 proc sql;
505 create table two
506 select *
------
73
ERROR 73-322: Expecting an AS.

507 from work.one
508 where TH=1
509 order by B;
510 quit;

Re: Select * from PROC SQL?

TheShark — Thu, 09 Feb 2017 16:05:40 GMT

Put "as" after your create table two.

504 proc sql;
505 create table two AS
506 select *
507 from work.one
508 where TH=1
509 order by B;
510 quit;

Re: Select * from PROC SQL?

ybz12003 — Thu, 09 Feb 2017 16:11:29 GMT

Thanks. it works