topic Re: Macro SAS in SAS Programming

Macro SAS

Tap222 — Fri, 23 Dec 2016 10:09:19 GMT

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'

Re: Macro SAS

RW9 — Fri, 23 Dec 2016 10:23:42 GMT

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.

Re: Macro SAS

Shmuel — Fri, 23 Dec 2016 10:27:25 GMT

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)

Re: Macro SAS

Tap222 — Fri, 23 Dec 2016 10:35:28 GMT

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.

Re: Macro SAS

Shmuel — Fri, 23 Dec 2016 10:54:47 GMT

you defined libname books not libname book.

change to libname book and post your new log again

Re: Macro SAS

Kurt_Bremser — Fri, 23 Dec 2016 11:50:44 GMT

@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).