topic Re: Error activity in SAS Programming

Error activity

beatraca — Thu, 20 Oct 2016 21:39:06 GMT

Hello!!

I need your help.

I.m doing a activity .This is my activity.

In this practice, you submit a SAS program, review the log messages, and examine the results.

Reminder: Make sure you've defined the orion library.

Copy and paste the following code into the editor.

data work.newcountry;
   length Country_Code $ 2 Country_Name $ 48;
   infile "&path/country.dat" dlm='!'; 
   input Country_Code $ Country_Name $;
run;

proc print data=work.newcountry;
run;

Submit the code and then examine the results. How many rows and columns are in the report?
Examine the log. Based on the log notes following the DATA step, how many observations and variables are in the data set work.newcountry?

Ok, I create my library, this library is called Bea but can I can run my codige I have this message.

ERROR: Physical file does not exist, /folders/myfolders/ecprg193/country.dat.

I don,t understant this because this is the first activity and before I didn.t explain me anything.

Thanks!!!!!!!!!

Bea

Re: Error activity

Reeza — Thu, 20 Oct 2016 22:23:08 GMT

Where is this 'activity' from?

Re: Error activity

JediApprentice — Thu, 20 Oct 2016 22:35:22 GMT

In the beginning instructions when setting up the course, you should have downloaded a zip file that contains the files you need to run the practice programs, like the country.dat data file you're referencing in this program. First, did you download the these? Second of all, you have to make sure you placed those files in the location that you've specified as the path: /folders/myfolders/ecprg193/. You may just have the files in a different location.

Re: Error activity

Reeza — Thu, 20 Oct 2016 22:41:44 GMT

If you're on SAS UE and using the free e training courses, see this post:

https://communities.sas.com/t5/Base-SAS-Programming/Orion-Library-on-SAS-university-edition/m-p/302837/highlight/true#M64289

Re: Error activity

Cynthia_sas — Fri, 21 Oct 2016 01:45:09 GMT

Hi:
In the Programming 1 e-learning class, we do NOT provide the SAS datasets in a zip file. (only EG and JMP and EM classes have zip files with data sets -- programming courses have programs to make the data and a few courses have some Excel files in a zip archive).

The Programming 1 e-learning class has a program inside the e-learning course that the student must copy and paste into their editor and that program, when run, makes ALL the data sets and .DAT files that are used in the course.

The OP did not indicate what class they were following, but the Reminder text looks like it comes straight out of the e-learning course.

In the e-learning course, in the instructions, the student is told to create a file called setup.sas or make a snippet file in SAS Studio that contains these 2 statements:
%let path=/folders/myfolders/ecprg193;
libname orion "&path";

That way if &PATH exists then the INFILE statement (as shown in the OP code)
infile "&path/country.dat" dlm='!';

Will work, because &PATH will have a value or path, as assigned in the setup.sas or setup snippet.

However, if you do NOT ever run the instructions in the Course Overview section of Programming 1, then the physical location will be empty.

BTW, in the Programming 1 class, all of our programs are expecting a library called ORION (not a library called BEA). And, all of our programs are expecting that the student will follow the instructions and issue a %let statement to create the "helper" macro variable called &PATH.

The "physical file does not exist message" implies to me that the OP did not follow ALL of the instructions in the Course Overview and Data Setup section of the Programming 1 e-learning course.

Reading country.dat is NOT the first activity. Running the program and doing the setup in the Course Overview section is the first activity and if you don't follow and complete ALL of the instructions, then the data files will not exist when you move into the lessons.

cynthia

I can exactly replicate your error message if I submit my code WITHOUT submitting the setup program, as instructed in Task 1 in the course instructions.

1) Can generate the SAME error message if &PATH is not defined

2) Instructions that show where to save the setup statements

3) program submitted successfully AFTER running necessary statements

Re: Error activity

beatraca — Fri, 21 Oct 2016 16:29:05 GMT

Hi.Where is this zip file? I can.t see it

Thanks

Re: Error activity

beatraca — Fri, 21 Oct 2016 17:00:07 GMT

Hi!

This is my problem

I have this error and I don.t know as resolve

Thanks!!!!!

Bea

Re: Error activity

Reeza — Fri, 21 Oct 2016 17:11:59 GMT

See @Cynthia_sas post, #2 and look at the second red box highlighted.

Re: Error activity

beatraca — Fri, 21 Oct 2016 17:14:53 GMT

Thanks but I did these steps and I have the same error

Re: Error activity

Cynthia_sas — Fri, 21 Oct 2016 17:17:10 GMT

Hi: There is NOT a zip file. As Reeza suggests, you must look at my picture of the tasks in #2 above and follow ALL the instructions in Task 1. It looks like you made a folder. That is good. That means your 2 statements for Task 1, #4 are:
%let path=/folders/myfolders/ecprg193;
libname orion "&path";

But that is NOT enough. You MUST finish ALL the steps in Task 2. Task 2, #2 has a link to click which brings the code into a popup window. You MUST copy and paste that code from Task 2, #2 into your Editor Window and run the code, as I show in my #3 screen shot, after you run the code successfully (from Task 2) then you should see the files under the ecprg193 folder.

cynthia

Re: Error activity

beatraca — Fri, 21 Oct 2016 17:19:37 GMT

I wrote this code in my program.

%let path=/folders/myfolders/ecprg193;
libname orion "&path";

The log was

NOTE: El libref ORION se ha asignado correctamente:

Motor: V9

Nombre físico: /folders/myfolders/ecprg193ç

later

data work.newcountry;
length Country_Code $ 2 Country_Name $ 48;
infile "&path/country.dat" dlm='!';
input Country_Code $ Country_Name $;

