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
... View more
