topic Re: why it does not work in SAS Programming

why it does not work

tianerhu — Fri, 14 May 2021 15:32:04 GMT

options validvarname=any;
libname apple 'C:\Users\liaodong\Documents\My SAS Files\Wages.xls';
proc means data = apple.'Permanent$'n mean;
var wage;
run;

message in log:

39 options validvarname=any;
40 libname apple xlsx 'C:\Users\liaodong\Documents\My SAS Files\Wages.xls';
ERROR: Invalid physical name for library APPLE.
ERROR: Error in the LIBNAME statement.
41 proc means data = apple.'Permanent$'n mean;
ERROR: Libref APPLE is not assigned.
42 var wage;
ERROR: No data set open to look up variables.
43 run;

NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE MEANS used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

Re: why it does not work

PaigeMiller — Fri, 14 May 2021 15:36:39 GMT

40 libname apple xlsx 'C:\Users\liaodong\Documents\My SAS Files\Wages.xls';
ERROR: Invalid physical name for library APPLE.
ERROR: Error in the LIBNAME statement.

The file does not exist. You have used the wrong file name or folder name (or both).

Re: why it does not work

tianerhu — Fri, 14 May 2021 15:38:56 GMT

Re: why it does not work

PaigeMiller — Fri, 14 May 2021 15:43:20 GMT

You screen capture is too small to read.

Also, for .XLS files, I think you need to use the EXCEL engine and not the XLSX engine.

Re: why it does not work

tianerhu — Fri, 14 May 2021 15:46:19 GMT

The excel engine doesn't work .

Re: why it does not work

ballardw — Fri, 14 May 2021 15:50:06 GMT

@PaigeMiller wrote:

You screen capture is too small to read.

Also, for .XLS files, I think you need to use the EXCEL engine and not the XLSX engine.

And a license for SAS/Access Interface to PC File formats

If you run this code:

Proc setinit;
run;

And the LOG does not show something similar to

---SAS/ACCESS Interface to PC Files

then you do not have a license and need one.

Re: why it does not work

tianerhu — Fri, 14 May 2021 15:56:52 GMT

but the context in the book do not tell like things about SAS/PC format file ?

Re: why it does not work

PaigeMiller — Fri, 14 May 2021 15:59:12 GMT

@tianerhu wrote:

The excel engine doesn't work .

Saying it "doesn't work" is not helpful. Show us the LOG (including the actual code and any ERROR messages) you are using that doesn't work.

Re: why it does not work

tianerhu — Fri, 14 May 2021 16:15:52 GMT

options validvarname=any;
libname apple 'C:\Users\liaodong\Documents\My SAS Files\Wages.xls';
proc means data = apple.'Permanent$'n mean;
var wage;
run;

message in log:

NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE MEANS used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

Re: why it does not work

PaigeMiller — Fri, 14 May 2021 16:31:35 GMT

You left out the ENGINE name

libname apple excel 'C:\Users\liaodong\Documents\My SAS Files\Wages.xls';

Re: why it does not work

tianerhu — Fri, 14 May 2021 16:37:20 GMT

If you have SAS/ACCESS Interface to PC Files, then you can use the IMPORT procedure to import Microsoft Excel files in the Windows and UNIX operating environments.

Re: why it does not work

tianerhu — Fri, 14 May 2021 16:39:21 GMT

I have try it , doesn't work.

Re: why it does not work

PaigeMiller — Fri, 14 May 2021 16:50:43 GMT

@tianerhu wrote:

I have try it , doesn't work.

As I stated before (and I shouldn't have to ask multiple times), SHOW US THE LOG.

Re: why it does not work

ballardw — Fri, 14 May 2021 16:54:55 GMT

Which version of SAS are you using? SAS University Edition requires files to be in the shared folder set up when installed and does not use Windows file syntax because it runs in a virtual machine using UNIX/Linux file syntax.

If you are connecting to server then the server does not see your local hard drive and the file needs to be moved to where the server can see it.

If using SAS On Demand For Academics that is a server version and needs to have the file uploaded to be used.

Re: why it does not work

Kurt_Bremser — Fri, 14 May 2021 17:24:13 GMT

How do you use SAS?

complete local SAS installation, either through Enterprise Guide or Display Manager
server-based SAS, with Enterprise Guide (and a connection profile) or SAS Studio
University Edition
On Demand for Academics

Note that only the first method will have access to your C: drive; UE will need the file to be stored in the shared folder, and On Demand and client/server need you to copy the file to the server first.

Re: why it does not work

tianerhu — Fri, 14 May 2021 20:35:00 GMT

Thank you for your help.

Re: why it does not work

tianerhu — Fri, 14 May 2021 23:45:01 GMT

Thank you for your help.

Re: why it does not work

tianerhu — Fri, 14 May 2021 23:50:21 GMT

Finally , I find the reason. Because the xls file which is 32 bit is not compatible with SAS which is 64 bit .