SAS Tutorial | Getting Started with SAS Enterprise Guide (Extended Version)
Vložit
- čas přidán 3. 07. 2024
- SAS Enterprise Guide empowers SAS users of all backgrounds to analyze data and publish results in an intuitive interface. In this SAS tutorial, Luna Bozeman demonstrates how to use point-and-click tasks to access and query data, create custom reports and graphs and get tips on using the powerful program editor to write and submit SAS programs. Access the exercises in our Virtual Learning Environment link below. You’ll be prompted to log into your SAS profile or create one.
Content Outline
0:00:00 - Welcome
0:02:17 - Overview of how SAS Enterprise Guide works
0:06:43 - Find your SAS Enterprise Guide version
0:07:34 - Starting a project and creating multiple process flows
0:26:02 - Opening data from other folders
0:45:09 - Manipulate data in the Query Builder
0:57:56 - Joining Tables
1:12:49 - Tasks vs. Wizards
2:00:49 - Customizing Task Results: changing the output format
2:14:30 - Updating results
Learn more about SAS Software
SAS Enterprise Guide learning path -
support.sas.com/training/us/p...
Watch Writing a Basic SAS Program video -
video.sas.com/detail/videos/p...
SAS Enterprise Guide 8.2 Documentation
support.sas.com/en/software/e...
SUBSCRIBE TO THE SAS USERS CZcams CHANNEL #SASUsers #LearnSAS #SASGF
czcams.com/users/SASUsers?sub_...
ABOUT SAS
SAS is a trusted analytics powerhouse for organizations seeking immediate value from their data. A deep bench of analytics solutions and broad industry knowledge keep our customers coming back and feeling confident. With SAS®, you can discover insights from your data and make sense of it all. Identify what’s working and fix what isn’t. Make more intelligent decisions. And drive relevant change.
CONNECT WITH SAS
SAS ► www.sas.com
SAS Customer Support ► support.sas.com
SAS Communities ► communities.sas.com?.com&
SAS Analytics Explorers ► explorers.sas.com/en/home.htm...
Facebook ► / sassoftware
Twitter ► / sassoftware
LinkedIn ► / sas
Blogs ► blogs.sas.com
RSS ►www.sas.com/rss - Věda a technologie
Thank you for an excellent presentation, very nicely delivered by the host with the correct level of detail!
Our pleasure! We're glad you enjoyed it and hope you come back for more!
Absolutely fantastic
One of the best tutorials on CZcams, thank you so much!
Thanks for tuning in!
Thank you so much for Tutorial. Very help full.
You're welcome, Rajashekar! Thanks for letting us know it was helpful!
Many thanks for this tutorial!
Glad it was helpful!
Thank you very much for this nice tutorial!
You're welcome!
Thank you for all content, helped me a lot!
Thanks for tuning in!
Thanks alot, was very beneficial for me in work place.
Absolutely! Thanks for sharing, and we're glad you enjoyed it!
Thank you for this helpful tutorial
We're glad you enjoyed it and hope you come back for more!
thankyou very much, i'm a french-speaking person so english is a second language for me, nevertheless your explanations are so clear and easy to understand.
Thanks for sharing, and we're glad you enjoyed it! Hope you come back for more!
Thank you Very Much Madam
We're glad you enjoyed it!
Thank You so Much It also helpful for SAS eg 8.3 version
Excellent! Thank you for your feedback!
Thank you
We're glad you enjoyed it!
The content of this SAS tutorial is very good. Unfortunately, even the highest resolution is 720HD, but 90% of these fine text is still not readable. It would be much much better if you can upload the original video with 1080HD or higher!
Thank you for your feedback, Joey! Will you please tell us the timestamp(s) of the text you are trying to read, and also its name(s) or title(s)?
This is such a fantastic tutorial. Only issue I am having is that I cannot see the screen well as the resolution seems low.
Marieke, we appreciate your feedback, and we will be sure to share back to the presenter. We are glad you found the tutorial helpful!
Please note to make sure Quality of 720p is selected under the Settings menu (Gear icon on the playback bar) if you haven't already done so. It may still be hard to read some of the smallest details but most content is clear. Thanks again for your feedback!
Hey, may I know where can I get the data in the example? I want to do the exercise together. Thanks.
SAS Enterprise Guide includes dozens of sample data sets in the install, and SAS also ships with lots of sample data in SASHELP. However, the Orion Star data is provided with SAS courses -- tailored for each one -- so I don't think there is a download.
SAS: the company where almost every highly skilled instructor could, in dire times, go back to a prosperous modelling carreer.
is there any pdf file for enterprise guide study, I had a little sas book as ref for sas so how about the EG
Hi Ye! Here are some books that you might find helpful! 2.sas.com/60561Ngjg
How about Mixed models?
I am having trouble using the virtual learning environment. It is not letting me log in. Any help or suggestions?
Raj, sorry to hear you are experiencing issues. Please email us at SAS_Cares@sas.com or chat with us and elaborate on any error messages you are receiving. To chat live with a SAS representative, visit 2.sas.com/6058GHeTr
Still prefer the EG 7 series than the 8. 8 improved a lot in the design however the tabs are quite confusing.
Thanks for offering your feedback! Please submit feedback through SAS Idea Exchange: 2.sas.com/6051yOTS7. Additional info on customer feedback, here: 2.sas.com/6052yOTSC
Hi, Do you have similar tutorial videos on SAS Viya? It is preferred to have Viya 4 but I am ok to have tutorials on earlier version of Viya. Thanks a lot! Keep up the good work.
Absolutely! You can find them on the SAS Users CZcams channel and also here:
SAS Viya Quick Start 2.sas.com/6052e6LfE
SAS Viya playlist 2.sas.com/6053e6Lf1
how about if SAS EG is on the Grid environment, how to connect to SQL Server on remote boxes?
Checking on this for you!
Using EG in a Grid environment is outside the scope of this getting started tutorial. This kind of support question can't be answered in the CZcams feedback area without more information about your Grid environment, your SAS server, your SQL server and your EG configuration. This type of question is best handled by working with SAS Tech Support. To open a track with Tech Support, fill out the form at this link: 2.sas.com/6059JDPP5
Audio is good and clear but the video quality is very blurry even at 720p.
It would be useful to provide a publicly available dataset for viewers to follow along with the instructor
Hi! We're sorry to hear that! Will you please tell us specific sections or time-stamps from the video that are blurry for you so we can share those details with our Training team?
The data used in the video is Orion Star Data, which is used in our Programming courses and is available to download via our free SAS Programming 1: Essentials Course. Here's some more info that might help! 2.sas.com/6051yBBPL
@@SASUsers The whole video is blurry. Thank you for sharing the data link.
Happy to help! Thanks again for your feedback, we will share that with our Training team! 👍
Does SAS Studio have PROJECTS and PROCESS FLOW?
Check out this link! We think it will answer your question: 2.sas.com/6057KTvkJ
Where can does this orean stars data be found? Can any one help?
Ijaz, SAS Enterprise Guide includes dozens of sample data sets in the install, and SAS also ships with lots of sample data in SASHELP. However, the Orion Star data is provided with SAS courses.
Can you share the data used in the tutorial? Thanks!
Hi! Thanks for your question. SAS Enterprise Guide includes dozens of sample data sets in the install, and SAS also ships with lots of sample data in SASHELP. However, the Orion Star data is provided with SAS courses -- tailored for each one -- so there isn't a download.
where can i get the dataset used in this tutorial
Hi Ravi and thanks for your question. See response below in comments ~4 months ago, but also here:
Luna used the data that can be found in the SAS Enterprise Guide 1: Querying and Reporting (8.2) course. You can access the e-Learning version of this course in the free 7-day trial of SAS Learning Subscription. Click 2.sas.com/60583Devg for more information and to start your free trial. The SAS Enterprise Guide 1 course is in the Programming module, then scroll down to the SAS Enterprise Guide header. The first lesson of the course, Course Overview and Data Setup, provides instructions on how to create the data for your local copy of SAS Enterprise Guide.
When I describe data to obtain N and frequency how can I obtain total N at the end of my table?
Angels, thank you for your inquiry! We are checking on this for you!
@@SASUsers thank you! I meant the total frencuency and total percentage from the One way frequency table
Angels, after further review, we would recommend your inquiry to our technical support resources. Hi:
We cannot provide detailed Tech Support here in the CZcams feedback area. To send mail, you need to work with your Administrator to determine that the right startup options for emailing are sent. It also makes a difference what your email restrictions regarding the email format you are allowed to send. For example with HTML or Plain Text format for emails, you would usually have to attach the image as a separate file attachment. Some mail administrators restrict program-generated emails to Plain Text format, so all of your additional snapshots, images or reports would need to be sent as an attachment to the email. The SAS email engine allows an ATTACH= option so you can easily attach files to a mail.
To get more in-depth help, you can open a track with SAS Tech Support by filling out the form at this link: 2.sas.com/6055349z1 . Or you can post questions about email in the SAS Community Forums. Many times you'll find useful suggestions like this one: 2.sas.com/6050349zK about emailing in the Community Forums.
I have mainframe flat file, i want to map this file with copybook/layout. How to do that, please advise.
Sekhar, we are checking on this for you!
Your question falls outside the scope of the topics covered in this video. This video is intended to be an overview of using SAS Enterprise Guide and point and click techniques. However, there are some resources related to your question on the 2.sas.com/6058G29Zm site that you might find useful. When you mention a copybook, you might mean a COBOL copybook. Do you have SAS Data Integration Studio where you work? If so, this documentation link will help you with your goal: 2.sas.com/6059G29ZW .
If you do not have SAS Data Integration Studio, then you will probably need to write your own DATA step program using INFILE and INPUT statements to read the mainframe file. Does your Enterprise Guide installation connect to your mainframe? In addition to using Enterprise Guide for point and click tasks, you can write your own programs using the editor in Enterprise Guide. Or are you using some other interface to run your SAS programs against mainframe files? The interface you're using will have an impact on how you access the file.
Depending on whether you have the mainframe file in EBCDIC or ASCII format and where it's located, you may be able to read it on the mainframe using SAS or you may have to FTP it to a server where SAS can read it. And, you'll have to pay attention to the informats you use, especially if the mainframe file has signed, packed data. Here are some links that you might find useful:
2.sas.com/6050G29Zo
2.sas.com/6051G29ZU
2.sas.com/6052G29Zq
2.sas.com/6053G29ZS
2.sas.com/6054G29Zs
This is the type of question that is best handled by working with SAS Tech Support. You can open a track with Tech Support by filling out this form: 2.sas.com/6055G29Zt.
@@SASUsers Thank you for sharing the information. Let me learn from the links.
Sounds good! You are welcome!
What about people don't have windows? How can I use Enterprise Guide in a macbook?
Thank you for your inquiry! We are researching this for you!
EM, SAS Enterprise Guide is typically used in a corporate setting under a corporate license. Most of our corporate customers either provide a Windows machine with Enterprise Guide for their employees, or they have the employees use remote desktop from their Mac to connect to a Windows machine that has Enterprise Guide. If you partition your Mac so that you have Bootcamp or Parallels or some other type of partitioning software, you can put Windows into that partition and then install Enterprise Guide in the Windows partition. However, you'd want to check with your company first because it might be more cost effective for them to provide you with a Windows machine and Enterprise Guide than to pay for a Windows license and partition your Mac in order to install Enterprise Guide in the partition. If you are working in a corporate setting, you might ask your SAS Administrator how other users with Macs use Enterprise Guide. On the other hand, if you are a student or working independently, then instead of Enterprise Guide, we would recommend that you use SAS Studio to learn SAS. Independent users cannot get a stand-alone Enterprise Guide license, since it is part of a corporate license. On the other hand, we provide free access to SAS Studio on our SAS OnDemand server for non-commercial learning purposes. Here's a video about Getting Started with SAS OnDemand for Academics and SAS Studio: 2.sas.com/6059KbnsH . Our JMP subsidiary has a statistical analysis product that works natively on a Macintosh, which you can read about here: 2.sas.com/6050Kbnsy .
I do not have the training files. Where can I get them?
Hi Melissa.
SAS Enterprise Guide includes dozens of sample data sets in the install, and SAS also ships with lots of sample data in SASHELP. However, the Orion Star data is provided and tailored to each specific course. Please let us know if you have any additional questions.
@@SASUsers I'm taking this course in CZcams. My organization does not provide any of the sample data sets on their servers and I don't have SAS on my local drive, only access to the server via Enterprise Guide. So am I correct that I cannot take this course then?
All data for your courses is supplied during the Course Data setup section at the start of the course. You would be able to access it for the course. This specific video is simply a tutorial.
where can i get the slides?
Slides are not available for this video. However, it may be helpful to know Luna used the data that can be found in the SAS Enterprise Guide 1: Querying and Reporting (8.2) course. The SAS Enterprise Guide 1 course is in the Programming module, then scroll down to the SAS Enterprise Guide header. The first lesson of the course, Course Overview and Data Setup, provides instructions on how to create the data for your local copy of SAS Enterprise Guide.
Is it possible to share those data files?
Hi there! We'll look into this for you and get back to you! 👍
Hi Ferdi! Can you email us at SAS_Cares@sas.com? We can send you the information that we got from the video presenter. Thanks!
Where can i find the samples data sets that your importing?
Thank you for inquiry! We are checking on this for you!
Luna used the data that can be found in the SAS Enterprise Guide 1: Querying and Reporting (8.2) course. You can access the e-Learning version of this course in the free 30-day trial of SAS Learning Subscription. Click 2.sas.com/60583Devg for more information and to start your free trial. The SAS Enterprise Guide 1 course is in the Programming module, then scroll down to the SAS Enterprise Guide header. The first lesson of the course, Course Overview and Data Setup, provides instructions on how to create the data for your local copy of SAS Enterprise Guide.
It's too old, and not sure anyone is going to see this comment, but it's an okay presentation to introduce SG. It seems you have seen 'Office Spece" one too many times; it's really annoying "go ahead" in every sentence.
Full SAS Sessions :-
czcams.com/play/PLCmzhzAgjyBwafMtp7Fm7ZJj1oiwn1U5V.html
Listen lady, talk to your superiors and tell them your ads are literal 4ids, do you not have a marketing team?