BookmarkSubscribeRSS Feed
HugoVini
Obsidian | Level 7

Hello,

 

I'm trying to upload a csv file and Sas gave me that message:

 

Due to a network issue, browser type, or large file size, the file "Test.csv" was not transferred to the SAS server. 

 

log message: Read Access Violation IMPORT

 

I think this problem is related to permission, could anyone help me solve it?

5 REPLIES 5
ballardw
Super User

If it is a permissions issue then the first place to go would by your SAS admin or who ever sets up your SAS server.

 

Since file size is also a consideration how big is the file in question? You may need to provide that info to the admin as well.

HugoVini
Obsidian | Level 7

The file size is 4KB

ballardw
Super User

@HugoVini wrote:

The file size is 4KB


I think we can be pretty sure that file size is not the issue.

 

Just in case, you might want to open the file in a plain text editor and verify that it is actually CSV. I have noted a disturbing trend of folks calling a file CSV, which means commas are used to separate values, only find out the file actually uses another character such as a | or tab character (which you won't generally see and whose symptom is columns that generally align with occasional horizontal shifts following short or long values of other columns). If you tell the program to load a file of CSV type an it isn't that might well be the issue.

 

Do not open in a spreadsheet program as they do not display the commas to verify the file type.

A CSV file would look something like this assuming there is a column header. Note the values of "4,  8". The quotes are there because the comma in that case is part of a single field or variable. Also the two commas adjacent indicate a field with no value recorded.

Client ID,Sex,DOB,Zip,Collection Date,Collection Site ,Results CT,Results GC,Results Syphillis,Results HIV,
1116381,1,10/27/1994,83704,7/2/2018,"4, 8",2,2,2,2,
1104587,2,9/9/1954,83704,7/3/2018,8,2,2,2,2,
1115554,1,4/14/1960,83704,7/3/2018,"4, 8",2,2,,2,
HugoVini
Obsidian | Level 7

I have been using this file for a long time, yesterday I remember that I changed some permissions, so from there I can not upload files anymore. 

 

Could you show me how your permissions are for the user who inserts tables? so I can try to correct it.

ballardw
Super User

I don't have access to VA so can't help with specific configurations.

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 5 replies
  • 721 views
  • 0 likes
  • 2 in conversation