SAS input tables character columns format

bsully 0
Viewed 22

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.

sas
1 Answers
data billings ;
  length PROCUDURE $100. ; /* adjust $100 to reflect the longest across all datasets */
  set BILLINGS_: ;
run ;
userpks0
Related