Help using Base SAS procedures

Proc Import:Data import issue

Reply
Contributor
Posts: 74

Proc Import:Data import issue

Hi,
I have a pipe( | ) delimitted file and when i tried to import using import wizard the length of the a field is getting changed.

for eg: in my pipe delimitted file ,i have the first field as cust id(length $ 100),but after the import ,the length of the field in sas dataset is cust id (length 20).
Any idea why is this happening?

Please help.

Thanks in advance.
Super Contributor
Super Contributor
Posts: 3,174

Re: Proc Import:Data import issue

Suggest you review your SAS-generated log output, and then inspect the incoming number of rows that may be influencing your CHARACTER variable type length attribute.

Scott Barry
SBBWorks, Inc.

Suggested Google advanced search argument, this topic / post:

import wizard character variable length site:sas.com
Contributor
Posts: 74

Re: Proc Import:Data import issue

Thanks SBB.
Ask a Question
Discussion stats
  • 2 replies
  • 128 views
  • 0 likes
  • 2 in conversation