DATA Step, Macro, Functions and more

Using a sas7bdat file with SAS University

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 5
Accepted Solution

Using a sas7bdat file with SAS University

HI everyone,

 

I just downloaded and installed SAS University edition, I have to use it for an analysis for one of my university's course but I am having some problems.

I have 2 files to analize and they are both sas7bdat files.

When I run SAS via browser and try to open them the programme starts loading and freezes, to be more precise it doesn't freeze, the loading process just never ends and i have to close the virtual machine and restart everything in order to do anything.

I have tried both Oracle VM virtual box and VMware, and tried the installation on 2 different computers. The point is that some other students in my class tried to open the files with their SAS university ed. and they can easily open them (at first I thought the files were too big or something). I looked with them for a solution but we just can't see any difference between their installation and mine.

I correctly created the folder and it is shown in the top left part of the SAS window, also the files in the folder are visible but if I double click on one of them it happens what I described above. I also tried to run the virtual machines softwares as administrator. And I tried with Chrome, Firefox and IE.

I even try some manual coding to open them, just some basics from what I could read online, I tried the following:

 

libname dati '/folders/myfolders/sasuser.v94/';

data polizze;

set dati.polizze;

run; 

 

and the software stays like this:

esecuzione freeze.jpg

I tried to leave it for like 30 minutes.. just doesn't load.

 

or

 

libname dati '/folders/myfolders/sasuser.v94/';

data tabella2;

set polizze;

run; 

 

and I get:

error tabella2.jpg

 

I tried to put the files both in sauser.v94 and in myfolders but nothing changed.

 

It's really strange that this happens also on both my computers, and they have very different specifics.

 

I really don't know what to do more, I could really need some help Smiley Sad

 

Many Thanks, 

Federico


Accepted Solutions
Solution
‎06-18-2016 06:35 PM
Occasional Contributor
Posts: 5

Re: Using a sas7bdat file with SAS University

I unistalled the virtual box software, deleted all the files and reinstalled everything. 

Now all seems to be ok, I can open the files with no problems and work with them, not sure what I did different from the previous 2 installations (looked exactly the same process to me) but the problem seems to be solved.

The files are still stored in sasuser.v94 folder but I can work with them properly.

 

Even though I am not sure how this was fixed I have to say that the quality of the support in this forum is excellent. Thanks Reeza and Jan for your replies.

 

 

 

 

View solution in original post


All Replies
Super Contributor
Posts: 408

Re: Using a sas7bdat file with SAS University

You may want to make sure your datasets are not damaged. were they copied over using something like FTP?

 

Do the following:

 

libname dati '/folders/myfolders/sasuser.v94/';
proc contents data=dati.polizze;
run;

and let us know what shows up.

 

Regards,

- Jan.

Occasional Contributor
Posts: 5

Re: Using a sas7bdat file with SAS University

Hi Jan, thanks for your reply, 

 

The file was zipped together with the material for the exam and sent via email, but the sas7bdat files after trying to work with them I also sent them via facebook chat or skype to 2 other people and they can work with that file.

 

Anyway, I tried your code and it just doesn't load, stays in the loading window without doing anything:

 

proc error.png

 

KR

 

Super Contributor
Posts: 408

Re: Using a sas7bdat file with SAS University

Hi @FedeTS89,

 

Thanks for clearing that up. We must assume (careful here) that the datasets are fine. Next thing to look is the server. I am not afmiliar with the SAS Univserity edition per se, but the general SAS troubleshooting adagium is "Thou shalt read logfiles".

 

Sorry for not being more of a help here.

 

Regards,

- Jan.

Super User
Posts: 17,963

Re: Using a sas7bdat file with SAS University

[ Edited ]

What happens if you run the following:

 

proc means data=sashelp.class;
Run;

Proc export data=sashelp.class outfile='/folders/myfolders/test.csv' DBMS = CSV replace; run;

What is your OS?

Can you attach a copy of your dataset?

 

EDIT: 

You should be placing your dataset in the myfolders folder you created, not the sasuser.v94 folder so your code should look like the sample below. Your second set of code is incorrect, and it looks like SAS ran successfully there so I assume that it is running fine.

 

libname dati '/folders/myfolders/';

data polizze;
set dati.polizze;
run; 

 

 

Solution
‎06-18-2016 06:35 PM
Occasional Contributor
Posts: 5

Re: Using a sas7bdat file with SAS University

I unistalled the virtual box software, deleted all the files and reinstalled everything. 

Now all seems to be ok, I can open the files with no problems and work with them, not sure what I did different from the previous 2 installations (looked exactly the same process to me) but the problem seems to be solved.

The files are still stored in sasuser.v94 folder but I can work with them properly.

 

Even though I am not sure how this was fixed I have to say that the quality of the support in this forum is excellent. Thanks Reeza and Jan for your replies.

 

 

 

 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 5 replies
  • 324 views
  • 0 likes
  • 3 in conversation