topic Re: proc sql and the select into question in SAS Programming

proc sql and the select into question

robm — Thu, 15 Sep 2016 18:16:36 GMT

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;

Re: proc sql and the select into question

Reeza — Thu, 15 Sep 2016 18:24:26 GMT

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#n1ncn0pznd8wrln1tnp3xdxjz9xz.htm

Re: proc sql and the select into question

PGStats — Thu, 15 Sep 2016 19:17:09 GMT

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;