MACROs in SAS | SAS MACROs All in One | MACRO Programming in SAS Complete Tutorial

Подписаться 18 тыс.

Просмотров 68 тыс.

50% 1

This is another video to enhance your SAS Skill and become a pro by learning the MACROs in SAS. This video covers almost everything which a beginner would require to learn to be able to start Macro programming and become a pro.
This video covers the following topics:
► Introduction to MACROS in SAS
► Macro Variables
► Different ways of creating macro variables in SAS
► %if %then %else in SAS Macros
► %STR in SAS
► %EVAL in SAS
► %SYSFUNC and Usage of % in SAS MACROs
► MPRINT
► MLOGIC
► SYMBOLGEN
► %LET to create a macro variable
► Macro Parameters
► INTO Clause in Proc SQL
► CALL Symput Routine
#Learnerea
#SASTraining #SASTutorial #SASCourse #SASTutorialForBeginners #SAS #SASforBeginners
#SASProgramming #SASTProgrammingForBeginners #SASProgrammingTutorial
Contacts:
Facebook ► / learnerea
Download the excel files for practice data
GitHub ► github.com/LEA...

Опубликовано:

29 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 71

@7979sunny 7 месяцев назад

Hello..I have a query regarding SAS macros. When we convert local macro variable to global variable using %global statement. Can we use that macro variable in data or proc step and could you plz let me know the procedure for that. Thanks In Advance!

@bhanuchandar2805 3 года назад

Please provide some interview topics on CDISC (SDTM,ADAM)

@sandeepmane8694 3 года назад

Sir your explanation is excellent and slowly which is clearly understand Plz sir I want a some videos like 1)some statistical test in SAS 2)CDISC (SDTM,ADAM) 3) Clinical trials in SAS 4)CRF annotation 5) Randomisation and sample size calculation 6) Table and listing creation I hope you will above topic video as early as possible

@learnerea 2 года назад

Sure will do these

@3rdEyeSpiritual 2 года назад

Thanks good video, if possible please put the excel file (SASHELP.CARS0. file that used in above video , so that we can load and try practice same. thanks

@learnerea 2 года назад

Glad you liked it. If you mean the dataset sashelp.cars then it's available in all the sas packages...you can start using the same way as it's shown in the video. if there is some data sashelp.cars0 which we have used to explain in the video, please help us with the time stamp when you see this table name... we will try to upload the data on github and you can download it from there

@rameshbalami2075 3 года назад

I was struggling to understand macros in sas...n just managed to get what I want ...thnx so much..u made it very easy to understand

@learnerea 2 года назад

Glad you liked it

@guillermoramos4043 Год назад

Dear Learmea In the first conditional example when you run your macro with "SUV" you do not got what you wanted; To get what you wanted, in line 25 you shoud have written: where upcase(type) ne "HYBRID";

@learnerea Год назад

Sounds like a good suggestion which I can validate if you could help me with the time stamp when this was explained in the video

@emtinantarek225 22 дня назад

@@learnerea this starts from the minute 40:00 , because the output type includes Hybrid too

@TheSafi4027 2 года назад

Thank you for the tutorial ! Awesome and very well explained...Much Appreciated....

@dominicmutiso1502 2 года назад

Is this a complete guide to prepare for the SAS advanced exam on Macros?

@learnerea 2 года назад

This has been made keeping organisational requirements in mind, not really sure if this covers all that comes in the exam

@dominicmutiso1502 2 года назад

@@learnerea thank you.

@raninamburi3280 Год назад

Hi Sir, do you teach R and python?

@learnerea Год назад

Yes, there is whole play list of python - Complete Python Tutorial for Beginners - ru-vid.com/group/PL4GjoPPG4VqPUklqM_kq5wHJDsAWV2Ue- Complete NumPy Tutorial for Beginners - ru-vid.com/group/PL4GjoPPG4VqNz8W3JRDD-uRcM9WVJHYve Data Transformation and Analysis with Pandas - ru-vid.com/group/PL4GjoPPG4VqP0BNdnIZQqjCYodmtFCcee Visualization in Python with Matplotlib - ru-vid.com/group/PL4GjoPPG4VqN4dsP39m4QfpZSUrv2y8Iu Visualization in Python with Seaborn - ru-vid.com/group/PL4GjoPPG4VqOAwSNw2I-PXUcjw1frHmW2 Data Science Playlist - ru-vid.com/group/PL4GjoPPG4VqOmyh7hQ730evtLaz04LwSf Statistics Playlist - ru-vid.com/group/PL4GjoPPG4VqMAGTXiPYBHXgBu9Da1qrOs

@kidsplayhouse4931 3 года назад

Please do interview questions on healthcare analytics on sas

@sabyasachiojha3723 2 года назад

if you want to remove debugging option in a session then instead of terminating the session just use "options nomprint" or "options nomlogic". so no need to terminate the session.

@ajaytodankar2864 3 года назад

Very useful and simplest way to learn macros.. Great job

@learnerea 2 года назад

Glad you liked it

@ashokballipalli237 3 года назад

Please do videos of clinical sas... Ur explanation is clear Sir...

@learnerea 3 года назад

as soon as possible

@somcana Год назад

Why I am having problem when I use work library? OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 94 ODS HTML CLOSE; 95 &GRAPHTERM; ;*';*";*/;RUN;QUIT; 96 QUIT;RUN; 97 ODS HTML5 (ID=WEB) CLOSE; 98 99 FILENAME _GSFNAME; 100 DATA _NULL_; 101 RUN;

@learnerea Год назад

can you put your code as well

@wenjiezhou8888 2 года назад

Thanks for the tutorial! It's very useful and helpful in my work!

@nithyaangamuthu6782 2 года назад

Explained very clearly. Thank you so much.

@learnerea 2 года назад

Thank you Nithya

@sakwael 2 года назад

Thank you for the tutorial ! super clear and very well explained

@learnerea 2 года назад

Glad you liked it

@aspiren81 2 года назад

thank you for your video. Why did't we use %upcase ?

@learnerea 2 года назад

would you be able to put the time stamp when you see me not using this where I should had to, I'll check and get back to you

@osamahmood1678 2 года назад

Thanks for this very informative tutorial on SAS Macros and Debugging

@learnerea 2 года назад

Glad you liked it

@mariemargaryan1995 Год назад

hi friends, who can help me with this? i should create call dataset from SASHELP library. Create macro variable that will be used to filter the dataset BASEBALL to keep observations where player’s Surname isn’t starting with “W” letter. Create a macro program to count how many players are playing - a) in the same DIV and in the same TEAM, b) in the same LEAGUE and at the same POSITION.

