SAS Studio 5.1 cannot read files directly from the file system.

When the IMPORT procedure or a FILENAME statement references a CSV or delimited file on the file system, errors that are similar to the following occur:

There are two methods for successfully importing a delimited file from the local file system. Method 1 uses a CSV file as an example.

 

Method 1

 

1. Click on the Explorer navigation (the computer icon on the left).

2. Expand SAS Content.
3. Navigate to the SAS Content folder that you want to upload the file to. 

4. While the folder name is highlighted, click Upload (with the arrow icon).

5. In the Upload Files pop-up window, click the plus sign to add an attachment.

6. Navigate to the CSV file on your local file system that you want to upload. Then click Upload.
7. After you upload the file, you should see it in the navigation pane within the SAS Content folder that you chose to upload the file to. Right-click the CSV file and choose Create file reference.

8. Assign a name for the file reference or accept the default and click OK.

9. Use PROC IMPORT or a DATA step to import the file. Use the file reference name that you created in the previous step:
      proc import datafile=mycsv out=ds dbms=csv;
      run;

Method 2 

1. Place the files into a shared directory. The folder must be accessible by both the compute server and the SAS^® Cloud Analytic Services (CAS) server. A site administrator must create the shared directory.
2. A PROC IMPORT step that references the path of the shared directory can then be used to import any CSV or delimited files in that directory.

       Note: In SAS Studio 5.1, the files that you access from the shared directory are not visible in the navigation pane.

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
SAS System	SAS Studio for Viya	Microsoft® Windows® for x64	5.1		Viya
		Linux for x64	5.1		Viya

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

---

For SAS Studio 5.1, delimited files must be in a folder in the SAS Content area or placed in a shared drive that is available to the CAS server. Otherwise, you see "Physical file does not exist" or "Import unsuccessful" errors when you use PROC IMPORT or a FILENAME statement to read the file.

Type:	Usage Note
Priority:

Date Modified:	2019-08-13 09:16:57
Date Created:	2019-03-15 11:28:02