Help using Base SAS procedures

DLM and guessrow in proc import

Reply
Super Contributor
Posts: 273

DLM and guessrow in proc import

Hi,
Does anybody (from SAS) know if there is a possibility to change the implicit maximum length for a character variable in the process
File/import /delimited file on a csv file (with the european delimitor ; in place of , in localized Excel)

The model of lines is of this kind
"s","o","m","thing very very long more than 500","","12.5"

After having indicated the number of lines for the guessingrows,the program show that for long character variable sas has a limit of $500. for the generated informat and formats.

Is there a system options that whithdraw this limit and accept length as 2000 (not 32000)?

TIA

Andre
Super User
Posts: 5,260

Re: DLM and guessrow in proc import

Try the TEXTSIZE= options. It's default is 1024. Also, take a look at SCANTEXT=.

/Linus
Data never sleeps
Super User
Posts: 5,260

Re: DLM and guessrow in proc import

Try the TEXTSIZE= options. It's default is 1024. Also, take a look at SCANTEXT=.

/Linus
Data never sleeps
Super Contributor
Posts: 273

Re: DLM and guessrow in proc import

textsize= and scantext= are only of use with dbms=Excel...
and not in case of dbms=dlm or csv

and there are more than 500 variable and 32000 lines

I shall try the Access way and report if it is not working correct
due to a field length limit

Andre
Super Contributor
Posts: 273

Re: DLM and guessrow in proc import

The Access way is not working with this kind of raw information

The sas solution is to complete or rewrite the generated code.
A length was added.

But Stattransfer (which was working extra) furnish us the maximum
length of those fields (coming from uncontroled screen web inquiry input).

Andre
Ask a Question
Discussion stats
  • 4 replies
  • 195 views
  • 0 likes
  • 2 in conversation