DLM and guessrow in proc import

[Andre]

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

[LinusH]

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

/Linus

[LinusH]

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

/Linus

[Andre]

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

[Andre]

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