@learnerea Год назад

you don't necessorly require a macro, try this - data call(drop=last_name); set sashelp.baseball; /*separate last name from the full name */ last_name = scan(name,2,","); /*filter for those whose surname doesn't starts with w */ where substr(lower(name),1,1) ne 'w'; run; /*use proc frequency to get the counts by team and div you are looking for */ proc freq data=call; tables team*div/nocum nopercent norow nocol; run;

@JoelHernandez-vs1kn Год назад

Gracias

@learnerea Год назад

Contento, fue útil

@GajendraThapa-np9tv Год назад

Could you please share datasets all_cars_summ and cars_summary at 19.02?

@learnerea Год назад

would you mind putting timestamp here when you see these datasets being used.. that will help us to quickly find

@GajendraThapa-np9tv Год назад

@@learnerea 19:02

@GajendraThapa-np9tv Год назад

@@learnerea and 26:12

@memoriesforlife7685 3 года назад

clearly understand macros and very useful for beginner to

@learnerea 3 года назад

Thank you for complement

@AnkitaSingh-yg8cz 3 года назад

I got this error NOTE: The quoted string currently being processed has become more than 262 bytes long. You might have unbalanced quotation marks. how can i slove

@learnerea 3 года назад

If your script is not too long, can you please put that here

@subho95 10 месяцев назад

How to do the same thing in Python?

@learnerea 10 месяцев назад

better you should mention a problem statement here which you would like to solve in python same as it is solved in SAS using Macros

@Izumi1703 2 года назад

For the creating macro variables with call symput option, you had some converted message in the log, how can we get rid of that as it is not normally accepted as a log issue? it said numeric values have been converted to character.

@learnerea 2 года назад

Hi Lzumi, Thanks for watching the video. would you mind putting the timeframe over here, that will help us to qucikly reach to the specific point where you have problem.

@Izumi1703 2 года назад

@@learnerea Ah yes sorry my bad, at 32:40 :)

@learnerea 2 года назад

@@Izumi1703 Though it's not an issue one need to fix but if that's a matter of concern for you then you can simply put the numeric value in quotation e.g. instead of 94 you can just put '94'

@Izumi1703 2 года назад

@@learnerea It actually is an issue that I need to fix since in my job it is not accepted so thank you for the solution provided :)

@learnerea 2 года назад

@@Izumi1703 Happy to know that the provided solution worked for you. Feel free to post any further queries where you are stuck in. You can also write to us directly on learnerea.edu@gmail.com