The log is

data work.newcountry;

61 length Country_Code $ 2 Country_Name $ 48;

62 infile "&path/country.dat" dlm='!';

63 input Country_Code $ Country_Name $;

65 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

ERROR: Physical file does not exist, /folders/myfolders/ecprg193/country.dat.

Re: Error activity

Cynthia_sas — Fri, 21 Oct 2016 17:20:23 GMT

Did you actually RUN the program in Task 2, step 2, as highlighted in my previous posting. If so, and if the program WAS successful, then you would have files underneath the ecprg193 folder.

Since you do NOT have files under the ECPRG193 folder, you will need to go back to the beginning and do not try to read country.dat until AFTER you have run the program from Task 2, step 2 successfully and you see files under the ecprg193 folder.

cynthia

Re: Error activity

Reeza — Fri, 21 Oct 2016 17:20:27 GMT

Did you copy the code from the CLICK HERE link and run it?

Re: Error activity

Cynthia_sas — Fri, 21 Oct 2016 17:32:54 GMT

Hi:

Here is a set of numbered screen shots that illustrate the entire process from an empty folder for ecprg193 to a successful program.

Start with instructions

#1 Make a folder (you have already done this step)

#2 Check folder properties

#3 Run "setup" with LIBNAME

#4 at some point save code as setup.sas or save as snippet

#5 Task 2, Step 2, Paste code into the Studio editor window

#6 After code runs, see files in ecprg193 folder and see PROC CONTENTS in Results window

#7 After Task 2, Step 2 code runs successfully, you should be able to see the files in your shared folder location

Note that your shared folder location might not be the same as what is shown in my screen shot.

You CANNOT try to read COUNTRY.DAT until AFTER you have successfully run the program inside Task 2.

cynthia

Re: Error activity

beatraca — Fri, 21 Oct 2016 17:54:51 GMT

@Cynthia_sas @Reeza ohhh I can now!!!!! Thanks for your patient with me!!!!

Re: Error activity

egouws — Wed, 30 May 2018 20:27:45 GMT

Hi Cynthia.

I am having the same error, but I have all the Orion files, but the file extensions are .sas7bdat instead of just .dat. How do I resolve this?

Re: Error activity

Cynthia_sas — Wed, 30 May 2018 23:44:07 GMT

Hi:
The program inside the Programming 1 course creates a variety of files. What you see in your ORION library are the SAS7BDAT files -- those are SAS datasets. We also create several .DAT files and .CSV files, but you will NOT see those in the PROC CONTENTS output. Instead, you need to go to page 2 of this posting and look at #6 screen shot. In that screen shot, the Files and Folders list or Server Files and Folders list shows you ALL the files created and the PROC CONTENTS output shows you the SAS data sets that were created. I believe the date on that posting is 10-21-2016 at 01:32 PM -- look at screen shot #6.

cynthia

if you do NOT see files in your Files and Folders list, such as shown in my screen shot #6, then you need to rerun the setup program again.

Re: Error activity

tahoora — Sun, 10 Jun 2018 14:05:07 GMT

I do whatever you say at this topic but I still get 25 errors about the file does not exist.

I work with ubuntu 16.04 lts

this is one of this error:

9262 run;
9263 data _null_;
9264 infile datalines truncover length=length;
9265 input;
9266 file mydata(nonsales.csv) lrecl=256;
9267 put _infile_ $varying. length;
9268 datalines4;
 
ERROR: Physical file does not exist, /opt/sasinside/SASConfig/Lev1/SASApp/FILEPATH.

NOTE: The SAS System stopped proces

Re: Error activity

Cynthia_sas — Sun, 10 Jun 2018 15:31:52 GMT

Hi:

This %LET statement is incorrect:

Please go back and look at my example posted as image #4, and as shown below:

You do not use the string FILEPATH in the %LET statement. That is incorrect, as shown in your screen shot.

You MUST use the path location to your data. Until you create the correct setup file statements, the data creation program will not be able to make the data correctly and any subsequent programs will not run correctly. We use the helper variable &PATH in all of our programs. For example, when you see something like this:

INFILE "&path/sales.dat";

That is because everybody will have a different location for the physical storage of their data files. Here are some examples of how you would specify the setup statements that MUST be in effect for our programs to work correctly, including the setup statements:

It would be OK to use the fully qualified value instead of using &PATH in the LIBNAME statement. But, you STILL need to specify the helper variable &PATH correctly. This would be acceptable (unnecessary, but acceptable) for all of the above statements:

As I explained, using this statement:

%let path=FILEPATH; is incorrect. We intended for you to replace the string "FILEPATH" with YOUR location, as illustrated in my screen shots in the previous posting. It would be unlikely that your physical storage location for the data would be in a location called FILEPATH. Your location appears to be in this path:

/folders/myfolders/sasuser.v94/ecprg193

and if this is the case, when you right click on the ecprg193 folder and you see THIS path location for your folder, then your correct setup statements BEFORE you run the setup program would be:

Please correct your code and re-run the program from Task 2 again. Then save the statements as setup.sas or as a snippet, whichever you prefer.

Our code in the course expects that &PATH will be correctly assigned so that statements that reference that physical location will find the SAS datasets AND the flt files (the .dat and .csv) files that the data creation program creates. If &PATH is not correct when that program runs, then the flat files will not be created correctly the first time and the files will not be found with any FILE or INFILE statements.

Fixing this issue is entirely in your control. My suggestion is that you revisit the screen shots that I posted and re-read the instructions to make the data again, keeping in mind that

%LET path=FILEPATH;

is model syntax that you are expected to change BEFORE you run the data creation program.

Hope this helps,

Cynthia