Help using Base SAS procedures

Import data files from a local windows machine

Reply
New Contributor
Posts: 4

Import data files from a local windows machine

I have been trying to use a virtual computing lab to run SAS (version 9.2). But I got troubles in importing data files which are located on a Windows machine. I tried 4 different ways, but I got error messages every time:


libname  mm "\\tsclient\D\Green";

filename STU "\\tsclient\D\ss.txt";

ERROR: Physical file does not exist,

       \\tsclient\D\ss.txt.

NOTE: The SAS System stopped processing this step because of errors

libname  mm"\\tsclient\D\Green";

filename STU "D:\ss.txt";

ERROR: Device is offline.

NOTE: The SAS System stopped processing this step because of errors.

libname  mm "D:\Green";

filename STU "D:\ss.txt";

ERROR: Libref M_DEC03 not available for use.

ERROR: Error in the LIBNAME statement.

ERROR: Libref M_DEC03 is not assigned.

NOTE: The SAS System stopped processing this step because of errors.

libname  mm "//tsclient/D/Green";

filename STU "//tsclient/D/ss.txt";

ERROR: Physical file does not exist,

       \\tsclient\D\ss.txt.

NOTE: The SAS System stopped processing this step because of errors.

Can anyone help me? Thanks a lot!!!

Super User
Posts: 19,768

Re: Import data files from a local windows machine

Posted in reply to xiaoyixiao

What do you mean by virtual computing lab? Is this a VM?

New Contributor
Posts: 4

Re: Import data files from a local windows machine

Hi Reeze, I don't install SAS in my local machine. I am remotely using SAS software stored in my school computer.

Frequent Contributor
Posts: 77

Re: Import data files from a local windows machine

Posted in reply to xiaoyixiao

pls share the sample data

New Contributor
Posts: 4

Re: Import data files from a local windows machine

Posted in reply to TarunKumar

The data set is from PISA. Any idea about how to solve this kind of issue about running a local data file in a virtual computing lab? Thanks!

Contributor
Posts: 37

Re: Import data files from a local windows machine

Posted in reply to xiaoyixiao

I would suggest you to move all your data to the virtual machine if you can and SAS will be able to access them normally. If not, you might need to SIGNON to your local machine and establish a libname for your files.

This will be a good start SAS/SHARE(R) 9.2 User's Guide

Keywords : SIGNON , RSUBMIT, SLIBREF

Thanks

Super User
Posts: 19,768

Re: Import data files from a local windows machine

Posted in reply to xiaoyixiao

It is similar to the set up for SAS University Edition (Google it)

You'll either need to move your data to the VM - unlikely as it will probably disappear each time you open the VM or set up a shared Folder. How to do that depends on your OS and your VM so I can't provide more info without more info, but the instructions for SAS UE should be the same. And most oat likely your school has a specific set up, ie a network drive or space to save things that is accessible by you and the VM.

New Contributor
Posts: 4

Re: Import data files from a local windows machine

Thanks, Reeza. I also thought that it might be similar to the set up for SAS University Edition. So I tried it. That is my method 4. But it didn't work either. What kind of "more info" do you need so that you can "provide more info"? Thanks a lot!

libname  mm "//tsclient/D/Green";

filename STU "//tsclient/D/ss.txt";

ERROR: Physical file does not exist,

       \\tsclient\D\ss.txt.

NOTE: The SAS System stopped processing this step because of errors.



Super User
Posts: 19,768

Re: Import data files from a local windows machine

Posted in reply to xiaoyixiao

What's your OS and how do you connect to your Virtual Machine/Library?

Can you access any directories while on that machine, i.e. a shared university network drive or an assigned drive? You may need to move the file there.

Ask a Question
Discussion stats
  • 8 replies
  • 650 views
  • 0 likes
  • 4 in conversation