Converting my SAS document into an Excel Document

Reply
New Contributor
Posts: 4

Converting my SAS document into an Excel Document

Hi All,

 

Firstly thank you for taking the time out to read this. I have been given a set of data that is in sas7bdat format and I need to convert it over to an Excel document to run some Statistical analysis, as I am a complete beginning in SAS and have a mere 20 days to get all the relevant work done on it. So far I have set up the folders which can be seen in the screen shot. In the screenshot, you can see my VM and the path for SAS (unsure if this helps?). I have read through a few posts and I'm getting very lost. 

 

Before I export the data into Excel I would like to only select the entries that match the definition "CMCSA" under the column header "Symbol" and not the whole data set as it exceeds 4 Million rows (but only 5 columns)

 

Kind Regards

Sam


Capture 2.PNG
Super User
Posts: 19,171

Re: Converting my SAS document into an Excel Document

There are video's here:

http://support.sas.com/training/tutorial/

 

You can look at hte filtering video to select the records of interest.

 

To create an excel file look at an export task. 

 

FYI - SAS UE is not licensed for commercial usage. 

20 days is a lot of time to do an analysis in my world Smiley Happy

 

Someday you'll want to switch to programming, after the third time your boss comes to you and says, just change this one thing and re-run to get all the new results and it means re-doing everything. 

 

New Contributor
Posts: 4

Re: Converting my SAS document into an Excel Document

Hi Reeza,

 

Thank you for the fast response, yep aware of the licencing law, however, I'm fine though as it's not for commercial use it's for my final project. I still attend university and do not work, yet fingers crossed I pass.

 

I shall watch the videos, but in the meantime could someone explain or write the line of code I need, please?

 

Kind Regards

Sam

Super User
Posts: 19,171

Re: Converting my SAS document into an Excel Document

Use the point and click interface if you don't want to use SAS or program.

 

Right click the dataset and Export and select your file type.

New Contributor
Posts: 4

Re: Converting my SAS document into an Excel Document

I believe that only works for SAS enterprise, not for UE. Tried and no joy.

 

Sam

PROC Star
Posts: 7,437

Re: Converting my SAS document into an Excel Document

Interesting that they didn't include that in the UE menu.

 

A code work around would be to click on Utilities->SAS Program and enter code like the following:

 

proc export data=sashelp.class
            file='/folders/myfolders/class.xlsx'
            replace dbms=xlsx;
  sheet='Sheet1';
run;

Art, CEO, AnalystFinder.com

 

Super User
Posts: 19,171

Re: Converting my SAS document into an Excel Document

The Export is available in SAS UE.

 

Screen Shot 2017-03-08 at 5.35.03 PM.png

New Contributor
Posts: 4

Re: Converting my SAS document into an Excel Document

Great news!! 

 

How would I then get the file, which is on a Flash drive in SAS format into the library?

Super User
Posts: 19,171

Re: Converting my SAS document into an Excel Document

When you installed SAS UE you had to create a folder called myfolders, place the file in there and assign the library. You can assign the library by clicking on the cabinet (first icon in Libraries Pane) and following the instructions. 

 

 

Ask a Question
Discussion stats
  • 8 replies
  • 305 views
  • 1 like
  • 3 in conversation