Search code examples
sas

SAS input tables character columns format

I have a set of tables in a SAS library that I have to compile but the width of some columns aren't the same. The tables have similar pattern names like "BILLINGS_YYMM".

DATA BILLINGS;
    SET BILLINGS_:;
RUN;

I have the following message in the log :

WARNING: Several lengths have been specified for the variable PROCEDURE by the input SAS table(s). Risk of truncation of the data.

Is there a way to solve that without going through all the tables.

Solution 
  • data billings ;
  length PROCUDURE $100. ; /* adjust $100 to reflect the longest across all datasets */
  set BILLINGS_: ;
run ;