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.
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 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!
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.
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.
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/
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.
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!
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!
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).
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.
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/