topic Re: proc import, how to fix variable length in SAS Health and Life Sciences

proc import, how to fix variable length

deleted_user — Thu, 28 Aug 2008 14:29:10 GMT

Hi,
I am trying to import a CSV file using proc import. I have 2 variables in the CSV, one is numeric and other one is character which has values of lengths from 6-30 characters. I am able to create a sas dataset successfully, but the character variable's values are getting truncated. Does any one know how to fix this/how to change the variable length in proc import so that the values in the external file wont get truncated after importing it. I appreciate your input.

Thanks,
Pallavi.

Re: proc import, how to fix variable length

Cynthia_sas — Thu, 28 Aug 2008 16:06:17 GMT

Hi:
A search on support.sas.com with the string
IMPORT truncated

reveals this note
http://support.sas.com/kb/17/778.html

which may be relevant to your issue. If you have tried the techniques in this note, without success, your next stop should be to open a track with SAS Tech Support.

cynthia

Re: proc import, how to fix variable length

deleted_user — Thu, 28 Aug 2008 17:55:47 GMT

Thank you very much Cynthia, that worked for me. I really appreciate ur reply.

Re: proc import, how to fix variable length

krishcode — Tue, 02 Feb 2016 03:43:31 GMT

this page has been disabled,can you please suggeset some other link .

Re: proc import, how to fix variable length

LinusH — Tue, 02 Feb 2016 18:37:24 GMT

Or, try the search that Cynthia sugested. There is lot halo provided on support.sas.com.