topic Re: Is There Anything Special To Have A File Recognized By SAS University Edition in SAS Procedures

Is There Anything Special To Have A File Recognized By SAS University Edition

CraigKaercher — Wed, 25 Mar 2015 15:49:11 GMT

This will be embarrassingly easy to someone but I am trying to read in a text file. I have done it in the past. I have it in the same folder as the previous text files. It will recognize the first one but not my new one. I have tried to be extra careful concerning spelling, etc. I do not understand why it can find one but not the other.

Re: Is There Anything Special To Have A File Recognized By SAS University Edition

Cynthia_sas — Wed, 25 Mar 2015 16:06:43 GMT

Hi:

You will not be able to use your Windows path. But you should be able to simply use an INFILE statement or a FILE= option (depending on how you're reading the data):

INFILE "/folders/myfolders/Pgm1ExtInp.txt";

FILE="/folders/myfolders/Pgm1ExtInp.txt";

I made up some fake data (just 2 rows) and wrote a little program to illustrate. All the program is doing is dumping the records into the SAS log.

cynthia

Re: Is There Anything Special To Have A File Recognized By SAS University Edition

CraigKaercher — Wed, 25 Mar 2015 16:29:27 GMT

Cynthia,

Thanks but I don't think that will work. The file that already existed works:

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

42 ;

43 data DetailINP;

44 infile "/folders/myfolders/fabscdataoct.txt" DLM='|' Firstobs=2;

45 INPUT ACCOUNT :$10. LEVEL1 $ LEVEL2 $ DISPLA $ CIRCUIT $

46 CALLS $ MINUTES $ COST $ DISCOUNT $

47 TAXES $ CIRCUITCST $ MRCCOST $ CREDITS $ FINALAMOUNT;

48 put ACCOUNT FINALAMOUNT;

49 RUN;

NOTE: The infile "/folders/myfolders/fabscdataoct.txt" is:

Filename=/folders/myfolders/fabscdataoct.txt,

Owner Name=sasdemo,Group Name=sas,

Access Permission=-rw-rw-r--,

Last Modified=13Oct2014:12:33:51,

File Size (bytes)=116480

But it can't find the other file even though it is in the same directory:

55 data AccountINP;

56 infile "/folders/myfolders/fabscaccountinfo.txt" dlm =' ' Firstobs=1;

57 INPUT ACCOUNT :$10. CompName $ CompAddress $ CompCity $

58 CompState $ CompZip $;

59 put ACCOUNT CompName;

60 RUN;

ERROR: Physical file does not exist, /folders/myfolders/fabscaccountinfo.txt.

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

WARNING: The data set WORK.ACCOUNTINP may be incomplete. When this step was

stopped there were 0 observations and 6 variables.

WARNING: Data set WORK.ACCOUNTINP was not replaced because this step was

stopped.

Re: Is There Anything Special To Have A File Recognized By SAS University Edition

Tom — Wed, 25 Mar 2015 20:07:29 GMT

Looks like either your Windows session is looking at a different folder or there is some strange character in the filename that is not captured in the screen shot.

Try making a new file from SAS and see if it appears in your Windows Explorer screen.

data _null_;

set sashelp.class ;

file '/folders/myfolders/brand_new_file.csv' dsd ;

put (_all_) (:);

run;

Re: Is There Anything Special To Have A File Recognized By SAS University Edition

CraigKaercher — Wed, 25 Mar 2015 20:59:47 GMT

That works like I believe you were expecting. I see it in the file list in SAS, BUT... I don't see it in Windows Explorer. Windows Explorer should see it, right? Thanks for the help.

Craig

Re: Is There Anything Special To Have A File Recognized By SAS University Edition

Tom — Wed, 25 Mar 2015 21:24:02 GMT

Looks like you are looking in the wrong folder in Windows. Double check how you mapped the folders in your virtual machine.

Re: Is There Anything Special To Have A File Recognized By SAS University Edition

Reeza — Thu, 26 Mar 2015 01:34:04 GMT

Couple of things, restart your VM.

You should see the file both in your folder list and your windows explorer.

If the file has weird characters or the input statement is incorrect I've seen SAS UE throw that error, even though the file exists - not helpful.

The file path is case sensitive since it's Unix

Re: Is There Anything Special To Have A File Recognized By SAS University Edition

CraigKaercher — Mon, 30 Mar 2015 15:32:04 GMT

Sorry for the delay. Still in the same situation. How do I find where "/folders/myfolders/" maps to? Thanks.

Craig

Re: Is There Anything Special To Have A File Recognized By SAS University Edition

Reeza — Mon, 30 Mar 2015 17:42:26 GMT

Check your VM settings

Re: Is There Anything Special To Have A File Recognized By SAS University Edition

CraigKaercher — Mon, 30 Mar 2015 20:02:14 GMT

I looked but it doesn't seem to have the mapping to myfolders. I checked and the one file fabscdataoct.txt only occurs in one directory on the drive where SAS University Edition is. That is where the other one is. It still just doesn't show up and the SAS dataset I created does not appear in Windows Explorer.

Craig