Select * from PROC SQL?

[ybz12003]

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;

[TheShark · Accepted solution]

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;

[ybz12003]

Thanks. it works