BookmarkSubscribeRSS Feed
Andre
Obsidian | Level 7
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
4 REPLIES 4
LinusH
Tourmaline | Level 20
Try the TEXTSIZE= options. It's default is 1024. Also, take a look at SCANTEXT=.

/Linus
Data never sleeps
LinusH
Tourmaline | Level 20
Try the TEXTSIZE= options. It's default is 1024. Also, take a look at SCANTEXT=.

/Linus
Data never sleeps
Andre
Obsidian | Level 7
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
Obsidian | Level 7
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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 885 views
  • 0 likes
  • 2 in conversation