BookmarkSubscribeRSS Feed
Mara11
Calcite | Level 5

I am entering the following code:

 

libname mara "/folders/myfolders/sasuser.v94";
data work.atem;
set mara.atemwege;
run;

 

The dataset "atemwege" is saved in "/folders/myfolders/sasuser.v94"

 

When putting this code on a windows pc, it all works perfectly, but when i am trying it with sas university on a mac, it's showing "this table cannot be opened because it doesn't have columns" ... which is not true, since it has columns and works perfectly on windows.

 

Did anyone have this problem and knows how to solve it?

 

Thanks a lot!

7 REPLIES 7
JBailey
Barite | Level 11

Hi @Mara11

 

Was the file copied from your Windows environment to your Mac environment? If so, the file may be unreadable because the underlying OSes are different (Windows and UNIX). Check out PROC CPORT: it may help you.

 

Best wishes,

Jeff 

Mara11
Calcite | Level 5

HI @JBailey thanks for your answer!

 

No the data set was directly downloaded from my university servers to my mac. The prof gave me this data set basically.

 

Where exactly do I write "proc cport"?

 

Thanks again!

JBailey
Barite | Level 11

Hi @Mara11

 

You may want to ask your professor about this. I bet that someone there has seen this before.

 

Best wishes,

Jeff

Reeza
Super User
In SAS University the sasuser folder is locked down, you should be working in myfolders or create a folder under there for your work instead.

There are some differences in SAS UE from Windows PC SAS, but it has to do with the fact that it's running on a virtual machine. This means that ends up closer to working with SAS on a server than working on a desktop.

Mara11
Calcite | Level 5

Hi Reeza,

 

thanks for your answer! I already tried creating a sub folder, unfortunately i got the same error code 😞

Reeza
Super User

@Mara11 wrote:

Hi Reeza,

 

thanks for your answer! I already tried creating a sub folder, unfortunately i got the same error code 😞


Post that code and the error.

 

Assuming you put the data into myfolders, the shared folders you set up, the following should work. You can create subfolders under myfolders if desired as well.

 

libname mara "/folders/myfolders/";


data work.atem;
set mara.atemwege; *this assumes you put the data in the myfolders that you set up at installation;
run;
Reeza
Super User
If this continues to not work, please show a screenshot of the sas data set in myfolders, under the Servers Files and Folders pane.

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 7 replies
  • 1096 views
  • 0 likes
  • 3 in conversation