topic Re: Programming 1: Essentials Lesson 7 Question in SAS Procedures

Programming 1: Essentials Lesson 7 Question

flachboard — Tue, 30 Dec 2014 19:54:44 GMT

Hello, I'm getting this error

ERROR: The PCFILES engine cannot be found.

ERROR: Error in the LIBNAME statement.

I'm trying to run this code:

libname custfm pcfiles path="&path/custfm.xls";

proc contents data=custfm._all_;

run;

data work.males;

run;

proc print data=work.males label;

run;

libname custfm clear;

Any thoughts as to what is wrong?

Re: Programming 1: Essentials Lesson 7 Question

naveen_srini — Tue, 30 Dec 2014 20:09:50 GMT

I don't think you need to specify pcfiles engine and path= coz &path will just resolve to the defined path of macro by the macro processor by substituting it's value from the global symbol table and places it back into the input stack.

libname custfm "&path\custfm.xls"; *this should work getting your libname assigned.

Re: Programming 1: Essentials Lesson 7 Question

Reeza — Tue, 30 Dec 2014 20:10:00 GMT

Are you in SAS University Edition?

Re: Programming 1: Essentials Lesson 7 Question

flachboard — Tue, 30 Dec 2014 20:15:36 GMT

No, I'm not in the SAS University Edition.

Re: Programming 1: Essentials Lesson 7 Question

Reeza — Tue, 30 Dec 2014 20:17:39 GMT

Is PCFILES Server installed?

Do you need to use PCFILES at all? It's used when you have SAS 64 bit and Excel 32 Bit.

What version of SAS do you have and what bitness? Also what version of Excel and bitness?

Re: Programming 1: Essentials Lesson 7 Question

flachboard — Tue, 30 Dec 2014 20:21:11 GMT

Naveen, I got this error when running what you advised:

WARNING: Apparent symbolic reference PATH not resolved.

ERROR: Connect: 'C:\Users\cflach\Documents\&path\custfm.xls' is not a valid path. Make sure

that the path name is spelled correctly and that you are connected to the server on

which the file resides.

ERROR: Error in the LIBNAME statement.

Re: Programming 1: Essentials Lesson 7 Question

flachboard — Tue, 30 Dec 2014 20:22:35 GMT

Reeza,

How do I know if PCFILES server is installed?

Where do I find the bitness for SAS and Excel?

Thanks!!

Re: Programming 1: Essentials Lesson 7 Question

ballardw — Tue, 30 Dec 2014 20:25:09 GMT

When referencing a macro variable and other literal text you need a . after the macro variable to indicate the end of the variable and that the remainder text is appended. &path/custfm.xls is going to look for a macro variable with /custfm as part of the name, which isn't a legal name and won't exist. Use &path./custfm.xls or &path.\custfm.xls depending on Operating System.

Re: Programming 1: Essentials Lesson 7 Question

naveen_srini — Tue, 30 Dec 2014 20:27:53 GMT

Hi, &path will hold the value of the path. So if you are specifying the full path name, don't use macro &path

libname libref "your path"; *this is the syntax;

try this: libname custfm 'C:\Users\cflach\Documents\custfm.xls' ; * assuming this is where your xls file is located;

Re: Programming 1: Essentials Lesson 7 Question

flachboard — Tue, 30 Dec 2014 20:48:05 GMT

Thank you, Naveen.

I think I'm getting closer. I did get this warning though with nothing in the output:

WARNING: No matching members in directory.

Re: Programming 1: Essentials Lesson 7 Question

Reeza — Tue, 30 Dec 2014 20:51:18 GMT

I would first try suggestion of hard coding the path, except with the EXCEL specified. Remember for macro variables to resolve you need to use double not single quotes.

libname custfm excel 'C:\Users\cflach\Documents\custfm.xls' ;

For PC File Server if you're on Windows desktop go to Programs>SAS>PC FILE SERVER should be in the list of applications.

For bitness of SAS, in SAS go to HELP>About SAS and see what is under Software Information.

Re: Programming 1: Essentials Lesson 7 Question

naveen_srini — Tue, 30 Dec 2014 20:57:21 GMT

did the libname get successfully assigned?

if yes, do a test using

proc contents data=custfm._all_;/* this will list you the datasets in the excel that you are reading */

run;

If there aint any, well, you would have to know where your xls file is placed, i mean the exact location, find that, get it's path and replace exactly in the syntax and do again.

Alternatively, import the xls file to your SAS environment using the import wizard or proc import and get started with your SAS stuff. If this fails too, store the file as csv file and read with infile and input statements. Have fun!!!

Re: Programming 1: Essentials Lesson 7 Question

flachboard — Tue, 30 Dec 2014 21:07:05 GMT

I think that worked. Sorry, I'm super new to SAS. Thank you so much!!

Re: Programming 1: Essentials Lesson 7 Question

Reeza — Tue, 30 Dec 2014 22:30:29 GMT

Please mark question answered, I believe it goes

Re: Programming 1: Essentials Lesson 7 Question

flachboard — Tue, 30 Dec 2014 23:29:45 GMT

I'm sorry, this is my first time. How do I mark a question answered?

Re: Programming 1: Essentials Lesson 7 Question

Reeza — Tue, 30 Dec 2014 23:43:26 GMT

Go to the main question page (not the communications page) and you'll see a button to mark questions answers/helpful on each post. If no answer is exact mark it assumed answered in the initial post.