topic Re: insert into in SAS Programming

insert into

runrunbunny — Thu, 08 Oct 2020 03:37:50 GMT

Hi everyone.

I'd like to insert columns from table A into a new table called ''new", but got errors: File work.new.date does not exist.

Could you please give me some suggestions?

Thanks in advance!

PROC SQL;

INSERT INTO new

SELECT variable1, variable2, variable3

FROM A;

QUIT;

Re: insert into

Tom — Thu, 08 Oct 2020 03:46:31 GMT

Sounds like you don't have a dataset named NEW yet. So instead of trying to append observations to an existing dataset you want to make a new dataset. In SQL you would use CREATE TABLE for that.

create table new as 
  select variable1, variable2, variable3
  from a
;

Or in regular SAS code a simple data step.

data new;
  set a;
  keep variable1-variable3;
run;

Re: insert into

ballardw — Thu, 08 Oct 2020 03:48:57 GMT

@runrunbunny wrote:

Hi everyone.

I'd like to insert columns from table A into a new table called ''new", but got errors: File work.new.date does not exist.

Could you please give me some suggestions?

Thanks in advance!

PROC SQL;

INSERT INTO new

SELECT variable1, variable2, variable3

FROM A;

QUIT;

Try

PROC SQL;
   Create table new as
   SELECT variable1, variable2, variable3
   FROM A;
QUIT;

The insert as you attempted requires the data set to exist, Create table creates the new set

Re: insert into

Reeza — Thu, 08 Oct 2020 03:53:32 GMT

INSERT adds new rows usually, not new columns.

Re: insert into

runrunbunny — Thu, 08 Oct 2020 03:56:29 GMT

Thanks a lot!

Re: insert into

runrunbunny — Thu, 08 Oct 2020 03:57:05 GMT

Thank you for your answer!