insert into

[runrunbunny]

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;

[Tom]

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;

[runrunbunny]

Thank you for your answer!

[ballardw · Accepted solution]

---

@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

[runrunbunny]

Thanks a lot!

[Reeza]

INSERT adds new rows usually, not new columns.