topic Re: LIBNAME error in SAS Visual Analytics

LIBNAME error

nitya411 — Mon, 12 Feb 2018 09:00:38 GMT

Hi,

I'm trying to import a sas file from VMWare to VA(Desktop) and i got this error mentioned below. What is the solution? Kindly update.

title 'Indian Currency Format';

proc format;
picture indianc
low-high='0,00,00,00,00,00,00,000';
run;

data NEW;
do EXP=1 to 15;
A=10**EXP;
output;
end;

format a indianc.;
run;

proc print data=NEW noobs;
var A;
run;

data CustomerordersN;
set nitya;
format a indianc.;
run;

libname work 'C:\Nitya';

data work.new;
set new;
run;

The SAS system library WORK may not be reassigned.
ERROR: Error in the LIBNAME statement

Re: LIBNAME error

RW9 — Mon, 12 Feb 2018 09:08:52 GMT

What is unclear with:

The SAS system library WORK may not be reassigned.

This means that there is already a library called work - which is a default libname created by SAS - and you cannot re-assign it. Call your libname something else. E.g.

libname tmp "c:/nitya";

Re: LIBNAME error

nitya411 — Mon, 12 Feb 2018 09:13:18 GMT

Right! that makes sense. I tried that. and it says that libname tmp is successfully assigned. But, when i check C: in VMware and desktop(out of vmware) TMP is not created. SO i'm facing problem in importing my SAS file to Visual Analytics

Re: LIBNAME error

RW9 — Mon, 12 Feb 2018 09:21:56 GMT

Right, so you are using a virtual image not your machine. You need to point to a folder to which the SAS system has access - if this is on the virtual image then you need to point to a path on the virtual image. I don't know what your setup is, as you using SAS University Edition by any chance? If not then consult with your IT or SAS group in your company and they will show you what network areas are available, but your path will look more like:

//myfolders/myarea

Re: LIBNAME error

nitya411 — Mon, 12 Feb 2018 09:29:37 GMT

Yeah, I'm working as an intern and using company's SAS Software. And I was given a task where I was supposed to convert the Numeric digit in Indian Comma Format in Visual Analytics (VA), I guess I'll need admin rights to import file out of virtual machine. Is there any other way to convert numeric digits to Indian Comma format in VA directly without importing file from virtual machine?

Re: LIBNAME error

RW9 — Mon, 12 Feb 2018 09:29:51 GMT

Sorry, I don't use VA. I will move this post to the relevant area.

Re: LIBNAME error

nitya411 — Mon, 12 Feb 2018 09:31:34 GMT

Definitely! Thanks for your replying

Re: LIBNAME error

Reeza — Mon, 12 Feb 2018 15:59:35 GMT

Is there any other way to convert numeric digits to Indian Comma format in VA directly without importing file from virtual machine

Can't you try a calculated measure or some function in VA to change the type? Why are you trying to bring the data out of VA to change the format, you should be able to do that within VA, at worse within the Data Designer/Planner. Or change the source file and reload that, but you should have documentation or a source otherwise how do you make sure this doesn't happen again when the data is refreshed?

Re: LIBNAME error

nitya411 — Tue, 13 Feb 2018 03:53:34 GMT

Yeah, I get your point. But I think Indian comma format is not possible in VA(One of the limitation in VA). If you know how that works and how to fix that then kindly update. Thanks

Re: LIBNAME error

Reeza — Tue, 13 Feb 2018 04:16:47 GMT

I would ask SAS Tech Support, it is after all why your company pays them a large sum of money for licensing and support.

And that's their job 😉

Re: LIBNAME error

nitya411 — Tue, 13 Feb 2018 04:18:41 GMT

Alright, no problem. Let me know if you find any solution. Thanks 😄