proc import, how to fix variable length

Reply
N/A
Posts: 0

proc import, how to fix variable length

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.
SAS Super FREQ
Posts: 8,645

Re: proc import, how to fix variable length

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
N/A
Posts: 0

Re: proc import, how to fix variable length

Thank you very much Cynthia, that worked for me. I really appreciate ur reply.
Occasional Learner
Posts: 1

Re: proc import, how to fix variable length

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

Esteemed Advisor
Posts: 5,085

Re: proc import, how to fix variable length

Or, try the search that Cynthia sugested. There is lot halo provided on support.sas.com.
Data never sleeps
Post a Question
Discussion Stats
  • 4 replies
  • 14225 views
  • 0 likes
  • 4 in conversation