Thanks for your response. I think in our Big Query environment, there is DefaultStringLength = 2000 defined somewhere. This caused all string type field created with default length of 2000. I looked at this SAS doc https://documentation.sas.com/doc/en/pgmsascdc/v_044/ds2ref/n08ihhj1d03nlnn13zv4tnp69t8l.htm and add SCANSTRINGCOLUMNS=yes in my libname definition, the actual length of the string is populated which resolved my problem. Thanks. Shan
... View more