proc import but varible values truncated

[rajeshm]

Hi,

I was importing an csv file  all the rows(29k rows) are importing  .

I have 2 columns product and sub-product as shown below

Product	Sub-product
Bank account or service	Conventional adjustable mortgage (ARM)

but my dataset is creating

Product	Sub-product
Bank account or ser	Conventional adjustable mortgage (ARM)

[mohamed_zaki · Accepted solution]

Check this old thread

SAS Truncating on PROC Import

which suggest to use GUESSINGROWS Statement

[rajeshm]

hi,

thanks a lot.

[RW9]

I wouldn't recommend the use of proc import if your data is CSV.  Write a datastep with an infile statement, you then have full control of what, how long, where from etc. is imported.  There are many posts about importing CSV files using differing methods, here is one: https://communities.sas.com/thread/60923