topic Re: DLM and guessrow in proc import in SAS Procedures

DLM and guessrow in proc import

Andre — Wed, 19 Nov 2008 16:30:53 GMT

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

Re: DLM and guessrow in proc import

LinusH — Thu, 20 Nov 2008 07:27:48 GMT

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

/Linus

Re: DLM and guessrow in proc import

LinusH — Thu, 20 Nov 2008 07:28:12 GMT

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

/Linus

Re: DLM and guessrow in proc import

Andre — Thu, 20 Nov 2008 11:58:25 GMT

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

Re: DLM and guessrow in proc import

Andre — Fri, 21 Nov 2008 11:03:45 GMT

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