topic Re: Import data files from a local windows machine in SAS Procedures

Import data files from a local windows machine

xiaoyixiao — Tue, 30 Dec 2014 04:41:38 GMT

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!!!

Re: Import data files from a local windows machine

Reeza — Tue, 30 Dec 2014 04:54:57 GMT

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

Re: Import data files from a local windows machine

TarunKumar — Tue, 30 Dec 2014 06:07:20 GMT

pls share the sample data

Re: Import data files from a local windows machine

xiaoyixiao — Tue, 30 Dec 2014 06:55:02 GMT

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

Re: Import data files from a local windows machine

xiaoyixiao — Tue, 30 Dec 2014 06:58:26 GMT

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!

Re: Import data files from a local windows machine

Karthikeyan — Tue, 30 Dec 2014 09:13:10 GMT

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

Re: Import data files from a local windows machine

Reeza — Tue, 30 Dec 2014 11:09:19 GMT

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.

Re: Import data files from a local windows machine

xiaoyixiao — Tue, 30 Dec 2014 13:16:13 GMT

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.

Re: Import data files from a local windows machine

Reeza — Tue, 30 Dec 2014 19:24:33 GMT

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.