topic Re: proc import but varible values truncated in SAS Programming

proc import but varible values truncated

rajeshm — Sun, 21 Sep 2014 14:34:13 GMT

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)

Re: proc import but varible values truncated

mohamed_zaki — Sun, 21 Sep 2014 15:01:40 GMT

Check this old thread

SAS Truncating on PROC Import

which suggest to use GUESSINGROWS Statement

Re: proc import but varible values truncated

rajeshm — Sun, 21 Sep 2014 17:23:58 GMT

hi,

thanks a lot.

Re: proc import but varible values truncated

RW9 — Mon, 22 Sep 2014 08:59:06 GMT

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