BookmarkSubscribeRSS Feed
GUY65
Calcite | Level 5

Hello,

I'm a new user.

I've run a code, and the results gave me a table I want to work at in python.

the problem is, that I don't know who to export the table. I managed to export the code (which I don't need anymore).

is anyone knows how to export the table?

(screenshot is added)

 

Thanks a lot,

Guy

 

image.png

4 REPLIES 4
Reeza
Super User
Right click the data set in the libraries pane and select export and it will guide you through the process.
GUY65
Calcite | Level 5

I've tried to go through a guide on the internet but it seems that when I'm pressing the right button I'm getting a different result then it should.

How should I proceed from here?

I have already pressed "download file" but I'm getting the .sas which is not helpful.

 

 

image.png

mkeintz
PROC Star

@Reeza said to right-click the data set in LIBRARIES (lower left), but you instead are showing an attempt to right-click a file in "Server Files an Folders".  It's probably your program file, but your image covers it name.

 

The log will tell you in which library the data set is and the name of the data set you created.   Open libraries, find the library of interest, and inside that will be the data set you want.  Right click that.

--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------
Reeza
Super User

Click Libraries, Click Work, Click the dataset you want to export. Right click the data set with the name in your original screenshot.

 

EDIT:

Oh, there are restrictions on removing data from Wharton if that's what you're using by the way so verify your usage restrictions as well. That's also why I can't just offer a code solution. The program won't have access to your local drives so it's more complicated. You could export it to a file on your server and download it after though. Wharton may have restrictions on the download sizes as well. 

Screen Shot 2018-09-28 at 6.55.50 PM.png

 

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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
  • 4 replies
  • 1597 views
  • 0 likes
  • 3 in conversation