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
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 🙂
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.
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
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.
I believe that only works for SAS enterprise, not for UE. Tried and no joy.
Sam
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
The Export is available in SAS UE.
Great news!!
How would I then get the file, which is on a Flash drive in SAS format into the library?
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.