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
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.
Very nice video...
Sometime we use but this is actually with reasons...👌👌
Thanks for the video
Thanks and very usefull.
Glad it was helpful!
Finally we would love to watch ur videos..do more videos sir
Sorry, was busy with my daily job and could not create more videos. Now I have some time, so will create more
Awesome, if you add SDTM or Adam topic then thing will be superb.
We will try
Very useful videos. Please upload more scenario based interview questions.
Super explanation sir keep it up
I am glad you liked it. Thanks
Wanted more explanation on local and global variables and wanted interview questions on functions
Very nice explanation sir, please do more videos on Macros
Sure I will do.
can you please make a video how to pic latest file available by using SAS Macro
Hi, I will create one soon.
Rolling cumulative count possible with proc SQL if so please give details
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
Thank you for giving reply n this question shooted by one interviewer recently.
Symdel and call symdel both same or not those can delete local ,global macro variable ?
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.
@@sasworld2021
Thank you sir 🙏
call symputx does it applies both characteric and numeric varikables
Yes