I have a data set which has address column.
While importing it is truncating.how to handle this situations.
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.
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.
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.
Again you can find numerous answers if you search in this forum like 'differences between infile and proc import' or simply 'proc import'
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.
use guessingrows=32767 for proc import and give a try.
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.