DATA Step, Macro, Functions and more

Macro SAS

Reply
Occasional Contributor
Posts: 11

Macro SAS

error.png

whay it showing error  with following code?

libname books "C:\books\datasets";
data book.ytdsales(label='Sales for 2014');
attrib section length=$30 label='Section'
booktitle length=$50 label='Title of Book'
author length=$50 label='First Author'
publisher length=$50 label='Publisher'

Super User
Super User
Posts: 7,401

Re: Macro SAS

This has nothing to do with macro SAS.  The program is telling you that the path:

c:\books\datasets

Does not exist.  

 

This can mean you don't have a directory named that or SAS doesn't have access to it.

 

What software are you using, SAS UE version is mounted in a virtual image and you need to use Unix paths to certain areas to get data, you can't use local C drive.

Trusted Advisor
Posts: 1,372

Re: Macro SAS

1) There is no folder : C:\books\datasets - check again the exact path name.

2) if you define libname books '...' then refer  to dataset should be

       books.<data set name> and not book.<dataset name>  (letter S is absent)

Occasional Contributor
Posts: 11

Re: Macro SAS

Instead book.ytdsales.I am using work.ytd slaes its working.When I run this code a library name book created but In SAS log file it says book doesnot exist.

Trusted Advisor
Posts: 1,372

Re: Macro SAS

you defined libname books not libname book.

 

change to libname book and post your new log again

Super User
Posts: 6,936

Re: Macro SAS


Tap222 wrote:

Instead book.ytdsales.I am using work.ytd slaes its working.When I run this code a library name book created but In SAS log file it says book doesnot exist.


This is because the path for your library book does not exist (in the scope of your SAS process, which might be on a remote server or in a virtual machine).

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Ask a Question
Discussion stats
  • 5 replies
  • 204 views
  • 0 likes
  • 4 in conversation