topic Re: guessingrows=32767 in proc import! in SAS Enterprise Guide

guessingrows=32767 in proc import!

Dil — Sat, 24 Jan 2015 04:46:37 GMT

Hi all,

I previously had a problem when I used proc import to import a csv file into SAS EG (two of the numeric variables were detected for errors for some rows). But when I imported the csv file manually, it was fine. I was suggested by Xia Keshan that I could use guessingrows=32767 statement. When I tried the proc import with this statement, I didn't have any errors like before. However, just noticed that now all the numeric variables including sas date variables all became character variables. Any suggesion on resolving this issue? Thanks.

Re: guessingrows=32767 in proc import!

Ksharp — Sat, 24 Jan 2015 07:57:50 GMT

"just noticed that now all the numeric variables including sas date variables all became character variables"

That is beacuse these numeric variabls and date variables contains some characters like TAB ......

You need to change them on your own, and no doubt you get some error in log, and use ?? or compress() to avoid the error info.

Xia Keshan

Re: guessingrows=32767 in proc import!

Dil — Sun, 25 Jan 2015 19:53:27 GMT

Thanks Xia keshan. Yes, you are right. Now I imported them on my own.

Just out of curiosity. Did you mean those variables might have ..... or actual word TAB? I guess .... right? I do see that those two variables have decimal points.

Re: guessingrows=32767 in proc import!

jakarman — Sun, 25 Jan 2015 20:22:21 GMT

You can read csv files excellent using a datastep. No need to go for guessing as you are knowing your data.

Re: guessingrows=32767 in proc import!

Ksharp — Mon, 26 Jan 2015 06:37:28 GMT

I don't know. But they do have some characters I believe.

If you use input() to convert them into numeric variable, You are going to get ERROR message in log window , I think.

Xia Keshan

Re: guessingrows=32767 in proc import!

GurmeetKaur_23 — Thu, 01 Dec 2016 17:03:41 GMT

Hi There,

Can you give some small example on how can we read .csv files using datalines and without guessing rows and proc import?

It will be of great help.