topic Re: No log listing from Proc Import in SAS Procedures

No log listing from Proc Import

DJENS — Wed, 25 Mar 2009 21:52:39 GMT

Can someone help me with this one....tearing my hair out.

I am trying to see the code that Proc Import uses to import my Excel spreadsheet. But the code is not being displayed in the log window and I think it is supposed to be there. Did I somehow turn an option off or something?

Any help would be appreciated.

Dave

Re: No log listing from Proc Import

andreas_lds — Fri, 27 Mar 2009 07:51:51 GMT

Stop tearing your hair out, the internal code of proc import has never been printed to the log.

Re: No log listing from Proc Import

venkatesh — Fri, 27 Mar 2009 11:47:32 GMT

If u cant identify then try this..

Tools->Options->log->general->reset

all default options will be reset(Don't know how much it will help)

Venky.....

Re: No log listing from Proc Import

deleted_user — Mon, 30 Mar 2009 12:53:53 GMT

I use proc import in my code but for csv file,

but internally it uses infile & input statements , and the same gets printed in log.

Re: No log listing from Proc Import

Flip — Mon, 30 Mar 2009 13:02:25 GMT

You are thinking of using the File| Import menu selection. That will give you the infile statements used.

I STAND CORRECTED, THEY WORK THE SAME.

Re: No log listing from Proc Import

deleted_user — Mon, 30 Mar 2009 13:54:45 GMT

Proc import for flat files (csv etc.) is supposed to produce a log entry with the datastep used. See the following absrtract for more useful info...

http://www2.sas.com/proceedings/sugi30/038-30.pdf

So I would suggest a proc import from Excel will produce nothing. Message was edited by: pznew

Re: No log listing from Proc Import

deleted_user — Mon, 30 Mar 2009 15:05:23 GMT

DJENS

in the import wizard there is a dialog box to name a file into which the wizard will send a copy of the proc import code.
Is that what you wanted?

PeterC

Re: No log listing from Proc Import

Sharkie — Fri, 26 Apr 2013 20:49:17 GMT

Common problem. I have lots of issues importing Excel spreadsheets with observations like #N/A, ot blanks in what should be numeric columns. Here's what you do:

Save a copy of the excel spreadsheet as a .CSV file;
Import that CSV file;
Unlike with Excel, import now prints a detailed log (why only for CSV files and not Excel is a total mystery to me) which you can edit, or modify the formats and informats;

Really obvious... NOT.

Re: No log listing from Proc Import

SAS_2_Python — Mon, 24 Aug 2015 11:25:05 GMT

I had the same problem when importing a .csv. Drove me crazy because I have done it a 1000 times in the past. Solution:

options source;

I had options nonsource.

Re: No log listing from Proc Import

ballardw — Mon, 24 Aug 2015 17:43:44 GMT

Reason for the Import from Excel (and actually other databases) mystery: use of Microsoft or other application data engine that responds to a SAS request from the named source. So there are no lines of code resulting that SAS could execute.

Re: No log listing from Proc Import

evp000 — Fri, 12 Feb 2021 16:29:36 GMT

I just had the same problem. Was trying to import with a very simple proc import, csv. Got an error but no information. Had done this a million times before and couldn't figure out the problem. Finally I closed down SAS and re-opened it and it worked. Go figure.