Help using Base SAS procedures

No log listing from Proc Import

Reply
Occasional Contributor
Posts: 6

No log listing from Proc Import

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
Super Contributor
Posts: 345

Re: No log listing from Proc Import

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

Re: No log listing from Proc Import

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.....
N/A
Posts: 0

Re: No log listing from Proc Import

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.
Super Contributor
Posts: 359

Re: No log listing from Proc Import

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.
N/A
Posts: 0

Re: No log listing from Proc Import

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
N/A
Posts: 0

Re: No log listing from Proc Import

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
N/A
Posts: 1

Re: No log listing from Proc Import

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:

  1. Save a copy of the excel spreadsheet as a .CSV file;
  2. Import that CSV file;
  3. 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.

Super User
Posts: 11,343

Re: No log listing from Proc Import

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.

N/A
Posts: 1

Re: No log listing from Proc Import

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.

Ask a Question
Discussion stats
  • 9 replies
  • 2919 views
  • 0 likes
  • 8 in conversation