truncating while importing how to handle

[kumarK]

I have a data set which has address column.

While importing it is truncating.how to handle this situations.

[Patrick]

Provide much more information to us - and if you're lucky then while collecting this information you might even understand by yourself what's happening and how to resolve it.

[ballardw]

Did you use proc import? If so what was the source file type?

You can search this forum for truncated and you'll find a number of related posts, especially if the data source is Excel.

[kumarK]

it's a csv file. i am importing through proc import. Yes i will search in this group. Thanks.

what are the differences(adv and dis adv) in Proc import and  infile. which one is best to use.

[RamKumar]

Again you can find numerous answers if you search in this forum like 'differences between infile and proc import' or simply 'proc import'

[Kurt_Bremser]

PROC IMPORT makes an educated guess about the file structure and then creates a suitable data step to read the data.

This means that a change in the file structure (or the data in the first n records inspected by proc import) will result in an automatic structural change in the dataset, which may cause problems farther down the line.

A manually written DATA step to read an external file will show unexpected data, either by causing a WARNING or ERROR condition, or at least by writing ERROR messages to the log. This will enable you to catch faulty data before it causes serious trouble.

[Chrishi]

use guessingrows=32767 for proc import and give a try.

[RW9]

Clue is in the title there, guessingrows.  If your ok with letting SAS guess your data then go ahead, I would recommend writing a specific import program yourself for the data you know.