Insert Into when field does not exist in table inserting into

Accepted Solution Solved
Reply
Contributor
Posts: 31
Accepted Solution

Insert Into when field does not exist in table inserting into

I have a unique situation, I have 2 tables, one is getting created dynamically and the other is the table I want to insert my data into. My problem is the dynamic table one time might only I have 10 fields and the next time it could have 20 fields. I want to be able to just add the record with blank or nulls in the fields where I do not have in my dynamic table. Can this be done automatically?
INSERT INTO TableA
SELECT *
FROM TableB

My thoughts were I could just to a SELECT *, but then I get the error about missing fields.


Accepted Solutions
Solution
‎06-16-2015 08:49 AM
Super User
Super User
Posts: 6,500

Re: Insert Into when field does not exist in table inserting into

Why use INSERT?  Why not just use PROC APPEND.

proc append base=a data=b force;

run;

View solution in original post


All Replies
Solution
‎06-16-2015 08:49 AM
Super User
Super User
Posts: 6,500

Re: Insert Into when field does not exist in table inserting into

Why use INSERT?  Why not just use PROC APPEND.

proc append base=a data=b force;

run;

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 155 views
  • 0 likes
  • 2 in conversation