Thanks so much for taking the time to watch this video tip! This is probably my favorite topic to teach about the SAS language. I'd love to hear your thoughts and questions :)
Hi thanks q lot for explaining Macros in such a easy way.. can you please explain how to export print tables generated by Proc Tabulate in excel format and each table in different sheets. Thanks in advance for your help.
@@ruhannegi8376 I found this discussion with an accepted solution on our SAS Communities page. I hope this helps: communities.sas.com/t5/General-SAS-Programming/Proc-Tabulate-to-excel/td-p/405465
This is an amazing video and simple to understand the importance and beauty of manipulating code. Would love to learn from you more. Please make a video of DO Loop and Arrays if possible. i became ta big fan to the way you explain it
Thank you so much stacey..i learned base sas programming-1 from your e learning which is available in sas website...i really enjoy your classes...god bless you stacey.
Here is link to the SAS Programmer Certificate program on Coursera: www.coursera.org/professional-certificates/sas-programming. You can also take advantage of a 30-day free trial to access many of our eLearning courses from our SAS site: www.sas.com/en_us/training/offers/free-training.html.
hello i have a question entry level SAS programmers should learn both base and macro SAS???i fell bit difficult to memorise all the techniques you were using to code.
Hi Team, I'm trying to understand the below macro, Could any one of you explain please ? %macro mysum(n); %put mysum called: n=&n; %if &n>1 %then %eval(&n +%mysum(%eval(&n-1))); %else &n; %mend; %put %mysum(4); Result is : 10, but I want to know how the %mysum wiht %eval with in the same macro is executed ? Thank you so much in advance!! Looking forward for the explanation.
Unfortunately, we cannot provide detailed help or code or screenshots in this RU-vid feedback area. If you have a SAS site license at your company, you have 2 options for detailed support: 1) open a case with SAS Tech Support at support@sas.com and send them your site license number, the code you've tried and a small sample of your data so they can help you with your question; or 2) post your question in the SAS Community Forum for Statistical Procedures here: 2.sas.com/6051u3ChT . We hope this helps!
Hi Stacey i attended your coursera courses on getting started with SAS which was really good. now i am learning some advance concepts like this but reaching at some error in my codes not able to debug it can you help me out with it. %MACRO PRAC(PRICE=MSRP,TYPE=SMALL LARGE HEAVY SIXWHEELS); DATA SAMPLE; SET SASHELP.CARS(KEEP=&PRICE); %IF 10280.00
Hi, Prasanna! Here's what we were able to determine for you: This falls outside the scope of the Getting Started class and outside the scope of the RU-vid content. The RU-vid video is about macro variables and macro functions. You are trying to use macro variables and %SYSFUNC inside a macro program and one of the issues is that your usage is not appropriate for a DATA step. This is the kind of technique you would learn by taking the Coursera class on Macro Language processing or our Macro Language 1 class. We recommend that you start with a working SAS program before you introduce macro variables and macro logic into the code. One of the issues in your code is that you cannot use a SAS variable in an %IF statement. Your reference to &PRICE, which will resolve to MSRP (the variable), will NOT work. Your attempt to create a data set variable, CAR, in a %IF statement also will not work. You need to understand the difference between macro compile-time and macro variable resolution and macro execution time. My suggestion is that you rewrite your code, not inside a Macro program, and get it working with a regular IF statement first before you put any macro code in the program. There are a lot of links under the See More section on RU-vid that will help you. Let us know if this helps!
Hi Prasanna - Try this code: %MACRO PRAC(PRICE=MSRP,TYPE=SMALL LARGE HEAVY SIXWHEELS); DATA SAMPLE; SET SASHELP.CARS(KEEP=&PRICE); length car $ 8; IF 10280.00
Great suggestion... It may take some time to produce a video on this topic, but in the meantime check out this helpful blog post: blogs.sas.com/content/sgf/2020/04/22/how-to-create-and-use-sas-macro-functions/
Anvar, thank you for your interest! We do have recommended courses by learning paths that have both beginner, intermediate, and advanced courses 2.sas.com/6056H3ujo
Hi: Yes, you're correct, Technically, the comparison selecting front wheel drive cars that are "less than or equal to" 30000. So a more accurate title for the TITLE2 statement would have been "Front Wheel Drive Cars with a Manufacturer's Selected Retail Price that is Less Than or Equal to $30000". However, that title is somewhat verbose probably would not have looked as neat in the generated graph. The shortened title of "Front Wheel Drive Cars under $30000" manages to convey the purpose of the report. And, if you examine the data in 2.sas.com/6054MMACk, you would see that there are not any cars with front wheel drive and a price of exactly $30,000. For front wheel drive cars in that subset from the WHERE, the minimum value is 10280.00 and the maximum value is 29995.00, which is under 30000. So, given the actual data in 2.sas.com/6054MMACk, the TITLE2 statement accurately describes the subset that was selected by the WHERE and used in the SGPLOT and PROC MEANS.
Hemant, Hi: Please go back and re-watch the video and pay particular attention to the section between time stamp 4:00 -5:33. In that part of the video, you will see the %LET statement for maxprice being set to 30000. This macro variable will be referred to as &MAXPRICE and it will be used anyplace in the code where the number 30000 is needed. Notice that the macro variable is used in several places. In the title, the &maxprice macro variable is used to explain the selection condition. However, in the WHERE statement for PROC SGPLOT and for PROC MEANS, since the MSRP variable is a regular numeric variable, it must be compared to a another numeric variable or a numeric constant. In this case, the 30000 is a numeric constant and the value 30000 is being supplied by using the &MAXPRICE macro variable. Later in the video, the value for &MAXPRICE is set to 40000 and used again. This is exactly the kind of usage you're asking about. Notice that when a macro variable is going to be treated as a regular number in SAS code, it is not quoted. We cover this topic in more depth in our SAS Macro Language 1 and Macro Language 2 classes.
I'm using SAS EG, I wanted to practice along you, I cannot get your proc gplot statement to work, hbar and xaxis do not seem to be recognized... is there a different syntax with EG?
Hello May! This video uses SAS Studio as the SAS interface. Because you are using SAS Enterprise Guide, you may want to try this video instead: SAS Tip | SAS Enterprise Guide: Macro Variables 2.sas.com/6051GP1xv
@@SASUsers Hi May - the syntax should be exactly the same, regardless of if you are using SAS Studio or SAS Enterprise Guide. I'm using PROC SGPLOT in this example, which is included with Base SAS. Looks like maybe you are missing the 'S'? There is an older procedure named GPLOT, but it requires SAS/Graph and has different syntax.
Ruhan, Here is the Q&A that was posted in a previous SAS Community: 2.sas.com/6055ybPHR The answer is yes, this can be done and it can be accomplished a multitude of ways. The above community post just shows a few examples, however, the first answer with PROC SQL isn't a complete solution because it doesn't put the number of rows in a macro variable. One would need to use the into clause to do that. Here is an example: proc sql; select count(*) as countrec into :Totobs from 2.sas.com/6056ybPHr; quit; %put &=Totobs; We also cover this along with a lot of other great macro programming skills and techniques in the SAS Macro Language 1: Essentials (2.sas.com/6057ybPHT) course.
Hi. Excellent video on macros. Thanks a lot. I have one question: I am producing a report using Proc Tabulate for data set. If I dont want to show some segments and only few segments in my report.is it possible?? For example: one of the columns is cars(5 different type) and another is number of cars sold. I am producing summary by car and % of each of cars sold. So is it possible in my report I show results only fir 3 types of cars and not for 5
Ruhan, This feedback area isn't best suited to post detailed code examples. It appears that your question does not really involve the use of Macro variables or Macro functions to accomplish. You could use a WHERE statement with PROC TABULATE to limit the number of values for a column that went into your TABULATE step. For example: where model in ('BMW', 'Acura', 'Volvo'); If you have specific usage question about PROC TABULATE using your data, your best resources are the SAS Community Forums 2.sas.com/6057GTPRc and SAS Technical Support 2.sas.com/6059GTPRl
