How do I update an In-Memory LASR Table with an extra column

[nayyalas]

I am implementing a LASR Table Swap out using this document as a guide: https://communities.sas.com/t5/tkb/articleprintpage/tkb-id/library/article-id/2371

I am successfully able to do the swap. However, when I need to add a column to the table being swapped, it updates the metadata but not the In-Memory table with the new column. As a result the swap is not successful because the original table still doesn't have the new column.

I am using IMSTAT for my swap. I don't see any option to add column. The Update statement I believe is for the rows.

Please advice.

PROC IMSTAT DATA = LASRLIB.&Original_Table;
   		WHERE 1=1;
	RUN;
   	DELETEROWS / PURGE;
	RUN;
   		TABLE LASRLIB.&Original_Table;
   		SET &table_name;
	RUN;

[SASKiwi · Accepted solution]

As I understand it, IMSTAT can add or delete rows, but not add columns from another source table, although you can create computed columns. To add columns I would delete the LASR table entirely then use a DATA step to do a complete table load.

[nayyalas]

Thank you very much, That is the approach I took.