03-08-2017 05:37 PM
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)
03-08-2017 05:53 PM
There are video's here:
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
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.
03-08-2017 06:00 PM
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?
03-08-2017 06:10 PM
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.
03-08-2017 07:19 PM
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
03-08-2017 08:11 PM
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.