https://communities.sas.com/t5/SAS-Programming/Truncation-of-character-variables-to-length-8-when-I-get-csv/m-p/922680#M363324 <P>Truncation of character variables to length 8 when I get csv file from website using proc http. When i set $12. to variable then it read some characters from the next column to. Thanks for help.</P><P>&nbsp;</P><P>My code:</P><P>&nbsp;</P><P>filename tempurl TEMP;</P><P>proc http<BR />url= "<A href="https://s3.amazonaws.com/talent-assets.datacamp.com/product_sales.csv" target="_blank">https://s3.amazonaws.com/talent-assets.datacamp.com/product_sales.csv</A>"<BR />method="get"<BR />out=tempurl ;<BR />run;</P><P>/* Import the data from the URL into a SAS dataset */<BR />data work.sales;<BR />infile tempurl dlm =',' dsd firstobs=2 truncover ; /* Set delimiter and skip header row */<BR />input week $ sales_method $ customer_id $ nd_sold revenue<BR />years_as_customer nb_site_visits state $ ;<BR />run;</P> Wed, 03 Apr 2024 08:12:28 GMT nnthieu 2024-04-03T08:12:28Z https://communities.sas.com/t5/SAS-Programming/Truncation-of-character-variables-to-length-8-when-I-get-csv/m-p/922680#M363324 <P>Truncation of character variables to length 8 when I get csv file from website using proc http. When i set $12. to variable then it read some characters from the next column to. Thanks for help.</P><P>&nbsp;</P><P>My code:</P><P>&nbsp;</P><P>filename tempurl TEMP;</P><P>proc http<BR />url= "<A href="https://s3.amazonaws.com/talent-assets.datacamp.com/product_sales.csv" target="_blank">https://s3.amazonaws.com/talent-assets.datacamp.com/product_sales.csv</A>"<BR />method="get"<BR />out=tempurl ;<BR />run;</P><P>/* Import the data from the URL into a SAS dataset */<BR />data work.sales;<BR />infile tempurl dlm =',' dsd firstobs=2 truncover ; /* Set delimiter and skip header row */<BR />input week $ sales_method $ customer_id $ nd_sold revenue<BR />years_as_customer nb_site_visits state $ ;<BR />run;</P> Wed, 03 Apr 2024 08:12:28 GMT https://communities.sas.com/t5/SAS-Programming/Truncation-of-character-variables-to-length-8-when-I-get-csv/m-p/922680#M363324 nnthieu 2024-04-03T08:12:28Z https://communities.sas.com/t5/SAS-Programming/Truncation-of-character-variables-to-length-8-when-I-get-csv/m-p/922681#M363325 <P>My code:&nbsp;</P><P>filename tempurl TEMP;</P><P>proc http<BR />url= "<A href="https://s3.amazonaws.com/talent-assets.datacamp.com/product_sales.csv" target="_blank">https://s3.amazonaws.com/talent-assets.datacamp.com/product_sales.csv</A>"<BR />method="get"<BR />out=tempurl ;<BR />run;</P><P>/* Import the data from the URL into a SAS dataset */<BR />data work.sales;<BR />infile tempurl dlm =',' dsd firstobs=2 truncover ; /* Set delimiter and skip header row */<BR />input week $ sales_method $ customer_id $ nd_sold revenue<BR />years_as_customer nb_site_visits state $ ;<BR />run;</P> Wed, 03 Apr 2024 08:07:51 GMT https://communities.sas.com/t5/SAS-Programming/Truncation-of-character-variables-to-length-8-when-I-get-csv/m-p/922681#M363325 nnthieu 2024-04-03T08:07:51Z