topic Re: .csv data upload in SAS is not working in New SAS User

.csv data upload in SAS is not working

Lacona — Sun, 22 Sep 2019 19:35:18 GMT

Hey all,

I have an exel.csv file, which I can't upload in SAS studio.
There are no blanks in between the values and nothing. I tried to upload files I uploaded before and even them are not possible to upload.
I can go and search for the file on my computer, but then it won't show on the upload popup.

please help!

Re: .csv data upload in SAS is not working

Kurt_Bremser — Sun, 22 Sep 2019 19:41:39 GMT

In your previous questions, the path was just

/folders/myfolders/LAB

Are you sure about the " assignment" part (note the blank)?

Re: .csv data upload in SAS is not working

Lacona — Sun, 22 Sep 2019 19:53:30 GMT

Lab and lab assignment are just the names of the folders in SAS.
Upload to Lab assignment worked recently perfectly fine.
I tried to use my folder/myfolders/lab (folder lab exists, too) now, but didn't work either.

Re: .csv data upload in SAS is not working

Kurt_Bremser — Sun, 22 Sep 2019 20:09:18 GMT

Could it be you overran your quota?

Re: .csv data upload in SAS is not working

Lacona — Sun, 22 Sep 2019 20:39:08 GMT

How can I check that?
Would be a possibility!

Re: .csv data upload in SAS is not working

Kurt_Bremser — Sun, 22 Sep 2019 20:56:10 GMT

Delete files you no longer need, and try the upload again.

On the system I administer (AIX), users just log on to the command line and run

quota -u

to see their current status.

Re: .csv data upload in SAS is not working

Lacona — Sun, 22 Sep 2019 21:05:45 GMT

I deleted everything and it's not working.
Using MacBook.

quota -u;
run;

is not working either...

Re: .csv data upload in SAS is not working

Lacona — Sun, 22 Sep 2019 21:49:29 GMT

... and now SAS Studio hangs up every 10mins...

Re: .csv data upload in SAS is not working

Kurt_Bremser — Sun, 22 Sep 2019 22:14:26 GMT

Are you using University Edition in a VM on your Mac?

Re: .csv data upload in SAS is not working

Lacona — Mon, 23 Sep 2019 01:13:04 GMT

University Edition on a Mac ...

Re: .csv data upload in SAS is not working

Tom — Mon, 23 Sep 2019 01:34:01 GMT

If you are running SAS University Edition then there is no need to "upload" files. When you setup the virtual machine that is running SAS you told it what actual folder on your mac should be mapped to the virtual machine. So just put the file into the folder using any Mac tool you want and you should be able to see it in the SAS/Studio interface and with SAS code.

Re: .csv data upload in SAS is not working

Reeza — Mon, 23 Sep 2019 01:46:37 GMT

I think the upload tool has a limit of 10MB.

However, you can work with files of any size by putting them in the my folders location as indicated by Tom.

Since you've possibly messed up your settings, I'd recommend re-installing and re-linking your myfolders location again.

Restarting your VM can also help - note this is not the same as restarting Oracle Virtual Box, you need to explicitly restart the virtual machine.

Re: .csv data upload in SAS is not working

Lacona — Mon, 23 Sep 2019 02:21:16 GMT

I never have seen any file I put into my folder on my computer in SAS without uploading it into the SAS folder?! And vice versa, never anything I saved in SAS appeared automatically in the folder in my finder.

How can I re-install and re-link the myfolders location? I checked the VM, the pathway for myfolders is correct and it says that there is one shared folder with full access.

I off-ed the VM twice, but that was not the solution for my problem.

Re: .csv data upload in SAS is not working

Reeza — Mon, 23 Sep 2019 02:21:04 GMT

Perhaps you're not looking in the correct location? It's all stored locally on your computer. Navigate to the myfolders location on your computer. You should see all the files you've uploaded/downloaded there.

If you're on a Mac you should also see any newly created files in your Recent view, assuming you created them recently.

SAS UE doesn't work well with different languages, I've seen several people have errors that were due to language issues.

Re: .csv data upload in SAS is not working

Lacona — Mon, 23 Sep 2019 02:27:44 GMT

1. Opened the finder, opened the folder SASUniversityEdition, opened the folder myfolders, all the downloaded and created .csv files are there, including the new file tuition.csv
2. Opened SAS, opened datasets and files, opened myfolders, not one of the .csv files is there

Re: .csv data upload in SAS is not working

Reeza — Mon, 23 Sep 2019 02:28:31 GMT

I assume in #2 you mean Server Files and Folders? If so, please show the screenshot.

Re: .csv data upload in SAS is not working

Lacona — Mon, 23 Sep 2019 02:32:32 GMT

SAS and Computer, shared folder ... "Eigene Ordner" = myfolders

Re: .csv data upload in SAS is not working

Reeza — Mon, 23 Sep 2019 02:49:56 GMT

are you sure that's the correct location? They don't seem to match up at all from your screenshots. SAS is showing three folders and the myfolders here is showing only 1. Also, the path shown there is a bit different than what was shown in your first screenshot but I can't tell if that's a language issue between the two systems which in itself could be causing issues.

Re: .csv data upload in SAS is not working

Lacona — Mon, 23 Sep 2019 02:50:48 GMT

It is also not possible any more to save an open .ctl in SAS serverfiles and folders ...

Re: .csv data upload in SAS is not working

Reeza — Mon, 23 Sep 2019 02:56:57 GMT

I'm very much leaning towards you uninstalling SAS UE - delete the VM from Oracle Virtual Box, download it again and install from scratch. Then link it to your old myfolders.

Or contact SAS tech support though I suspect your hours and theirs may not overlap well.