This is very good. I have great access to sas training since my firm is a partner, but i must say that getting properly started with sas basic programming has been hard, so these vidoe helps. i dont think the learning video on the website are as good as these ones..
Happy to hear it and glad you found what you needed! As you can see, there's a ton of tutorials to help with SAS and another handy resource is SAS Communities 2.sas.com/6058PxINQ where experts are on hand to help!
Hi Sivaram, we're so glad you enjoyed the content! Here are a few tutorials on creating a stored process that may be helpful: video.sas.com/detail/video/3728492615001/get-started-using-a-stored-process, video.sas.com/detail/video/3772834810001/create-a-stored-process-from-an-existing-sas-program, and video.sas.com/detail/video/3765242523001/create-a-stored-process-from-a-process-flow
Actually, if you are renaming just one variable, the RENAME clause does not require parentheses, i.e.: (rename=(park=statepark)) can be coded as just: (rename=park=statepark) If you are renaming more than one variable, the parentheses around the clause are a must. Best Paul Dorfman
Good day! For the information of everyone it would be my first time to use SAS 9.4 but this time my question is, Is it possible for me to import data let say 67 Variables in columns and 900,000 data in rows. Thank you very much.
Thanks for this useful tutorial. Trying to apply both procedures on small fictitious EXCEL datasets I realize that, when the last observation has a missing value for the last variable, this last observation is correctly taken into account by PROC IMPORT but is not included in the dataset when the LIBNAME way is taken. How to cope with this problem? Thanks in advance.
Joel, We are not able to duplicate your issue. When we have a missing value for the last column in the last row of the Excel worksheet, SAS picks it up just fine using the LIBNAME statement. libname test xlsx 'c:\demo p_infoMissing.xlsx'; proc print data=test.visits; run; If you are still experiencing issues, we recommend that you share your data and your code by opening up a technical support track by email support@sas.com
Thanks for the tip, Akhil! We've got lots of other great resources to help you get ready for that exam: Training & Exam Prep details for Our Base Programming Specialist Exam 2.sas.com/6054JKpnG This article from our #SAS Communities Library: "Tips and Strategies for the A00-231 SAS Base Programming Performance-Based Certification Exam" 2.sas.com/6056JKpny All the information on our Base Programming Specialist page, especially the two #SASTraining courses and the links under "Additional Training Tools" 2.sas.com/6057JKpnJ Our #SASCertification Community: 2.sas.com/6058JKpnK Many more Certification videos & tutorials from SASUsers CZcams: 2.sas.com/6059JKpnz
Hello ! I have a question please 😊: Is it possible to import an excel template that have formulas inside into sas and not reading the values resukting if the formula as its done automatically ?
Due to the limit in space/chars here, we'd recommend posting programming/content related questions to the SAS Communities where SAS experts are on hand to help: 2.sas.com/6059OflDc
Yes you can import single sheets from a workbook; or you can import multiple sheets. SAS treats the workbook like a library and each sheet in the workbook like a data table. We cover concepts and examples like this in our free Programming 1 class.
Hi there! I found this video very helpful, but I am coming across an issue and I think I am missing a step. When the demonstrator puts in "x" from that file and all the data is already there, mine does not have the data in there. Is there a step that can be explained on how to get it there or can you direct me to a video that will help? Thank you in advance!
Hi, Alexandra! I am not sure how you are practicing with SAS. But in any case, you will not automatically have the files used by this instructor. However, the good news is that you can get the same data that the instructor is demoing. In the video, the instructor is using data from our Programming 1 class, which is free as self-paced e-learning. You would need to activate the Programming 1 class and do the setup to make the class data before you would be able to replicate the steps that are illustrated in this video. Activating Programming 1 is easy -- you'll just need to have a SAS Profile. The web site here: 2.sas.com/6050JuyH0 has a big orange "Start Now" button so you can activate the Programming 1 class. Just be sure to log onto your SAS Profile as part of the activation code process. If you are using our free SAS OnDemand for Academics server to practice, then we have instructions inside the Course Overview and Data Setup section of the class for how to make the class data on the OnDemand server. And we have some demos in practices in the Programming 1 class that have you work with the np_info.xlsx file. So when you activate Programming 1, you'll have the data used in this video and you'll have ALL the data used in the class so you can practice. I hope this helps! 🙂
Thanks for your question. Once you import the Excel sheet into SAS data set format, the data is now in SAS proprietary format and not in an Excel sheet anymore. SAS data does not have color settings or font settings. So there is NOT any way for you to set colors and fonts in the SAS data set itself. If you remember from Programming 1 and Programming 2 and a description of how SAS data is stored, you'll remember that SAS data has attributes for each variable or column like length, type, format, label; however, there are NOT any attribute settings for colors in a SAS dataset. When you run PROC CONTENTS to look at the information about the SAS data table, you do NOT see any color or font settings in a SAS data set or data table. However, if you create a REPORT with SAS, such as you might create using the Output Delivery System, then your output report can have color and font changes. ODS has many destinations, such as HTML, RTF, PDF, and EXCEL and you can change colors and fonts in these output files generally using STYLE= overrides. But, the creation of an output report is not related to how you import the a sheet FROM Excel INTO SAS data table format. Here's a posting in the SAS Community Forums that shows how to use ODS STYLE= overrides to change the color of cells using PROC REPORT and ODS EXCEL: 2.sas.com/6057Zg6Nz and here's a more recent example in a Community Forum article: 2.sas.com/6058Zg6NM . This CZcams feedback area does not allow us to post code or screen shots or provide you with extensive Tech Support for your question. If you need additional help, we recommend that you either open a case with SAS Tech Support or post your question in the SAS Community Forums, here: 2.sas.com/6059Zg6N3 in the ODS and Reporting Forum.
Hi excellent and shortest. I got exactly the same information after running the version code. I got X lib successfully and the first part of the proc contents and lib X empty. When I look at your folder, I can see the c: / and know idea how one can see that on your sever folder. Nobody's has C:/. What is my problem?
The C: drive visible in the narrator's SAS Studio browser means that she is using a local copy of SAS with SAS Studio as her front-end interface. If you notice, she is looking at the Files and Folders pane in SAS Studio. If you are using SAS Studio with a server copy of SAS, that same navigation pane might be called Server Files and Folders. Unfortunately, we cannot provide in-depth Tech Support in this CZcams feedback area. One reason that your library might be empty is that you do not have an Excel workbook to open or you might be using SAS Studio with a server copy of SAS, in which case the location you use for your LIBNAME statement would need to be a server location. If you want to practice learning how to use the XLSX Libname engine, that is a major topic in our free Programming 1 course. In the course, we provide XLSX files for the student to import and we provide starter code to help you learn how to import the XLSX files. If you go to this website 2.sas.com/6050Jf6ms, you'll only need to have a SAS Profile in order to activate the free Programming 1 course. Look under the e-learning section at the bottom of the page in order to click to activate the course.
Please teach me,I have 4 sheets in excel,1 is working sheet,some 3 are data sheets,So im copying each data from each sheets and them paste it to working sheet. So now,i wanna use sas by click just 1 button and the result be altogether in 1 sheet and then with final report together.
Hi Darshii, We cannot post code or screenshots here in the CZcams feedback area, and we can't review your code or provide Technical Support in this feedback area. How to use SAS and the XLSX Libname engine to import and export files is one of the major topics in our free Programming 1 course. It sounds like you need to import all of your individual sheets into one SAS data set and then export that dataset back into an Excel workbook as one sheet. This is possible with SAS, but it will involve writing some fairly simple code, not just "clicking 1 button". I highly recommend that you take our Programming 1 course, which you'll find here: 2.sas.com/60573HIR7 . Another resource for you would be to post in the SAS Programming forum here: 2.sas.com/60503HIr6 in the SAS Communities and ask for suggestions there for how to accomplish your task. If you are using SAS through your work license, then you could also open a track with SAS Technical Support. You will need to provide Tech Support with a sample of your data and your code and provide your site license number in order to open a track. To open a track with Tech Support, fill out the form at this link: 2.sas.com/60513HIrB .
Great Video Very Helpful. Actually in sas 9.4 By using LIBNAME XLSX STATEMENT DATASETS ARE PREPARED BUT THESE ARE NOT OPENING. ITS SHOWS SOME ERROR. HOW CAN WE OPEN THESE DATASETS.
Hello, Srinu - thanks for your positive feedback! We're sorry you're having trouble, and we're happy to help! Please let us know: 1) the complete error message you are getting. 2) specific details about what you are doing before getting the error. 3) the timestamp range (beginning & ending times) from the video for what you are trying to do.
I cant see these excel tables(parks, species visits) in the library i created, it shows in the log that its successfully created but when i see on the libraries panel its blank...... please help....
Sahas, Be sure that you have the fully-qualified path name of the Excel workbook, including the Excel extension in your LIBNAME statement. For example, if the workbook is in your EPG1V2/data folder and you are using SAS OnDemand for Academics, the LIBNAME would look like this: libname x xlsx '/home/your-SASODA-id/EPG1V2/data/np_info.xlsx'; It is difficult to troubleshoot your issue without seeing your program and knowing the full path of your Excel workbook. Please send email to curriculumconsulting@sas.com so we can better assist you.
Hello! Thank you for the lesson. I have a quick question regarding the sheet statement. How do you import a sheet that has spaces in between the words/letters? TIA
Hi Bunty! Without seeing ALL of your code and the exact type of Excel file (xlsb, xls, xlsx, etc) you are using, there is not just a single answer. IF you are using PROC IMPORT and IF you have an XLSX file and IF you are using DBMS=XLSX in the PROC IMPORT code, then your sheet name with spaces would be specified as: sheet='Name With Space'; IF you have an XLSX file, then you can ALWAYS use the XLSX Libname engine to see what the sheet names are, as shown at time stamp 1:51 in the video. And, if you look at time stamp 4:01 in the video, then you can see the PROC CONTENTS code that you can use to see exactly what sheets are in the Excel .xlsx file. However for other DBMS= options or other types of Excel files, you would need to work with Tech Support or read the documentation to answer this question of how you specify the sheet name for your Excel file. Hope that helps!
When I do the first step, the program runs and doesn't show any errors but for some reason it does not actually upload the excel file. Can anyone help? I am using SAS on demand. Thanks!
Hello Liza, thank you for your inquiry! In this CZcams video, the instructor is using SAS Studio on her local C: drive. So she is using a version of SAS Studio that allows her to read directly from her C: drive. The code that she is illustrating is not automatically uploading the Excel file. Since the Excel file is on her C: drive and since SAS is on her C: drive, the Excel file in this video does NOT need to be uploaded prior to the import step. However, when you use SAS OnDemand for Academics, SAS is on a Linux server on our platform. SAS Studio, when it is pointed to SAS on the SAS OnDemand server, CANNOT read from your local C: drive. PROC IMPORT and the XLSX Libname engine do NOT automatically upload any files from your C: drive onto the OnDemand server. You must manually upload the XLSX file from your local machine into the home directory on your SAS OnDemand account. Our Programming 1 class has several lectures and practices on how to write PROC IMPORT or use the XLSX engine to read your Excel files, so that would be one good resource for you. Another good resource would be this other CZcams video 2.sas.com/6059Mipkb which talks about getting started using SAS OnDemand for Academics. In the video, the narrator shows how to do an upload starting at time stamp 3:10 in order to make a new folder prior to doing the upload, then the video continues and shows how to change the path in code from a C: drive location to a OnDemand server location starting at time stamp 06:00. We cannot post code or screen shots in this feedback area or look at your code or screen shots. If you feel you need more in-depth help, we encourage you to post your question in the SAS Community that has been set up for SAS OnDemand users, here: 2.sas.com/6051Mipkd . The advantage of posting in the SAS Community Forums is that you can post the code you've submitted and the error message you're seeing and other users of the SAS OnDemand interface can help you.
This is helpful. To clarify, can you specify the location on your computer of your excel file that you were trying to import? I’m asking because I’m getting stopped at the very early step of proc print. I have an H drive, but my institute doesn’t provide me access to a C drive. When I run proc print, I receive a warning: “ERROR: file WORK.cyhy.data does not exist”. Meanwhile, libname and proc contents worked fine.
Harry, after further researching, it is not possible for us to examine your code or your log in this feedback area. We can't post code here or screen shots and we can't collect your usage information. On our classroom machine, we have a mapped S: drive and a location like S:\workshop\testfile.xlsx works for us to import an Excel file or use it with PROC CONTENTS and the LIBNAME XLSX engine. However, without looking at ALL of your code and your SAS log and understanding what type of system you are running your code on this is not the type of debugging we can help you with. your best resource for a question like this and for help with debugging your issue is for you to open a track with SAS Tech Support. To open a track with Tech Support, fill out the form at this link: 2.sas.com/6056Jc0M6 .
If possible could you help us about use of SAS on demand for academics (SAS ODA) ? We ask to analyze my PHD student data in SAS ODA. We used GLIMMIX in SAS script. Is it possible to use GLIMMIX in SAS ODA. If possible could write how can call data from excel and do analyz via GLIMMIX in SAS ODA. Thank you so much.
Here is the support page for SAS OnDemand for Academics: 2.sas.com/6052JDkuG . •This is the FAQs for SAS OnDemand for Academics: 2.sas.com/6053JDkuH . •Getting Started with SAS OnDemand for Academics video: 2.sas.com/6054JDkuy . SAS OnDemand for Academics uses a custom version of SAS/STAT software that supports PROC GLMMIX. You must upload your Excel workbook into your SAS Studio session within SAS OnDemand for Academics. Submit your LIBNAME statement to the workbook and use the libref.worksheet name in your PROC GLIMMIX. Here is an example that uses the class.xlsx workbook, which contains a sheet named class_teachers. libname myx xlsx '/home/your-userid/your-folder/class.xlsx'; proc glimmix data=myx.class_teachers; class ... model ... ; run; To find the path of your uploaded Excel workbook for the LIBNAME statement, right-click the Excel workbook and select Properties. You will see the full path in the Location field.
When you import an Excel file into SAS there are many factors that could affect the import, including but not limited to: the EXACT code you used, any error messages in the log, the version of the Excel file you were trying to import, your version of SAS, your installed SAS/Access products, your operating system and whether your version of SAS and your version of Microsoft office are compatible. To debug your problem requires more in-depth investigation. A CZcams comment area is not the place to collect or respond to this type of information. We recommend that you open a track with Tech Support by filling out this form: 2.sas.com/60561qmm0 . Tech Support can work with you and look at all your code, all your system specifications and all your data and provide you with in-depth help.
Hi again, Lakkimsetty, and thank you for your question about importing an Excel file from SharePoint into SAS! We found some resources that might be helpful: 1) This SAS communities post: "Reading an Excel file from Sharepoint/Intranet with a URL address - how?" 2.sas.com/6050GASm8 *NOTE: the link to listserv.uga.edu from the first reply does not work. 2) This SAS Blog post "Using SAS with Microsoft 365 (OneDrive, Teams, and SharePoint)" 2.sas.com/6052GASmE And, as always, you can post your own question to our SAS Community: "How to get fast, helpful answers" 2.sas.com/6053GASm1 Please let us know if we can help you with anything else!
We're sorry you're having trouble, Susan, and we're happy to help! As it seems you noticed, Kathy is using SAS Studio as her SAS interface in this video, and not SAS Enterprise Guide. Base SAS runs the code for both interfaces, so it should work in either of them. For the first method Kathy shows, using the LIBNAME statement, she mentions (at 1:55) that you need to have Base SAS 9.4M2 or newer for it to work. SAS Enterprise Guide 7.1 was released after 9.4M2, but it's still possible to run it on an older maintenance release or version of SAS, so you may not have 9.4M2 (or newer), which means that method won't work. To determine the version of SAS you have, please follow the steps described by Kathy starting at 2:10. The second method, PROC IMPORT, which Kathy explains starting at 8:45, should also work with SAS Enterprise Guide 7.1. If this information doesn't help, please let us know more details about what is happening for you, such as: 1) What version of SAS are you running? 2) Which method are you trying that isn't working? 3) At what point in the process is it not working, and how? A) Are you getting an error message? B) At what point in the process are you getting the message? Thanks!
Hi, When i added the excel file in my SAS studio, i was not able to see different sheets in my excel under the library X Can you please help me with that why this is happening?
We would like to refer this to the next level of support by opening a technical support track. Would you like for me to open a track for you? For immediate assistance from Technical Support, you can call 800-727-0025, option 2. In the meantime, click here 2.sas.com/6052GUu0p to learn how SAS Support Communities can expedite your tech support experience. Also, for the most up-to-date SAS tips and how-to’s, be sure to subscribe to the SAS Tech Report 2.sas.com/6053GUu0V.
Hi Kathy.. thanks for the video.. I am facing one issue. I used code: Proc export data=sashelp.class Outfile='path\test.xlsx' Dbms =xlsx replace; Run; I got the following error: /sasconfig/lev1/servercontext_template/path. Make sure the path name is correct and that you have write permission. And I have all the access to the folder .I can write create and delete files in the path folder. Can you please help me to resolve the issue? Thanks
Hello, Ruhan! As you may have noticed, this video is about importing data from Excel to SAS, with one of the options being PROC IMPORT. From the code you shared, it looks like you are trying to export data with PROC EXPORT, so we suggest you view Kathy's video on that topic, "SAS Tutorial | How to export SAS data to Excel". The PROC EXPORT part of that video starts here at the 12:29 timestamp 2.sas.com/6056GEjqM We see your OUTFILE= argument does not seem to be a complete path and filename for the output file, as specified in our PROC EXPORT documentation on the OUTFILE="filename" argument, which you can find here 2.sas.com/6057GEjq3 For example, the OUTFILE= argument from the PROC EXPORT part of Kathy's video (link above) is: outfile='c:\demo\cars.xlsx' Please let us know if this helps, or if you have any other questions for us!
Thanks for the nice tutorial. However, if I follow the same steps as until minute 5, trying to print the data I uploaded, it gives an error. I also see that although I used X the same as you proposed, the sheet of my Excel file is not represented in the Library folder X... Could somebody please assist me. my code: libname x xlsx 'C:\Users\STOFFKX1\Documents\MITRACLIP\SAS\SAS_GermanAnalysis.xlsx'; proc contents data=x._all_ nods; run; proc print data=x.Variables; run; my error: ERROR: File X.Variables.DATA does not exist. (Variables is a sheet in my Excel file.) Tx in advance!
Thank you for your question, Karen. We're sorry you're having trouble, and we're happy to help! Please send an email to SAS_Cares@sas.com with your SAS site number, your answers to the questions below, and any other details you have about the error you are getting. 1) Does your LOG show "Libref X was successfully assigned as follows" (as shown in the video at 1:29-1:55)? If not, what does the LOG show? 2) If the Libref X was not successfully assigned, please run the %put macro (as shown at 1:58-3:20), and let us know the version of SAS you have. 3) Do your RESULTS for your PROC CONTENTS Statement show Variables as one of the sheet names in X (as shown at 4:01-4:19)? Thanks!
@@SASUsers in the video when used libname statement, i see a variable in the dataset created from the excel where variable is “park Type” where there is a space, how do we ready that variable for manipulation?
Thanks for the clarification, Pathuri. The Excel file demonstrated in this video is named np_info.xlsx and this is the same file that we use in the free Programming 1 e-learning class. In the class, we show you how to import this file from Excel into a SAS dataset. The PARKTYPE variable in the data is used to specify a category for each of the parks contained in the file. For example, Bandelier park in New Mexico has a PARKTYPE value of "National Monument" but, the Bering Land Bridge has a PARKTYPE value of "National Preserve". These PARKTYPE values for the National Park data are based on the actual values in the National Park data that is downloadable from US government web sites. If you want to see how we use this data in our programs, then you can activate the free Programming 1 class. Inside the class, we provide you with a program that makes ALL the data including the np_info.xlsx file, so you can use the data in your programs. Here's the web page for Programming 1 2.sas.com/6055O3Adv -- just scroll down to the self-paced e-learning section and click the Start link to sign on and activate the class.
Currently, SAS 9.4M8 is available. A maintenance release is a collection of updates to SAS products or components that corrects customer-reported issues and adapts the product to a changed environment. A maintenance release can also include new software functionality. We recommend applying releases that relate to your current environment: 2.sas.com/6058jBs7j
How are you using SAS Studio? If you are using SAS OnDemand or SAS University Edition, you must use those path names, not your C: drive. Right-click the Excel file and select Properties to see the full file path. If you need more assistance, please send an email to curriculumconsulting@sas.com.
@@kathykiraly3830 Yes, I was able to figure this out myself, but your video is very misleading since you use SAS Studio on your local machine, not the online version, even though they look the same. I have noticed that a lot of people have the same problem with connecting to C drive while using SAS Studio On-Demand, yet it's not addressed anywhere on your website.
@@Reinheit SAS Studio is available locally, in SAS OnDemand for Academics, and in SAS University Edition. If you are using SAS OnDemand, which is server-based, you must upload your files to the server to access them. Then you must you the SAS OnDemand path name. This is noted on the SAS OnDemand support page: support.sas.com/ondemand/manuals/UploadingDataUsers.pdf.
Alvin, Yes you can import single sheets from a workbook; or you can import multiple sheets. SAS treats the workbook like a library and each sheet in the workbook like a data table. We cover concepts and examples like this in our free Programming 1 class.
If you would like #SASusers to look over your code, we would suggest you share questions like this within SAS Communities! This is a great place to ask for users inputs 2.sas.com/6051G8ZlP
Lakkimsetty, Thank you for your inquiry! Some LIBNAME engines can only be used on Windows or Unix systems, so if you want to use a LIBNAME engine method, such as illustrated in this video, you'll need to work with Tech Support to determine whether that capability is available under your licensed software on the mainframe. To open a track with Tech Support, you can fill out the form, here: 2.sas.com/60591WAet . However, the quickest way to import an Excel file onto your mainframe system is to save the Excel file as a comma-separated value file on your Windows machine and then write the CSV file to a drive accessible to the mainframe or FTP the file to the mainframe so you can read it with either a DATA step program or with PROC IMPORT.
This type of question is more appropriate for Tech Support working with you once they know what is on your license. They will need to look at your license for the mainframe and help you figure out what types of files you can import, based on the SAS/Access products you have installed and what type of files you need to import into SAS on the mainframe and where the files to be imported are stored. These are all questions that cannot be asked, or investigated in a forum like this. We can open a track for you if you would like or you can email support directly at support@sas.com Please review information required to open a track 2.sas.com/60501oO0e
Hi Ayele, the data used in this how-to video is from our Programming 1 class, which is a free class as e-learning for any independent learner. If you have set up a SAS Profile, you can activate the Programming 1 class from this website: 2.sas.com/6050M7lEo and the instructions for setting up the data are in the Course Overview and Data Setup section for the course.
Fuad, thank you for your inquiry and sorry to hear you are having some issues! If you have a usage question, we would recommend SAS communities or you can view some of our other free e-learning courses and tutorials. We also offer technical support for site license holders should have any technical questions. You can learn more about these resources and more by registering for our SAS Starter Kit 2.sas.com/6054Kv50C
SAS Communities would be your best resource for asking specific usage questions where other users can look over and provide feedback. Here are some tips to get you started 2.sas.com/6055Kvggl
THIS CODE SAID "THE PHYSICAL FILE DOES NOT EXIST" HERE IS THE CODE; proc import datafile='H:\MPNURSAS.xlsx' dbms=xlsx out=work.SASPENS; sheet=SASPENS; run; The excel workbook is in the root directory of H:
You must use the fully-qualified path name of the Excel workbook in the DATADFILE= option. The surest and easiest way to find the path is to right-click the Excel workbook and select Properties. You will see the full path in the Location field. If you continue to have problems, please send email to curriculumconsulting@sas.com and include the following: 1.) a screen shot of your SAS code from the SAS log and 2.) a screen shot of your Properties window for the Excel workbook.
This is very good. I have great access to sas training since my firm is a partner, but i must say that getting properly started with sas basic programming has been hard, so these vidoe helps. i dont think the learning video on the website are as good as these ones..
You are the best , easy, fast and straight forward , I wish you would make more videos
Fatemeh, thank you for the feedback and glad you find these helpful!
A very effective teacher.
Very good Tutorial l learn the Task performing Data from excel to SAS.
Glad it was helpful!
Thanks for posting this, I encoutered a quesiton today on excel, sheets.
Thanks for the feedback! So glad it was helpful!
The video was helpful. I appreciate!
So glad you enjoyed it!
I believe this session it will help me a lot in my future project.
Alvin, that is awesome! Glad you found it helpful!
Scoured the internet to find my solution here! TYSM
Happy to hear it and glad you found what you needed! As you can see, there's a ton of tutorials to help with SAS and another handy resource is SAS Communities 2.sas.com/6058PxINQ where experts are on hand to help!
This was super helpful, please do more!
Thanks for sharing! We're glad you enjoyed the content!
Thanks
very good and very clearly explained video. Best regareds
Hello , These videos are great and detailed. Could you please do one for SAS stored Process with good example ?
Hi Sivaram, we're so glad you enjoyed the content! Here are a few tutorials on creating a stored process that may be helpful: video.sas.com/detail/video/3728492615001/get-started-using-a-stored-process, video.sas.com/detail/video/3772834810001/create-a-stored-process-from-an-existing-sas-program, and video.sas.com/detail/video/3765242523001/create-a-stored-process-from-a-process-flow
Thank you very much.🇿🇦
You are very welcome!
Great video ,I have enjoyed this SAS video.Thank you ........
Thanks so much for sharing! Keep tuning in for more, and we appreciate your feedback!
@@SASUsers definitely i will keep in .
Actually, if you are renaming just one variable, the RENAME clause does not require parentheses, i.e.:
(rename=(park=statepark))
can be coded as just:
(rename=park=statepark)
If you are renaming more than one variable, the parentheses around the clause are a must.
Best
Paul Dorfman
Excellent tutorial.
Thanks for your feedback! Glad you found it helpful!
This is very nice.Thanks for posting.
Glad you enjoyed it!
Good day!
For the information of everyone it would be my first time to use SAS 9.4 but this time my question is, Is it possible for me to import data let say 67 Variables in columns and 900,000 data in rows.
Thank you very much.
Very helpful!
Awesome! Thank you for sharing the feedback! 👍
Thanks for this useful tutorial. Trying to apply both procedures on small fictitious EXCEL datasets I realize that, when the last observation has a missing value for the last variable, this last observation is correctly taken into account by PROC IMPORT but is not included in the dataset when the LIBNAME way is taken. How to cope with this problem? Thanks in advance.
You are most welcome! We are looking into this for you and will follow up!
Joel, We are not able to duplicate your issue. When we have a missing value for the last column in the last row of the Excel worksheet, SAS picks it up just fine using the LIBNAME statement.
libname test xlsx 'c:\demo
p_infoMissing.xlsx';
proc print data=test.visits;
run;
If you are still experiencing issues, we recommend that you share your data and your code by opening up a technical support track by email support@sas.com
Guys no matter How confident you are on your skills watch this Vedio again before appearing base Certification.
Thanks for the tip, Akhil!
We've got lots of other great resources to help you get ready for that exam:
Training & Exam Prep details for Our Base Programming Specialist Exam 2.sas.com/6054JKpnG
This article from our #SAS Communities Library: "Tips and Strategies for the A00-231 SAS Base Programming Performance-Based Certification Exam" 2.sas.com/6056JKpny
All the information on our Base Programming Specialist page, especially the two #SASTraining courses and the links under "Additional Training Tools" 2.sas.com/6057JKpnJ
Our #SASCertification Community: 2.sas.com/6058JKpnK
Many more Certification videos & tutorials from SASUsers CZcams: 2.sas.com/6059JKpnz
Hello ! I have a question please 😊:
Is it possible to import an excel template that have formulas inside into sas and not reading the values resukting if the formula as its done automatically ?
Due to the limit in space/chars here, we'd recommend posting programming/content related questions to the SAS Communities where SAS experts are on hand to help: 2.sas.com/6059OflDc
I just want to ask if im going to import data in sas from excel, is it possible for me to import data whether i have only one sheet in one workbook?
Alvin, thanks for your inquiry! We are checking on this for you!
Yes you can import single sheets from a workbook; or you can import multiple sheets. SAS treats the workbook like a library and each sheet in the workbook like a data table. We cover concepts and examples like this in our free Programming 1 class.
@@SASUsers do you have a video on this because everything works for me until proc print
Hi there! I found this video very helpful, but I am coming across an issue and I think I am missing a step. When the demonstrator puts in "x" from that file and all the data is already there, mine does not have the data in there. Is there a step that can be explained on how to get it there or can you direct me to a video that will help? Thank you in advance!
Checking on this for you!
Hi, Alexandra! I am not sure how you are practicing with SAS. But in any case, you will not automatically have the files used by this instructor. However, the good news is that you can get the same data that the instructor is demoing. In the video, the instructor is using data from our Programming 1 class, which is free as self-paced e-learning.
You would need to activate the Programming 1 class and do the setup to make the class data before you would be able to replicate the steps that are illustrated in this video. Activating Programming 1 is easy -- you'll just need to have a SAS Profile. The web site here: 2.sas.com/6050JuyH0 has a big orange "Start Now" button so you can activate the Programming 1 class. Just be sure to log onto your SAS Profile as part of the activation code process. If you are using our free SAS OnDemand for Academics server to practice, then we have instructions inside the Course Overview and Data Setup section of the class for how to make the class data on the OnDemand server. And we have some demos in practices in the Programming 1 class that have you work with the np_info.xlsx file. So when you activate Programming 1, you'll have the data used in this video and you'll have ALL the data used in the class so you can practice.
I hope this helps! 🙂
Is it possible if we can add more colours into sheet after importing excel sheet into SAS?
Thanks for your question. Once you import the Excel sheet into SAS data set format, the data is now in SAS proprietary format and not in an Excel sheet anymore. SAS data does not have color settings or font settings. So there is NOT any way for you to set colors and fonts in the SAS data set itself. If you remember from Programming 1 and Programming 2 and a description of how SAS data is stored, you'll remember that SAS data has attributes for each variable or column like length, type, format, label; however, there are NOT any attribute settings for colors in a SAS dataset. When you run PROC CONTENTS to look at the information about the SAS data table, you do NOT see any color or font settings in a SAS data set or data table.
However, if you create a REPORT with SAS, such as you might create using the Output Delivery System, then your output report can have color and font changes. ODS has many destinations, such as HTML, RTF, PDF, and EXCEL and you can change colors and fonts in these output files generally using STYLE= overrides. But, the creation of an output report is not related to how you import the a sheet FROM Excel INTO SAS data table format.
Here's a posting in the SAS Community Forums that shows how to use ODS STYLE= overrides to change the color of cells using PROC REPORT and ODS EXCEL: 2.sas.com/6057Zg6Nz and here's a more recent example in a Community Forum article: 2.sas.com/6058Zg6NM .
This CZcams feedback area does not allow us to post code or screen shots or provide you with extensive Tech Support for your question. If you need additional help, we recommend that you either open a case with SAS Tech Support or post your question in the SAS Community Forums, here: 2.sas.com/6059Zg6N3 in the ODS and Reporting Forum.
Hi excellent and shortest. I got exactly the same information after running the version code. I got X lib successfully and the first part of the proc contents and lib X empty. When I look at your folder, I can see the c: / and know idea how one can see that on your sever folder. Nobody's has C:/. What is my problem?
Stay tuned, we're looking into this for you!
The C: drive visible in the narrator's SAS Studio browser means that she is using a local copy of SAS with SAS Studio as her front-end interface. If you notice, she is looking at the Files and Folders pane in SAS Studio. If you are using SAS Studio with a server copy of SAS, that same navigation pane might be called Server Files and Folders. Unfortunately, we cannot provide in-depth Tech Support in this CZcams feedback area. One reason that your library might be empty is that you do not have an Excel workbook to open or you might be using SAS Studio with a server copy of SAS, in which case the location you use for your LIBNAME statement would need to be a server location. If you want to practice learning how to use the XLSX Libname engine, that is a major topic in our free Programming 1 course. In the course, we provide XLSX files for the student to import and we provide starter code to help you learn how to import the XLSX files. If you go to this website 2.sas.com/6050Jf6ms, you'll only need to have a SAS Profile in order to activate the free Programming 1 course. Look under the e-learning section at the bottom of the page in order to click to activate the course.
Please teach me,I have 4 sheets in excel,1 is working sheet,some 3 are data sheets,So im copying each data from each sheets and them paste it to working sheet. So now,i wanna use sas by click just 1 button and the result be altogether in 1 sheet and then with final report together.
Darshini, we are checking on resources for you!
Hi Darshii,
We cannot post code or screenshots here in the CZcams feedback area, and we can't review your code or provide Technical Support in this feedback area. How to use SAS and the XLSX Libname engine to import and export files is one of the major topics in our free Programming 1 course. It sounds like you need to import all of your individual sheets into one SAS data set and then export that dataset back into an Excel workbook as one sheet. This is possible with SAS, but it will involve writing some fairly simple code, not just "clicking 1 button". I highly recommend that you take our Programming 1 course, which you'll find here: 2.sas.com/60573HIR7 . Another resource for you would be to post in the SAS Programming forum here: 2.sas.com/60503HIr6 in the SAS Communities and ask for suggestions there for how to accomplish your task. If you are using SAS through your work license, then you could also open a track with SAS Technical Support. You will need to provide Tech Support with a sample of your data and your code and provide your site license number in order to open a track. To open a track with Tech Support, fill out the form at this link: 2.sas.com/60513HIrB .
Great Video Very Helpful. Actually in sas 9.4 By using LIBNAME XLSX STATEMENT DATASETS ARE PREPARED BUT THESE ARE NOT OPENING. ITS SHOWS SOME ERROR. HOW CAN WE OPEN THESE DATASETS.
Hello, Srinu - thanks for your positive feedback! We're sorry you're having trouble, and we're happy to help!
Please let us know:
1) the complete error message you are getting.
2) specific details about what you are doing before getting the error.
3) the timestamp range (beginning & ending times) from the video for what you are trying to do.
I cant see these excel tables(parks, species visits) in the library i created, it shows in the log that its successfully created but when i see on the libraries panel its blank...... please help....
Sahas, we are checking on this for you!
Sahas, Be sure that you have the fully-qualified path name of the Excel workbook, including the Excel extension in your LIBNAME statement. For example, if the workbook is in your EPG1V2/data folder and you are using SAS OnDemand for Academics, the LIBNAME would look like this:
libname x xlsx '/home/your-SASODA-id/EPG1V2/data/np_info.xlsx';
It is difficult to troubleshoot your issue without seeing your program and knowing the full path of your Excel workbook. Please send email to curriculumconsulting@sas.com so we can better assist you.
Hello! Thank you for the lesson. I have a quick question regarding the sheet statement. How do you import a sheet that has spaces in between the words/letters? TIA
Hi Bunty! We're looking into this for you and will get back to you with more info, thanks!
Hi Bunty! Without seeing ALL of your code and the exact type of Excel file (xlsb, xls, xlsx, etc) you are using, there is not just a single answer. IF you are using PROC IMPORT and IF you have an XLSX file and IF you are using DBMS=XLSX in the PROC IMPORT code, then your sheet name with spaces would be specified as:
sheet='Name With Space';
IF you have an XLSX file, then you can ALWAYS use the XLSX Libname engine to see what the sheet names are, as shown at time stamp 1:51 in the video. And, if you look at time stamp 4:01 in the video, then you can see the PROC CONTENTS code that you can use to see exactly what sheets are in the Excel .xlsx file.
However for other DBMS= options or other types of Excel files, you would need to work with Tech Support or read the documentation to answer this question of how you specify the sheet name for your Excel file.
Hope that helps!
When I do the first step, the program runs and doesn't show any errors but for some reason it does not actually upload the excel file. Can anyone help? I am using SAS on demand. Thanks!
Hello Liza, thank you for your inquiry! In this CZcams video, the instructor is using SAS Studio on her local C: drive. So she is using a version of SAS Studio that allows her to read directly from her C: drive. The code that she is illustrating is not automatically uploading the Excel file. Since the Excel file is on her C: drive and since SAS is on her C: drive, the Excel file in this video does NOT need to be uploaded prior to the import step.
However, when you use SAS OnDemand for Academics, SAS is on a Linux server on our platform. SAS Studio, when it is pointed to SAS on the SAS OnDemand server, CANNOT read from your local C: drive. PROC IMPORT and the XLSX Libname engine do NOT automatically upload any files from your C: drive onto the OnDemand server. You must manually upload the XLSX file from your local machine into the home directory on your SAS OnDemand account.
Our Programming 1 class has several lectures and practices on how to write PROC IMPORT or use the XLSX engine to read your Excel files, so that would be one good resource for you. Another good resource would be this other CZcams video 2.sas.com/6059Mipkb which talks about getting started using SAS OnDemand for Academics. In the video, the narrator shows how to do an upload starting at time stamp 3:10 in order to make a new folder prior to doing the upload, then the video continues and shows how to change the path in code from a C: drive location to a OnDemand server location starting at time stamp 06:00.
We cannot post code or screen shots in this feedback area or look at your code or screen shots. If you feel you need more in-depth help, we encourage you to post your question in the SAS Community that has been set up for SAS OnDemand users, here: 2.sas.com/6051Mipkd . The advantage of posting in the SAS Community Forums is that you can post the code you've submitted and the error message you're seeing and other users of the SAS OnDemand interface can help you.
This is helpful. To clarify, can you specify the location on your computer of your excel file that you were trying to import?
I’m asking because I’m getting stopped at the very early step of proc print.
I have an H drive, but my institute doesn’t provide me access to a C drive.
When I run proc print, I receive a warning: “ERROR: file WORK.cyhy.data does not exist”.
Meanwhile, libname and proc contents worked fine.
Harry, thank you for your inquiry! We are checking on this for you!
Harry, after further researching, it is not possible for us to examine your code or your log in this feedback area. We can't post code here or screen shots and we can't collect your usage information. On our classroom machine, we have a mapped S: drive and a location like S:\workshop\testfile.xlsx works for us to import an Excel file or use it with PROC CONTENTS and the LIBNAME XLSX engine. However, without looking at ALL of your code and your SAS log and understanding what type of system you are running your code on this is not the type of debugging we can help you with. your best resource for a question like this and for help with debugging your issue is for you to open a track with SAS Tech Support. To open a track with Tech Support, fill out the form at this link: 2.sas.com/6056Jc0M6 .
If possible could you help us about use of SAS on demand for academics (SAS ODA) ? We ask to analyze my PHD student data in SAS ODA. We used GLIMMIX in SAS script. Is it possible to use GLIMMIX in SAS ODA. If possible could write how can call data from excel and do analyz via GLIMMIX in SAS ODA. Thank you so much.
Here is the support page for SAS OnDemand for Academics: 2.sas.com/6052JDkuG .
•This is the FAQs for SAS OnDemand for Academics: 2.sas.com/6053JDkuH .
•Getting Started with SAS OnDemand for Academics video: 2.sas.com/6054JDkuy .
SAS OnDemand for Academics uses a custom version of SAS/STAT software that supports PROC GLMMIX.
You must upload your Excel workbook into your SAS Studio session within SAS OnDemand for Academics. Submit your LIBNAME statement to the workbook and use the libref.worksheet name in your PROC GLIMMIX. Here is an example that uses the class.xlsx workbook, which contains a sheet named class_teachers.
libname myx xlsx '/home/your-userid/your-folder/class.xlsx';
proc glimmix data=myx.class_teachers;
class ...
model ... ;
run;
To find the path of your uploaded Excel workbook for the LIBNAME statement, right-click the Excel workbook and select Properties. You will see the full path in the Location field.
I try the steps but my excel file does not appear in the library, how can I solve this problem?
Thank you for your inquiry! We are checking on this for you!
When you import an Excel file into SAS there are many factors that could affect the import, including but not limited to: the EXACT code you used, any error messages in the log, the version of the Excel file you were trying to import, your version of SAS, your installed SAS/Access products, your operating system and whether your version of SAS and your version of Microsoft office are compatible. To debug your problem requires more in-depth investigation. A CZcams comment area is not the place to collect or respond to this type of information. We recommend that you open a track with Tech Support by filling out this form: 2.sas.com/60561qmm0 . Tech Support can work with you and look at all your code, all your system specifications and all your data and provide you with in-depth help.
I have a file in SharePoint can I connect directly to SharePoint and get the excel file from SharePoint to the sas environment?
We are checking for you, Lakkimsetty, and will get back to you soon!
Hi again, Lakkimsetty, and thank you for your question about importing an Excel file from SharePoint into SAS!
We found some resources that might be helpful:
1) This SAS communities post: "Reading an Excel file from Sharepoint/Intranet with a URL address - how?" 2.sas.com/6050GASm8
*NOTE: the link to listserv.uga.edu from the first reply does not work.
2) This SAS Blog post "Using SAS with Microsoft 365 (OneDrive, Teams, and SharePoint)" 2.sas.com/6052GASmE
And, as always, you can post your own question to our SAS Community: "How to get fast, helpful answers" 2.sas.com/6053GASm1
Please let us know if we can help you with anything else!
Hi Thanks for this video, will this work for .xls also?
Hi, I have imported an xlsx file. data row is 5. header row is row 4. how can I declare the header in row 4? any help will be appreciated. Thanks
Checking on this for you!
Check out this article for assistance with this issue: 2.sas.com/6051HKMQW
Let us know if you need further help!
It seems this doesn't work for SAS EG (7.1)
We're sorry you're having trouble, Susan, and we're happy to help!
As it seems you noticed, Kathy is using SAS Studio as her SAS interface in this video, and not SAS Enterprise Guide. Base SAS runs the code for both interfaces, so it should work in either of them.
For the first method Kathy shows, using the LIBNAME statement, she mentions (at 1:55) that you need to have Base SAS 9.4M2 or newer for it to work. SAS Enterprise Guide 7.1 was released after 9.4M2, but it's still possible to run it on an older maintenance release or version of SAS, so you may not have 9.4M2 (or newer), which means that method won't work. To determine the version of SAS you have, please follow the steps described by Kathy starting at 2:10.
The second method, PROC IMPORT, which Kathy explains starting at 8:45, should also work with SAS Enterprise Guide 7.1.
If this information doesn't help, please let us know more details about what is happening for you, such as:
1) What version of SAS are you running?
2) Which method are you trying that isn't working?
3) At what point in the process is it not working, and how?
A) Are you getting an error message?
B) At what point in the process are you getting the message?
Thanks!
Hi,
When i added the excel file in my SAS studio, i was not able to see different sheets in my excel under the library X
Can you please help me with that why this is happening?
Also using the second way you shared to import it is giving an error that output SAS data must be provided?
Please help me out with this.
Checking on this for you!
Hi! Please email example of your code and the SAS Log messages to curriculumconsulting@sas.com. They are standing by to trouble shoot.
so sad that i am using the same version like you but it doesnt work for me
We would like to refer this to the next level of support by opening a technical support track. Would you like for me to open a track for you?
For immediate assistance from Technical Support, you can call 800-727-0025, option 2. In the meantime, click here 2.sas.com/6052GUu0p to learn how SAS Support Communities can expedite your tech support experience. Also, for the most up-to-date SAS tips and how-to’s, be sure to subscribe to the SAS Tech Report 2.sas.com/6053GUu0V.
Hi Kathy.. thanks for the video..
I am facing one issue. I used code:
Proc export data=sashelp.class
Outfile='path\test.xlsx'
Dbms =xlsx replace;
Run;
I got the following error:
/sasconfig/lev1/servercontext_template/path.
Make sure the path name is correct and that you have write permission.
And I have all the access to the folder .I can write create and delete files in the path folder.
Can you please help me to resolve the issue?
Thanks
Hello, Ruhan!
As you may have noticed, this video is about importing data from Excel to SAS, with one of the options being PROC IMPORT.
From the code you shared, it looks like you are trying to export data with PROC EXPORT, so we suggest you view Kathy's video on that topic, "SAS Tutorial | How to export SAS data to Excel". The PROC EXPORT part of that video starts here at the 12:29 timestamp 2.sas.com/6056GEjqM
We see your OUTFILE= argument does not seem to be a complete path and filename for the output file, as specified in our PROC EXPORT documentation on the OUTFILE="filename" argument, which you can find here 2.sas.com/6057GEjq3
For example, the OUTFILE= argument from the PROC EXPORT part of Kathy's video (link above) is:
outfile='c:\demo\cars.xlsx'
Please let us know if this helps, or if you have any other questions for us!
@@SASUsers thanks a lot for your help. 😀
You're welcome!
aprendarei conhecer SAS! sou surdo, meu nomé e Osmar! moro Brasil. prazer em conhecer vc
Thanks for the nice tutorial.
However, if I follow the same steps as until minute 5, trying to print the data I uploaded, it gives an error.
I also see that although I used X the same as you proposed, the sheet of my Excel file is not represented in the Library folder X... Could somebody please assist me.
my code:
libname x xlsx 'C:\Users\STOFFKX1\Documents\MITRACLIP\SAS\SAS_GermanAnalysis.xlsx';
proc contents data=x._all_ nods;
run;
proc print data=x.Variables;
run;
my error:
ERROR: File X.Variables.DATA does not exist.
(Variables is a sheet in my Excel file.)
Tx in advance!
Thank you for your question, Karen. We're sorry you're having trouble, and we're happy to help!
Please send an email to SAS_Cares@sas.com with your SAS site number, your answers to the questions below, and any other details you have about the error you are getting.
1) Does your LOG show "Libref X was successfully assigned as follows" (as shown in the video at 1:29-1:55)? If not, what does the LOG show?
2) If the Libref X was not successfully assigned, please run the %put macro (as shown at 1:58-3:20), and let us know the version of SAS you have.
3) Do your RESULTS for your PROC CONTENTS Statement show Variables as one of the sheet names in X (as shown at 4:01-4:19)?
Thanks!
How to use “park type “ variable to work in a dataset?
Hi Pathuri! Can you provide a little more information on what you are looking to do?
@@SASUsers in the video when used libname statement, i see a variable in the dataset created from the excel where variable is “park Type” where there is a space, how do we ready that variable for manipulation?
Thanks for the clarification, Pathuri. The Excel file demonstrated in this video is named np_info.xlsx and this is the same file that we use in the free Programming 1 e-learning class. In the class, we show you how to import this file from Excel into a SAS dataset. The PARKTYPE variable in the data is used to specify a category for each of the parks contained in the file. For example, Bandelier park in New Mexico has a PARKTYPE value of "National Monument" but, the Bering Land Bridge has a PARKTYPE value of "National Preserve". These PARKTYPE values for the National Park data are based on the actual values in the National Park data that is downloadable from US government web sites. If you want to see how we use this data in our programs, then you can activate the free Programming 1 class. Inside the class, we provide you with a program that makes ALL the data including the np_info.xlsx file, so you can use the data in your programs. Here's the web page for Programming 1 2.sas.com/6055O3Adv -- just scroll down to the self-paced e-learning section and click the Start link to sign on and activate the class.
Is it possible for me to import big data into sas? Let say 67 variables and 900,000 datasets? Thank you!
Thanks for your question! See if this post from Communities is helpful:
2.sas.com/6059GBWYb
what's wrong with using Sas M0?
Currently, SAS 9.4M8 is available. A maintenance release is a collection of updates to SAS products or components that corrects customer-reported issues and adapts the product to a changed environment. A maintenance release can also include new software functionality. We recommend applying releases that relate to your current environment: 2.sas.com/6058jBs7j
💝🤝😊
how can i have sas labels in excel file using proc export?
We are checking on this for you!
Use the LABEL option.
proc export data=sashelp.classfit outfile='c:\class.xlsx'
dbms=xlsx label;
sheet='classfitwithlabels';
run;
essa mulher é ninja de mais heheh
This is useless. I'm using SAS Studio online and proc import from C drive doesn't work.
We are checking on this for you! Sorry you are experiencing issues.
How are you using SAS Studio? If you are using SAS OnDemand or SAS University Edition, you must use those path names, not your C: drive. Right-click the Excel file and select Properties to see the full file path. If you need more assistance, please send an email to curriculumconsulting@sas.com.
@@kathykiraly3830 Yes, I was able to figure this out myself, but your video is very misleading since you use SAS Studio on your local machine, not the online version, even though they look the same. I have noticed that a lot of people have the same problem with connecting to C drive while using SAS Studio On-Demand, yet it's not addressed anywhere on your website.
@@Reinheit SAS Studio is available locally, in SAS OnDemand for Academics, and in SAS University Edition. If you are using SAS OnDemand, which is server-based, you must upload your files to the server to access them. Then you must you the SAS OnDemand path name. This is noted on the SAS OnDemand support page: support.sas.com/ondemand/manuals/UploadingDataUsers.pdf.
@@kathykiraly3830 great help thanks
Hello everyone, what willl be the error here?
Thank you!
/**Import an xlsx file.**/
PROC IMPORT DATAFILE= "D:\Consultation1.xlsx"
OUT=WORK.usage_Consultation
DBMS=XLSX
REPLACE;
RUN;
Help please...
Alvin, Yes you can import single sheets from a workbook; or you can import multiple sheets. SAS treats the workbook like a library and each sheet in the workbook like a data table. We cover concepts and examples like this in our free Programming 1 class.
If you would like #SASusers to look over your code, we would suggest you share questions like this within SAS Communities! This is a great place to ask for users inputs 2.sas.com/6051G8ZlP
How to take path
We'd love to help! Tell us more about what type of information or resources you are interested in.
This is very good too know. can you please let me know how to do the same in mainframe sas.
thanks in advance.
hemanth
Lakkimsetty, Thank you for your inquiry! Some LIBNAME engines can only be used on Windows or Unix systems, so if you want to use a LIBNAME engine method, such as illustrated in this video, you'll need to work with Tech Support to determine whether that capability is available under your licensed software on the mainframe. To open a track with Tech Support, you can fill out the form, here: 2.sas.com/60591WAet .
However, the quickest way to import an Excel file onto your mainframe system is to save the Excel file as a comma-separated value file on your Windows machine and then write the CSV file to a drive accessible to the mainframe or FTP the file to the mainframe so you can read it with either a DATA step program or with PROC IMPORT.
@@SASUsers thank you so much for your quick response and can you please explain how to do proc import in this scenario like in mainframes.
This type of question is more appropriate for Tech Support working with you once they know what is on your license. They will need to look at your license for the mainframe and help you figure out what types of files you can import, based on the SAS/Access products you have installed and what type of files you need to import into SAS on the mainframe and where the files to be imported are stored. These are all questions that cannot be asked, or investigated in a forum like this. We can open a track for you if you would like or you can email support directly at support@sas.com Please review information required to open a track 2.sas.com/60501oO0e
Kindly let you give me SAS codes for interaction
Thank you for your inquiry! We are checking on this for you!
Hi Ayele, the data used in this how-to video is from our Programming 1 class, which is a free class as e-learning for any independent learner. If you have set up a SAS Profile, you can activate the Programming 1 class from this website: 2.sas.com/6050M7lEo and the instructions for setting up the data are in the Course Overview and Data Setup section for the course.
Site must also have XLSX engine :-(
Let us know if you have any specific questions that we can help you with.
OH man my version is V.03.04M0P050819
Deb, let us know if we can be of assistance!
Can someone help me with SAS
Fuad, thank you for your inquiry and sorry to hear you are having some issues! If you have a usage question, we would recommend SAS communities or you can view some of our other free e-learning courses and tutorials. We also offer technical support for site license holders should have any technical questions. You can learn more about these resources and more by registering for our SAS Starter Kit 2.sas.com/6054Kv50C
@@SASUsers could I get like a 1:1 help with someone?
SAS Communities would be your best resource for asking specific usage questions where other users can look over and provide feedback. Here are some tips to get you started 2.sas.com/6055Kvggl
what...
Please let us know if you have any questions!
Pronounce it, S.A.S., not "sas".
THIS CODE SAID "THE PHYSICAL FILE DOES NOT EXIST" HERE IS THE CODE;
proc import datafile='H:\MPNURSAS.xlsx'
dbms=xlsx
out=work.SASPENS;
sheet=SASPENS;
run;
The excel workbook is in the root directory of H:
Thank you for your inquiry! We are checking on this for you!
You must use the fully-qualified path name of the Excel workbook in the DATADFILE= option. The surest and easiest way to find the path is to right-click the Excel workbook and select Properties. You will see the full path in the Location field. If you continue to have problems, please send email to curriculumconsulting@sas.com and include the following: 1.) a screen shot of your SAS code from the SAS log and 2.) a screen shot of your Properties window for the Excel workbook.