topic Re: truncating while importing how to handle in SAS Programming

truncating while importing how to handle

kumarK — Sun, 14 Dec 2014 11:21:53 GMT

I have a data set which has address column.

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

Re: truncating while importing how to handle

Patrick — Sun, 14 Dec 2014 13:03:41 GMT

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.

Re: truncating while importing how to handle

ballardw — Mon, 15 Dec 2014 20:00:29 GMT

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.

Re: truncating while importing how to handle

kumarK — Tue, 16 Dec 2014 06:32:41 GMT

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.

Re: truncating while importing how to handle

RamKumar — Tue, 16 Dec 2014 08:02:35 GMT

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

Re: truncating while importing how to handle

Kurt_Bremser — Tue, 16 Dec 2014 08:14:19 GMT

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.

Re: truncating while importing how to handle

Chrishi — Tue, 16 Dec 2014 10:26:06 GMT

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

Re: truncating while importing how to handle

RW9 — Tue, 16 Dec 2014 10:41:49 GMT

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.