Using GUESSINGROWS=1 in SAS Studio (SAS University Edition)

[_maldini_]

@ballardw Thanks for sharing your approach here. I think I'm going to adopt this approach going forward.

Quick question: Do you know how may observations SAS reads during a PROC IMPORT before it makes its determination about the attributes of a particular variable?  I'm thinking specifically about the length of character variables, but I'm interested in the answer for informats and formats also. Thanks!

[Reeza]

That's what GuessingRows specifies - the default value is 20 in SAS 9.3 according to the documentation. 

Do you have a specification file? If you have one another trick is to use Excel to create the statements. 

[_maldini_]

@Reeza 

<That's what GuessingRows specifies>

I understand. I was referring to a PROC IMPORT w/o using the GUESSINGROWS statement.

<the default value is 20>

Meaning the first 20 observations (assuming no GUESSINGROWS statement)?

[Reeza]

---

@_maldini_ wrote:

@Reeza 

<That's what GuessingRows specifies>

I understand. I was referring to a PROC IMPORT w/o using the GUESSINGROWS statement.

<the default value is 20>

Meaning the first 20 observations (assuming no GUESSINGROWS statement)?

---

Yes, you should probably verify that's true in your version of SAS in the documentation though. Things change between versions.