SAS Tutorial | Doing More with SAS Enterprise Guide: Tips and Advanced Techniques
Вставка
- Опубліковано 1 сер 2024
- In the SAS tutorial, Chris Hemedinger covers advanced Enterprise Guide tricks for importing data, building complex queries, controlling your process flow, copy files, task templates, ordered lists, automating your work, and more.
Content Outline
0:00:00 - Introduction
0:01:47 - About SAS Enterprise Guide
0:11:19 - Customizing your workspace
0:33:28 - Importing data like a pro
0:49:27 - Using the data viewer
1:00:42 - Sharing results to Microsoft Excel
1:20:05 - Using Projects and Process Flows
1:29:28 - Special tasks to copy files and data
1:45:53 - Doing more with the Query Builder
1:52:00 - SAS programming productivity
1:59:45 - Using Git with SAS Enterprise Guide
2:03:40 - Automating with scripts
2:13:09 - More SAS Enterprise Guide resources
Learn more about SAS Software
Getting Started with SAS Enterprise Guide (UA-cam playlist) - • SAS Tip | SAS Enterpri...
SAS Tutorial | Getting Started with SAS Enterprise Guide (Extended Version) - • SAS Tutorial | Getting...
Using SAS with Git (webinar) - communities.sas.com/t5/Ask-th...
Doing more with SAS Enterprise Guide automation - communities.sas.com/t5/SAS-Co...
Free SAS Online Training - www.sas.com/en_us/training/of...
Contact SAS® - www.sas.com/en_us/contact.geo...
SUBSCRIBE TO THE SAS USERS UA-cam CHANNEL #SASUsers #LearnSAS #SASGF
ua-cam.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/contact
SAS Customer Support ► support.sas.com
SAS Communities ► communities.sas.com
SAS Analytics Explorers ► explorers.sas.com
Facebook ► / sassoftware
Twitter ► / sassoftware
LinkedIn ► / sas
Blogs ► blogs.sas.com
RSS ►www.sas.com/rss - Наука та технологія
thanks SAS for this amazing video!!
Glad you enjoyed it!
We're so glad it was helpful!
Beautiful explanation! How can I request a value for a variable, via keyboard, without using the prompt? Create a form for typing, by command line?
Alexandre, thank you for your inquiry! We are checking on this for you!
Are you looking to script/automate SAS Enterprise Guide projects? Check the "Doing more with SAS Enterprise Guide automation" topic (linked in the description) on the SAS Support Communities for some script examples. You'll want to look at the automation model for "Parameter" objects, or use a Code object to assign a macro variable before your project runs.
How can I send data to Excel, but to an opened file (while I'm working on it) and to an especific range?
I used to work with DDE but I get errors when trying to do it With Enterprise Guide version...
Use Share (or Send to) Excel to send your current data to a new Excel session -- but this will not reuse a currently open Excel file or place in a specific range. The LIBNAME EXCEL or EXCELCS engines support writing to a range in a file -- PROC EXPORT and LIBNAME XLSX do not, as far as I know.
Great overview Chris! However, I am frustrated by the slowness of the export process (via dropdown menu shown ~1:17). I have a 1.3 million row dataset that I need to export as a .txt file so it can be shared externally. However, this export process takes longer than 45 minutes!?! Is there a way to compress the data within/before the export step..?
ps. I have fast fiber optic connection speeds, so that’s not the issue.
I suggest that you look at the Copy Files approach. Use SAS code (DATA step or PROC EXPORT to create your text file on the SAS session, then use Copy Files to download from SAS to your PC. This is shown around the 1:28:29 mark.
Thanks Chris. I apologize that I didn’t get that far in my first viewing. I appreciate how much content you cover in this video. The copy files task does appear to be what i need… however, i’m still having trouble with the far more basic task of saving my qry results to a sas library. I am obviously not much of a coder and rely on the gui interface… I am surprised that I cannot right click on my qry results and select a save wizard that will help me save the dataset somewhere so i can then use the copy files task.
I understand that its probably an assumed basic skill but it’s one that gui users dont have. I’ve looked in the online help documentation but dont see content written or video that teaches me how to save a data set to a sas folder. I have tried, unsuccessfully, to use libname statements to no avail… it really shouldn’t be this hard to save work!
not a complaint towards you at all, just late friday complaints. my apologies!
48:59 You mention that you have another video that does into detail on how to import several files simultaneously into SAS EG. Do you have a link please? :)
Great question! This is the video that goes into the detail 2.sas.com/60559OnzN
Please let us know if you have any other questions!
@@SASUsers Awesome, thanks! Great video!
You're welcome and thanks for tuning in!
Note that removing the informat from the INPUT statement did NOTHING. Because of the colon modifier used the width of the informat would already be ignored.
Thanks! Just was showing how to clean up and remove extra code a person might not want in there (vs autogenerated code).
Honestly, your blog post doesn't mention the "Read Data" anywhere....
We have several blog posts and videos that teach how to read data in SAS (text, Excel, and so on). If you want help with a specific type, let us know and we'll find you a resource. Perhaps start with this one: blogs.sas.com/content/sasdummy/2020/03/23/import-text-data-sas-enterprise-guide/