DATA Step, Macro, Functions and more

proc import but varible values truncated

Accepted Solution Solved
Reply
Contributor
Posts: 44
Accepted Solution

proc import but varible values truncated

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

ProductSub-product
Bank account or serviceConventional adjustable mortgage (ARM)

but my dataset is creating

ProductSub-product
Bank account or serConventional adjustable mortgage (ARM)

Accepted Solutions
Solution
‎09-21-2014 11:01 AM
Super Contributor
Posts: 490

Re: proc import but varible values truncated


All Replies
Solution
‎09-21-2014 11:01 AM
Super Contributor
Posts: 490

Re: proc import but varible values truncated

Check this old thread

SAS Truncating on PROC Import

which suggest to use GUESSINGROWS Statement

Contributor
Posts: 44

Re: proc import but varible values truncated

Posted in reply to mohamed_zaki

hi,

thanks a lot.

Super User
Super User
Posts: 7,942

Re: proc import but varible values truncated

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

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 689 views
  • 1 like
  • 3 in conversation