proc sql and the select into question

[robm]

I have this proc sql below ...can you not use the select into statement? the error I get is below that

proc sql;
select memname as sas,name as vgroups into uompc.SAStoVGroups from work.vgroups
quit;

3042 proc sql;
3043 select memname as sas,name as vgroups into uompc.SAStoVGroups from work.vgroups
-----
79
76
ERROR 79-322: Expecting a :.

ERROR 76-322: Syntax error, statement will be ignored.

3044 quit;

[Reeza]

No, that's not SAS SQL.

In SAS you use a CREATE TABLE statement instead.

proc sql;
create table uompc.SAStoVGroups as
select ..
from
...

Probably easiest to scan through the examples:

http://support.sas.com/documentation/cdl/en/sqlproc/69049/HTML/default/viewer.htm#n1ncn0pznd8wrln1tn...

[PGStats · Accepted solution]

Use the documented syntax. SELECT INTO is for giving values to SAS macro variables.INSERT INTO is for adding observations to an existing table. To create a table, use CREATE TABLE:

proc sql;
create table uompc.SAStoVGroups as
select 
	memname as sas,
	name as vgroups 
from work.vgroups;
quit;