MACROS IN SAS - 1 | Introduction to Macros in SAS | Writing Your First Macro in SAS | SAS Macro Prog

This video introduces you to the Macros in SAS which Illustrates the Automation of Codes in SAS Using Macros. This explains the concept of Macros with the helps of an example.
#Learnerea
#SASTraining #SASTutorial #SASCourse #SASTutorialForBeginners #SAS #SASforBeginners
#SASProgramming #SASTProgrammingForBeginners #SASProgrammingTutorial
Contacts:
Facebook ► / learnerea
Download the excel files for practice data
GitHub ► github.com/LEARNEREA/Excel_Files

[@SGH-rt6ci]

I am new to SAS and I find your tutorial very helpful . First of all I can replicate everything you write and check for myself. Second - you use the SAS data sets I can easily work your code and test. Third -- examples are real life examples that I can use in my daily work. Thank You Sir for your effort and for sharing your knowledge

[@learnerea]

Thank you for the complement @SGH 2018

[@bibhushakarki2928]

Thank you so much! I am taking a SAS class through schoool and loosing my mind. You saved my life! Thank you!!

[@learnerea]

Glad it helped you

[@adityabatra8894]

Where we use arrays in sas

[@swatigavhale381]

Thanku for simplifying it Sir

[@learnerea]

Glad you liked it

[@adityabatra8894]

Please upload some arrays live example

[@learnerea]

Hi,
Thanks for watching this.
For arrays, we have already uploaded on video which you can watch by using the below link
czcams.com/video/3j-UKFrv3tc/video.html

[@indrajeetjaiswar7177]

Hi, A Great efforts can be seen video on video. That's Really Appreciated. Rally helpful. Thank You @Learnerea
Am having a doubt in the same example you shown above. Actually i am trying to make this macro for all type_of_cars in one go and while on calling the same macro would like to specify the Type of car for that data needs to populated which can be one or more types basis need....
can you pls help ??

[@learnerea]

If I have understood the problem statement correctly then the following example should be helpful to solve the same.. it's just you would require to understand the same and apply in your context.
If this doesn't help, I recommend you put your problem statement with example, will try to solve the same.

[@ajaykushwaha-je6mw]

Hi Sir, at line no 12 you have mention group by 1,2; what is 1 and 2 ?

[@learnerea]

1 represents to column first in select statement and 2 for column second in the selecte statement which are "type" and "origin" in this example

[@madhukinjarapu9743]

The quoted string currently being processed has become more than 262 bytes long. You might have unbalanced quotation marks.... I GOT THIS NOTE... CAN SOME ONE HELP...

[@learnerea]

can you put your code here please, we will review that

[@RameshKumar-im7li]

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 solve this problem sir

[@learnerea]

there must be a conditon basis on which you would like to split the data into two or multiple.. if you come up with certain condition, I might help you...