Change table's formats

InêsMaximiano — Fri, 30 Sep 2022 14:44:36 GMT

I have multiple jobs in Data Integration Studio leading to the formation of a final table (Table_A). I was asked to changed the format of one particular column in this table, and since I was not able to run the jobs in order to update it, I decided to update the metadata.

For that I started by updating the format in SAS Guide:

PROC SQL;
ALTER TABLE lib1.Table_A
MODIFY column_1 format=20. ;
quit;

Then I went to SAS DIS and updated the metadata on that particular table.

The final result was that I was able to change de format of the desired table both in SAS Guide and SAS DIS.

However, when the multiple jobs that create that table run automatically by the batch the format reverses back to the old format.

How can I fix this? Can I change the format of one column without changing the job in permanent way?

Re: Change table's formats

ballardw — Fri, 30 Sep 2022 16:12:18 GMT

Without any details of the entire process my guess would involve the table getting combined with another and the result using the format of the other table.

If that is the case then you look at the steps where that table is combined and may have to deal with modifications in the combined sets.

Or possibly a specified format for a report overwriting the default.

topic Change table's formats in SAS Enterprise Guide

Change table's formats

Re: Change table's formats