column width set incorrectly when reading in text files

Posted by mpirritano on Dec 06, 2011; 7:31pm
URL: http://spssx-discussion.165.s1.nabble.com/column-width-set-incorrectly-when-reading-in-text-files-tp5053244.html

All,

 

When reading in some kind of a text file, in this case a csv file, SPSS appears to set column widths based on rows located towards the top of the file. I do not always know the correct number of columns to alot for a field. As a result I often discover upon subsequent analyses that fields have been truncated. Is there some way to ensure that this doesn’t happen, other than knowing the max column width for all fields in every file I load? I’m working with 17.0.3.

 

Thanks

Matt

 

Matthew Pirritano, Ph.D.

Research Analyst IV

Medical Services Initiative (MSI)

Orange County Health Care Agency

[phone]