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.
Why use INSERT? Why not just use PROC APPEND.
proc append base=a data=b force;
run;
Why use INSERT? Why not just use PROC APPEND.
proc append base=a data=b force;
run;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: