Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

LIBNAME error

Reply
Contributor
Posts: 22

LIBNAME error

[ Edited ]

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

Super User
Super User
Posts: 9,840

Re: LIBNAME error

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";

Contributor
Posts: 22

Re: LIBNAME error

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
Super User
Super User
Posts: 9,840

Re: LIBNAME error

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

Contributor
Posts: 22

Re: LIBNAME error

[ Edited ]

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?

Super User
Super User
Posts: 9,840

Re: LIBNAME error

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

Contributor
Posts: 22

Re: LIBNAME error

Definitely! Thanks for your replying

Super User
Posts: 24,010

Re: LIBNAME error

 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?

 

Contributor
Posts: 22

Re: LIBNAME error

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

Super User
Posts: 24,010

Re: LIBNAME error

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 Smiley Wink

Contributor
Posts: 22

Re: LIBNAME error

Alright, no problem. Let me know if you find any solution. Thanks Smiley Very Happy
Ask a Question
Discussion stats
  • 10 replies
  • 350 views
  • 1 like
  • 3 in conversation