SAS MACRO INTERVIEW QUESTIONS 1 | SAS ADVANCED TRAINING

SAS MACRO INTERVIEW QUESTIONS AND ANSWERS | SAS MACRO TRAINING
This SAS tutorial contains below topics on SAS macro variables
Key Questions:
Time Topics
MM:SS
00:23 What are the various ways to create macro variables in SAS?
01:21 What is the difference between Call Symput and call Symputx?
04:03 Write a program to print all the macro variables in SAS log?
05:10 What would be the value of variable z in SAS log and why?
08:22 What would be the value of variable x inside macro and outside macro definition in below
program and why?
14:48 How can you remove a macro variable?
Channel contact details:
[e-mail]

[@albertneil290]

Very nice video...
Sometime we use but this is actually with reasons...👌👌
Thanks for the video

[@swathiemayavaramban7477]

Very useful videos. Please upload more scenario based interview questions.

[@_MANI_5]

Finally we would love to watch ur videos..do more videos sir

[@sasworld2021]

Sorry, was busy with my daily job and could not create more videos. Now I have some time, so will create more

[@ajaykushwaha4233]

Awesome, if you add SDTM or Adam topic then thing will be superb.

[@sasworld2021]

We will try

[@shyamkumargaikwad684]

Thanks and very usefull.

[@sasworld2021]

Glad it was helpful!

[@baali735]

Wanted more explanation on local and global variables and wanted interview questions on functions

[@BHARATHEEYUDU.]

Super explanation sir keep it up

[@sasworld2021]

I am glad you liked it. Thanks

[@purushotham714]

Very nice explanation sir, please do more videos on Macros

[@sasworld2021]

Sure I will do.

[@jagadeeshmypati4085]

can you please make a video how to pic latest file available by using SAS Macro

[@sasworld2021]

Hi, I will create one soon.

[@ravurisudheer176]

Rolling cumulative count possible with proc SQL if so please give details

[@sasworld2021]

Yes, it's possible. See below program:
data salary;
input sal;
datalines;
100
200
300
400
;
run;
proc sql;
create table cumulative_salary as
select a.*,(select sum(sal) from salary as cm where cm.sal

[@ravurisudheer176]

Thank you for giving reply n this question shooted by one interviewer recently.

[@ramubuddi8733]

call symputx does it applies both characteric and numeric varikables

[@sasworld2021]

Yes

[@BHARATHEEYUDU.]

Symdel and call symdel both same or not those can delete local ,global macro variable ?

[@sasworld2021]

Both are not same, call symdel can delete only one variable at a time where as %symdel can delete multiple variables. Both removes global macro variables.

[@BHARATHEEYUDU.]

@@sasworld2021
Thank you sir 🙏