SAS Tutorial | How to Create Macro Variables and Use Macro Functions

[@staceysyphus8238]

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 :)

[@ruhannegi8376]

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.

[@SASUsers]

We're checking on this for you!

[@ruhannegi8376]

@@SASUsers thanks a lot for you reply. Waiting for the answer.😀

[@staceysyphus8238]

@@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

[@mail2valan]

love to watch this.. very useful. Thank you so much

[@patricklewis7981]

You have given a great introduction to Macros.

[@SASUsers]

Thank you so much for the feedback!

[@yoannkouame3282]

STACEY always doing great with SAS, so nice to have you as instructor!

[@SASUsers]

We think so, too! Thanks for sharing!

[@benobasa1968]

That's my SAS tutor on Cosera. I am excited to see her here!

[@staceysyphus8238]

Glad you're going through the Coursera courses! Those allow you to dive deep into SAS programming :)

[@thepineweaver]

Very clear material - one of my favorite SAS instructors.

[@SASUsers]

Ours, too! ;) Thanks for watching!

[@chunleizhang77]

Excellent video with bells and whistles. Thanks, Stacey!

[@SASUsers]

Awesome feedback, and thanks for watching!

[@talie6236]

You are one awesome teacher. Very articulate, friendly, knowledgeable and beautiful ☺️.

[@anvarisamukhamedov4961]

Thanks for this session, now I understand how and where to use a macro variable. You are a very beautiful, friendly, and knowledgeable teacher.

[@SASUsers]

Glad it was helpful!

[@anvarisamukhamedov4961]

@@SASUsers do you have the full courses of SAS for both beginners and advanced, I would like to have it for my personal learning. Many Thanks.

[@SASUsers]

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

[@SoleLo]

Recently started using Macro language and what a game changer… %include has been my favorite

[@SASUsers]

Thanks for sharing, Jamarcus!

[@ARSagar-dt7yj]

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

[@SASUsers]

A.R. thank you so much for the feedback! Check out our SAS Community pages for more resources on using Arrays and DO Loops 2.sas.com/6051GfvKB

[@niyazshaik4178]

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.

[@sharangnimonkar9183]

Hi Stacey, Really great way of explanation. Systematic approach made it easy to comprehend.

[@SASUsers]

Thanks so much for the feedback Sharang! Glad you found it helpful!

[@darshmathur4870]

Loved it short and crisp. Please make a video on user defined macro functions. Would appreciate it 😊.

[@SASUsers]

We're glad you enjoyed the content and have shared your feedback with our Video team!

[@staceysyphus8238]

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/

[@oluwaledurojaye74]

GRAET INSTRUCTOR, always enjoy your teaching on sas macro.

[@SASUsers]

Glad you enjoy it!

[@omadnomad1635]

You are an amazing teacher . Love all your classes

[@SASUsers]

So glad you enjoyed the tutorial! 🙂

[@parulanand5967]

Very useful and easy approach. Loved the way you explain !

[@SASUsers]

Parul, thank you so much for your feedback! We are glad you found it helpful!

[@steveellison8686]

Great instructor- I love your delivery!

[@SASUsers]

So glad you enjoyed it! 🙂

[@2beCuil]

Thank you for this tutorial

[@annawells1913]

excellent video, thank you!

[@SASUsers]

You are welcome!

[@JC-wf7gr]

I love her courses on Coursera

[@octaviopalma1309]

can u share me the link on Coursera pls?

[@sydznl]

Yes me too

[@staceysyphus8238]

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.

[@dominicmutiso1502]

Wow😂 @7:42 to 7:43. I love the effect- "reaction"

[@himself9278]

Hi Stacey many thanks for the great presentation, I just love the flow of the info. I love using Macro, as it simplifies a code , #manipulating code

[@EderbalFilho]

Excellent teacher !

[@sarajitsil]

Hi Stacey, a very helpful tutorial indeed! Many thanks for making this content.

[@SASUsers]

Absolutely! We are glad you found it helpful!

[@mstshandu]

Great presentation that is easy to understand

[@SASUsers]

We love that you love it! Thanks for sharing, and hope you come back for more! Happy Holidays!

[@dylanr494]

Great tutorial!

[@SASUsers]

We're glad you found it helpful!

[@ruhannegi8376]

Hi thanks for wonderful video. Can we also put count of rows in dataset in to a macro variabke and use it in other programmes???

[@SASUsers]

Ruhan, thank you for your inquiry! We are researching this for you!

[@SASUsers]

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.

[@himself9278]

Wow this is great, now i know how to remove the leading and trailing spaces, that results as result of creating a macro variable in proc sql, #trimmed

[@SASUsers]

Glad it was helpful!

[@jalwerdt85]

Thank you! You made it so easy to understand.

[@SASUsers]

Awesome! Glad to hear it!

[@mekidesbekele1787]

you make it very easy

[@mattyyyCodes]

The hearts for the favorite 3rd section made me laugh (:

[@goo6341]

Great 👍 lesson. Thank you 🙏

[@SASUsers]

Glad you liked it!

[@pamelyn186]

Amazing!

[@Ujwala1010]

Well explained 👏

[@sunilgupta2156]

Nice video on SAS macros.

[@SASUsers]

Glad you enjoyed it. These may be of interest, if you like blogs 2.sas.com/6056GbFsk

[@papachoudhary5482]

Thanks

[@mekidesbekele1787]

Awesome

[@enssea.hamimed]

How about Mixed models?

[@ruhannegi8376]

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

[@SASUsers]

We are checking into this for you!

[@ruhannegi8376]

@@SASUsers thanks a lot.😀

[@SASUsers]

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

[@himself9278]

Could you be having a link to where i can get the updated functions in SaS

[@SASUsers]

Thanks for your inquiry! You can find some New Functions and Call Routines in documentation 2.sas.com/6055GkT8f

[@hkbca]

Can macro var values be used directly as numerical condition?

[@SASUsers]

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.

[@priyankaveerapaneni3245]

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.

[@SASUsers]

Unfortunately, we cannot provide detailed help or code or screenshots in this KZbin 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 [e-mail] 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!

[@priyankaveerapaneni3245]

@@SASUsers Thank you, will post it in the sas community forum.

[@HimaPatel-kx8ic]

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.

[@SASUsers]

You may find this handy for recommended learning paths for programmers 2.sas.com/6058ew6zr.

[@mekidesbekele1787]

encouraging!!!!

[@SASUsers]

We love to hear that!

[@maycrow1522]

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?

[@SASUsers]

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

[@staceysyphus8238]

@@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.

[@prasannadillikar7760]

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

[@SASUsers]

We're looking into this for you! Thanks for your patience!

[@SASUsers]

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 KZbin content. The KZbin 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 KZbin that will help you. Let us know if this helps!

[@prasannadillikar7760]

@@SASUsers Thanks for clearing my doubts and I will definitely work on what has been suggested by you. Thank you

[@SASUsers]

You are so welcome!

[@staceysyphus8238]

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

[@harshpratap2920]

can you plzz answer my one question that what is future of sas ,Is it replace by AI and we lost our jobs. (mostly in clinical sas industry).

[@SASUsers]

Hi, there! This article should be helpful: 2.sas.com/6050uEFtC

[@aboveduality1300]

Kamala? 😯

[@taipagibonhuchu2256]

beautiful woman

[@danielb1877]

Good video. But that's not "under $30,000"... it's less than or equal to $30k :)

[@SASUsers]

Thanks for your feedback! We will be sure to share with the presenter.

[@SASUsers]

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.