https://communities.sas.com/t5/New-SAS-User/How-to-define-the-length-of-a-character-variable-in-loadTable/m-p/608621#M17715 <P>Thank you so much!</P> <P>I learned from the documentation that besides 'informat', I can also use 'length' to solve my problem.</P> Mon, 02 Dec 2019 06:16:45 GMT Meilan 2019-12-02T06:16:45Z https://communities.sas.com/t5/New-SAS-User/How-to-define-the-length-of-a-character-variable-in-loadTable/m-p/608188#M17644 <P>I am using loadTable action to import data from a .csv file. I have many character variables and I want to define a fixed length for them.</P><P>Is there a way to define the length of the character variables (equivalent to 'RawLength' of the output) in loadTable?&nbsp;</P><P>&nbsp;</P><P>Thank you!</P><P>&nbsp;</P> Fri, 29 Nov 2019 08:39:19 GMT https://communities.sas.com/t5/New-SAS-User/How-to-define-the-length-of-a-character-variable-in-loadTable/m-p/608188#M17644 Meilan 2019-11-29T08:39:19Z https://communities.sas.com/t5/New-SAS-User/How-to-define-the-length-of-a-character-variable-in-loadTable/m-p/608257#M17654 Starting with Viya 3.4 you can use informat in the loadTable action. There is an example in the documentation: <A href="https://documentation.sas.com/?cdcId=pgmsascdc&amp;cdcVersion=9.4_3.5&amp;docsetId=caspg&amp;docsetTarget=p15gor7onpx55ln1v7engu655oi9.htm&amp;locale=en" target="_blank">https://documentation.sas.com/?cdcId=pgmsascdc&amp;cdcVersion=9.4_3.5&amp;docsetId=caspg&amp;docsetTarget=p15gor7onpx55ln1v7engu655oi9.htm&amp;locale=en</A> Fri, 29 Nov 2019 14:48:06 GMT https://communities.sas.com/t5/New-SAS-User/How-to-define-the-length-of-a-character-variable-in-loadTable/m-p/608257#M17654 JosvanderVelden 2019-11-29T14:48:06Z https://communities.sas.com/t5/New-SAS-User/How-to-define-the-length-of-a-character-variable-in-loadTable/m-p/608621#M17715 <P>Thank you so much!</P> <P>I learned from the documentation that besides 'informat', I can also use 'length' to solve my problem.</P> Mon, 02 Dec 2019 06:16:45 GMT https://communities.sas.com/t5/New-SAS-User/How-to-define-the-length-of-a-character-variable-in-loadTable/m-p/608621#M17715 Meilan 2019-12-02T06:16:45Z