Complete SAS Macro tutorial for beginners to Advanced SAS programmers (6 Hours long)

  Рет қаралды 20,149

SMARTTECH

SMARTTECH

Күн бұрын

Пікірлер: 39
@sudheerupputuri932
@sudheerupputuri932 Жыл бұрын
Very good explanation of hidden features of macro concepts and presentation was very cool and outstanding. Thank you so much for such wonderful presentation.
@beedee9959
@beedee9959 Жыл бұрын
Superb, keep it up. So nicely and methodically explained and clear diction.
@agupta9674
@agupta9674 2 жыл бұрын
Thanks for making this video, it has been very helpful in understanding macro concepts
@readistreet9383
@readistreet9383 2 жыл бұрын
Thanks a lot, you have helped me a lot, please keep making this videos, they are excellent!
@manohargoud5602
@manohargoud5602 2 жыл бұрын
Excellent Explanation Of SAS Concepts,, Fantastic Teaching Bro Simply Superb.. Please Do Many More Related To SAS...We Will Encourage You Keep Rocking...
@kiranvenna
@kiranvenna 2 жыл бұрын
Thanks, and I appreciate your support
@jinqiuhuang7562
@jinqiuhuang7562 Жыл бұрын
Very clear explanation! It would be wonderful if I could download your slides. Thanks so much!
@kiranvenna
@kiranvenna Жыл бұрын
Sure. please send email to smarttech089@gmail.com. I will email you the slides
@jinqiuhuang7562
@jinqiuhuang7562 Жыл бұрын
@@kiranvenna Did it. Thanks so much!
@vikramtri3688
@vikramtri3688 2 жыл бұрын
Thank you so much bro .... your videos more useful for us.
@shwetajaiswal777
@shwetajaiswal777 11 ай бұрын
Thank you sir for such a helpful video.
@9356079
@9356079 2 жыл бұрын
Thaks sir, please make a complete video tutorial on sas etl and other data analyst technique
@kiranvenna
@kiranvenna 2 жыл бұрын
May be sometime in future
@utkarshsrivastava4100
@utkarshsrivastava4100 2 жыл бұрын
Thanks @kiran for this video it helped me a lot for cracking the interviews!! 👍👍👍
@kiranvenna
@kiranvenna 2 жыл бұрын
Thanks Utkarsh, appreciate your kind comments
@virendradhumal601
@virendradhumal601 Жыл бұрын
very nice video espelly for beginners like me..ty....where can we find raw dataset along with ans code for a practice for sdtm and adam?
@kiranvenna
@kiranvenna Жыл бұрын
Thank you and sorry I am not from clinical SAS.
@srikanthreddy3454
@srikanthreddy3454 Жыл бұрын
Could you explain control flow(compile and execution)of proc step and also macros
@kiranvenna
@kiranvenna Жыл бұрын
information related to procs is proprietary, so we really do not know what happens with relation to proc. With Macro, i think I explain compilation and execution of the macro.
@srikanthreddy3454
@srikanthreddy3454 Жыл бұрын
@@kiranvenna please send me the macro link
@abhishekdixit5257
@abhishekdixit5257 2 жыл бұрын
Can you please tell if you have explained how we can pass multiple values in a macro variable in this tutorial? If not could you please make a video on it? Scenario is like, suppose we have a procedure as:- Proc print data= &dsn; run; So in this I want to pass 5 datasets like sashelp.class, sashelp.cars and some other datasets also...so how this can be achieved? Also if we use loop like i= 1 to 5 to pass the datasets how this count can be done dynamically rather than hardcoding it to i= 1 to 5. Please make a video on it.🙏🙏🙏
@kiranvenna
@kiranvenna 2 жыл бұрын
All this are there and in more depth in there. check out proc sql into part and call execute
@abhishekdixit5257
@abhishekdixit5257 2 жыл бұрын
@@kiranvenna thankyou so much...your videos are really helpful 👍
@gerardtetegan7318
@gerardtetegan7318 Жыл бұрын
why "catt" in symputx and not "cats", especially since before now, concern was about leading blanks?
@kiranvenna
@kiranvenna Жыл бұрын
I just did out of common preference, it does not matter.
@gerardtetegan7318
@gerardtetegan7318 Жыл бұрын
@SMARTTECH oh ok! I assumed that catt only handled the trailing blanks. Thanks for your response.
@AnilKumarnn
@AnilKumarnn 4 ай бұрын
TIL: The forward rescan rule for macros.
@manchivenkatesh4072
@manchivenkatesh4072 2 жыл бұрын
Thank you so much bro
@khkrishna7427
@khkrishna7427 2 ай бұрын
Nice
@okayMrN
@okayMrN 2 жыл бұрын
Is it possible to get this presentation deck sir? Thanks a lot..
@kiranvenna
@kiranvenna 2 жыл бұрын
Please share your email, I will email it to you
@okayMrN
@okayMrN 2 жыл бұрын
@@kiranvenna thank you so much sir for creating a wonderful video on such a complex topic
@okayMrN
@okayMrN 2 жыл бұрын
I will be patiently waiting for the deck, if you kindly share please sir
@kanthreddy9324
@kanthreddy9324 Жыл бұрын
Write a macro to split data into N number of datasets Suppose you are asked to write a macro to split large data into 2 parts (not static 2). In the macro, user should have flexibility to change the number of datasets to be created. How to do this problem sir
@kiranvenna
@kiranvenna Жыл бұрын
check this solution on this topic blogs.sas.com/content/sgf/2020/07/23/splitting-a-data-set-into-smaller-data-sets/
@farzeenshaikh-j9o
@farzeenshaikh-j9o 10 ай бұрын
I tried %let dsn=sashelp.class; and then trying to apply proc sort (PROC SORT DATA=&dsn ; BY SEX; RUN;)step its not working why? do u have any idea ?
@kiranvenna
@kiranvenna 10 ай бұрын
What is the error message. Check the error message. This helps us to understand things better. Always run code without macro variables first and see what happens. If you do proc sort data=sashelp.class; run:. Clue that will not work either and why it will not work and why it does not work. It will be in your log
@mussiekebede2575
@mussiekebede2575 2 ай бұрын
@farzeenshaikh. You forgot double quotes. You xhould be good if you do this: DATA = "&dsn";
@mussiekebede2575
@mussiekebede2575 2 ай бұрын
Use Correction: You do not have permission to modify sashelp.class data. First create your own data from sashelp.class. There after, you can apply the changes I mentioned before into your code.
How to avoid overwriting of SAS Macro variables.
6:15
SMARTTECH
Рет қаралды 839
Арыстанның айқасы, Тәуіржанның шайқасы!
25:51
QosLike / ҚосЛайк / Косылайық
Рет қаралды 700 М.
1% vs 100% #beatbox #tiktok
01:10
BeatboxJCOP
Рет қаралды 67 МЛН
Cat mode and a glass of water #family #humor #fun
00:22
Kotiki_Z
Рет қаралды 42 МЛН
Advance SAS tutorial (9.5 hour long PROC SQL and SAS Macro video)
9:27:38
SAS MACRO INTERVIEW QUESTIONS 1 | SAS ADVANCED TRAINING #sas
16:01
SAS Tutorial | Beyond the Basics of Macro
2:37:28
SAS Users
Рет қаралды 31 М.
Advanced SAS Programming Tutorial | SAS Macros | SAS SQL | SAS Figures | Full course
7:04:48
Designing a advanced SAS macro - Case Study
27:27
SMARTTECH
Рет қаралды 12 М.
Kubernetes 101 workshop - complete hands-on
3:56:03
Kubesimplify
Рет қаралды 1,7 МЛН
7 Outside The Box Puzzles
12:16
MindYourDecisions
Рет қаралды 269 М.
Арыстанның айқасы, Тәуіржанның шайқасы!
25:51
QosLike / ҚосЛайк / Косылайық
Рет қаралды 700 М.