- 54
- 27 631
DR. SAS (Learn Base & Advanced SAS)
India
Registrace 5. 09. 2023
Welcome to the official DR .SAS channel on CZcams! Here you will find easy to understand sessions on BASE SAS , ADVANCED SAS, SDTM , AdaM, TLF , SAS GRAPH.
You will also find interesting interview questions covered and other information regarding clinical SAS .
Don't forget to subscribe my channel for best learning experience.
You will also find interesting interview questions covered and other information regarding clinical SAS .
Don't forget to subscribe my channel for best learning experience.
Converting Multiple Variables In SAS From '0' & '1' TO 'YES' & 'NO' - Interview Question
In this video, I have covered how to convert multiple variable values from 0 and 1 to yes and no in Sas
if you guys have any doubts kindly write in the comments.
Don't forget to subscribe to my channel!
Happy learning!
if you guys have any doubts kindly write in the comments.
Don't forget to subscribe to my channel!
Happy learning!
zhlédnutí: 354
Video
Where Statement In SAS - Interview Question
zhlédnutí 248Před 3 měsíci
In this video, I have covered how to filter the data using where in SAS. if you guys have any doubts kindly write in the comments. Don't forget to subscribe to my channel! Happy learning!
Highest Salary Based On Department Using Proc Rank In SAS - Interview Question
zhlédnutí 409Před 4 měsíci
In this video, I have covered how to get the highest salary based on the Department Using Proc Rank In SAS. If you guys have any doubts kindly write in the comments. Don't forget to subscribe to my channel! Happy Learning!
Proc Means In SAS - Interview Question
zhlédnutí 494Před 4 měsíci
in this video, I have covered Proc Means In SAS. if you guys have any doubts kindly write in the comments section. Don't forget to subscribe to my channel! Happy Learning!
Difference Between EX and EC in SAS SDTM - Interview Question
zhlédnutí 623Před 5 měsíci
In this video, I have covered the difference between EX and EC in SDTM in SAS. If you guys have any doubts kindly write in the comments. Don't forget to subscribe to my channel! Happy Learning!
INPUT AND PUT FUNCTION IN SAS - INTERVIEW QUESTION
zhlédnutí 376Před 6 měsíci
In this video, I have covered how to convert character variables into numeric variables and vice versa SAS. if you guys have any doubts kindly write in the comments. Don't forget to subscribe to my channel! Daily I'll be uploading one video. happy learning!
Proc Univariate | Proc Univariate VS Proc Means | Interview Question
zhlédnutí 572Před 6 měsíci
In this video, I have covered Proc Univariate in SAS. if you guys have any doubts kindly write in the comments. Don't forget to subscribe to my channel! Happy learning!
How To Remove Duplicates Using Proc SQL In SAS - Interview Question
zhlédnutí 558Před 9 měsíci
in this video, I have covered how to Remove Duplicates Using Proc SQL in SAS. if you guys have any doubts kindly write in the comments. Don't forget to subscribe to my channel! Daily I'll be uploading one video. happy learning!
Using Datastep To Get Second Highest Salary In SAS - Interview Question
zhlédnutí 693Před 9 měsíci
In this video, I have covered how to use Datastep to get second second-highest salary in SAS. if you guys have any doubts kindly write in the comments. Don't forget to subscribe to my channel! Daily I'll be uploading one video. happy learning! Proc SQL to get second highest salary - czcams.com/video/f0w1xv8CzCg/video.html
How To Divide SAS Table Into Multiple SAS Table - Interview Question
zhlédnutí 637Před 9 měsíci
in this video, I have covered How To Divide the SAS Table Into Multiple Sas Table. if you guys have any doubts kindly write in the comments. Don't forget to subscribe to my channel! Daily I'll be uploading one video. happy learning!
%Eval and %Sysevalf Function In Macros - SAS Interview Question
zhlédnutí 378Před 9 měsíci
In this video, I have covered %eval and %sysevalf function in SAS. if you guys have any doubts kindly write in the comments. Don't forget to subscribe to my channel! Daily I'll be uploading one video. happy learning!
PROC MEANS VS PROC SUMMARY IN SAS - INTERVIEW QUESTION
zhlédnutí 582Před 9 měsíci
In this video, I have covered Proc Means VS Proc Summary in SAS. if you guys have any doubts kindly write in the comments. Don't forget to subscribe to my channel! Daily I'll be uploading one video. happy learning!
How To Use " IF -THEN -ELSE " In Proc SQL - SAS - Interview Question
zhlédnutí 280Před 9 měsíci
In this video, I have covered CASE WHEN IN SAS. if you guys have any doubts kindly write in the comments. Don't forget to subscribe to my channel! Daily I'll be uploading one video. happy learning!
Find Function In SAS - Interview Question
zhlédnutí 872Před 9 měsíci
in this video, I have Find Function in SAS. if you guys have any doubts kindly write in the comments. Don't forget to subscribe to my channel! Daily I'll be uploading one video. happy learning! INDEX FUNCTION VIDEO - czcams.com/video/SN6Hmwm-z4A/video.html
Update Statement - A Special Type Of Merge In SAS - Interview Question
zhlédnutí 339Před 10 měsíci
in this video, I have covered Update Statement in SAS. if you guys have any doubts kindly write in the comments. Don't forget to subscribe to my channel! Daily I'll be uploading one video. happy learning!
Proc append in SAS - Interview Question
zhlédnutí 534Před 10 měsíci
Proc append in SAS - Interview Question
PROC MEAN VS MEAN FUNCTION IN SAS - Interview Question
zhlédnutí 477Před 10 měsíci
PROC MEAN VS MEAN FUNCTION IN SAS - Interview Question
How To Form a Date If Year, Month, and Day are Given In SAS - Interview Question
zhlédnutí 448Před 10 měsíci
How To Form a Date If Year, Month, and Day are Given In SAS - Interview Question
What Is Reverse Function In SAS ? - Interview Question
zhlédnutí 464Před 10 měsíci
What Is Reverse Function In SAS ? - Interview Question
DO WHILE VS DO UNTIL IN SAS - INTERVIEW QUESTION
zhlédnutí 562Před 10 měsíci
DO WHILE VS DO UNTIL IN SAS - INTERVIEW QUESTION
How To Extract First-name, Age, and Last-name From A Given String In SAS - Interview Question
zhlédnutí 509Před 10 měsíci
How To Extract First-name, Age, and Last-name From A Given String In SAS - Interview Question
Translate And Tranwrd In SAS - Character Function - Interview Question
zhlédnutí 585Před 10 měsíci
Translate And Tranwrd In SAS - Character Function - Interview Question
How To Get The Last Date Of A Month In SAS ? - Interview Question
zhlédnutí 509Před 10 měsíci
How To Get The Last Date Of A Month In SAS ? - Interview Question
How To Get The Second Highest Salary From A Dataset In SAS ? - Interview Question
zhlédnutí 893Před 10 měsíci
How To Get The Second Highest Salary From A Dataset In SAS ? - Interview Question
Inobs and Outobs in Proc Sql || SASv9.4 || Interview Question
zhlédnutí 394Před 10 měsíci
Inobs and Outobs in Proc Sql || SASv9.4 || Interview Question
How To Find The Exact Age Of A Person Using SAS? - Interview Question
zhlédnutí 598Před 10 měsíci
How To Find The Exact Age Of A Person Using SAS? - Interview Question
How To Find Today's Date Using SAS? - Interview Question
zhlédnutí 293Před 10 měsíci
How To Find Today's Date Using SAS? - Interview Question
ADVERSE EVENT VS CLINICAL EVENT IN SDTM || SAS || INTERVIEW QUESTION
zhlédnutí 449Před 11 měsíci
ADVERSE EVENT VS CLINICAL EVENT IN SDTM || SAS || INTERVIEW QUESTION
FIRSTOBS and OBS in SAS? Interview Question
zhlédnutí 331Před 11 měsíci
FIRSTOBS and OBS in SAS? Interview Question
Concept is clear 👍🏻 Thank you . If possible give more examples.
Great tutorial! One very important thing you never mentioned is that these functions are all case-sensitive. Also, indexc(string, ‘abc’) = indexc(string, ‘a’, ‘b’, ‘c’). It would be great if you can mention FIND and FINDC functions, which have additional capabilities over INDEX and INDEXC functions.
🎉great tutorial
Thank you for sharing in details. Why don't you create one to two video every week so that all SDTM, ADAM will be covered without waiting for a month.
Please make a video on flow of creating data sets . which data sets create first and following remain in a project.
Packed with work , soon I'll start making videos again
thank you so much sir i got it
Thank you sir, Can you please explain about TLF AND macros
Suree soon I'll start making videos on it
Sir pls upload some Trail domain models 🙏 😀
Suree 😁
Thankyou
Could u please tell me how to get only first observation?
If _n_ = 1 or firstobs= 1
How to extract both first and last observation from a dataset
@@upendraarnepalli3848 u can check my video on firstobs and obs.... czcams.com/video/t2GNRoz7kbw/video.html
Hi I have written same code but I am getting error statement is not valid or it is used out of proper order Kindly reply
U can copy the syntax and paste it in comment section I'll check
Nice
Thanx 😃
Thank you for this informative video, please make video on clinical sas topics sdtm, adam, tlf
Sureee 😃
Thank You for your valuable videos. very useful for us. Could You post the proc ttest , proc mi,anova advanced SAS videos?
Sure 😄
Hello sir gud mrng ur videos are sooo help to us thanku sooomuch and plz do more videos on sdtm Adam and tlfs
can we create FA (finding about) domain?
Yes
hello sir can you give one or two example of CUSTOM DOMAIN from real time project SDTM
Maybe I'll upload a video on it
Very good explanation about arrays ❤
thankuu
Your explanation is very clear. Thank you so much...
welcome
Can you please tell me how to print last 5 obs
data want; set sashelp.class nobs=nobs; if _n_>nobs-5; run; this is an example for dataset sashelp.class
Thank you sir
Wrong, if more than 1 proper have same salary then this will not work.
Yes one drawback of this code, hence proc SQL is a better alternative for it czcams.com/video/y0n2fe1pZuk/video.htmlsi=fflU5couK70-RXYf
Sir please make more detailed videos on sdtm domains
Suree 😁
I like seeing your short videos which gives me brief introduction of main components in SAs👏🏻
Thanx 😁
Your All videos are amazing .. please do upload more n more videos to help understand SAS deliberately.
Thank you ! I'll be uploading more videos ..
Sir please create a video on call symput with multiple examples. I really liked your videos and I'm watching these 1 by 1 with making necessary notes. Thank you in advance!
Soon I'll make a video on it
if you don't know how many numeric values are there then how you will perform do loop please ansr
video is informative ! what happens if the height value is 60.5 in your example and will it format?
Yes vinay it will still work , u can try 😄
Very informative video you post sir, thank you. Please post sdtm mapping end to end and adam videos also sir. Thank you
Sure I'll post videos about sdtm Adam soon
How to join your Classes sir
I'm only available in CZcams where I make videos 😄 I don't take classes
Excellent explanation
Please make more videos on scenario based questions
Sure
Hi sir can u please send us any file related for base sas certification exam we really wants because in anysource we wont find the base sas certification questions so can u send any file to us please
I'll try to do that
Just wow
Really Good explanation! Thank you so much for sharing.
Welcome
Can’t we use intck option
Yes but exact age with this method
Nice explanation Thank you,If we check like this way then need to write 5 steps to get 4 th highest salary . Could you please tell me any alternative way.
Proc rank can be used Or Sort the data and use if _n_ = 4 then do output
@@divyanshu9535 thank you
What is difference b/w length and countw ?
Countw helps to count the number of words in a string Length returns the length of a character string excluding the trailing blank
Sir please make vedios like these it would be more helpful for us
Occupied with smthing Soon I'll start making videos again
please make a SAS complete tutorial for scratch to advanced level
Sure
Sir How to remove duplicates Proc sql; Select name,sex ,distinct age from sashelp.class group by name ; quit; Its not given correct output
Proc sql; Select distinct age, name, sex From sashelp.class Order by name; Quit; This will be correct 💯
Do we have clinical sas programmer jobs in present times?pls help me sir
Be active in LinkedIn you will find it Currently for freshers I guess SCL IT technology company Hyderabad is hiring Search their company name U will find a post
TQ sir
Good info. I learnt a new thing short varnum, which I haven't seen earlier
Sir could you pls tell me on how to get last Friday of every month?
data friday; do year=2001 to 2013; do month = 1 to 12; b = mdy(month,1,year); e = intnx('Month',b,0,'E'); f = intnx('week.6',e,0,'B'); output; end; end; format b e f weekdate.; run; proc print; run;* *ANY QUESTIONS SAS SQL ASK IT'S HELP OTHERS👍*
It is complicated I'll make a video on it
If same values then this method not achived
That time output will be based on descending alphabet names But the second highest salary amount will be correct
@@divyanshu9535 If second highest values have two values this method not correct
@@BHARATHEEYUDU. It will come Just that only one value and name will be shown in descending order
@@divyanshu9535 data second; input number; cards; 98 49 58 97 69 97 70 ; run;
Hi Dear, Hope you are doing gr8, I have total 4.5 years of experience in SAS programming and i was working as a SAS programmer in my last company SBI card in Gurgaon location, dear but unfortunately i had to go through slip disc surgery last year, so still i am on bed rest, but for keep in touch i regularly watch your youtube videos which helps to me get updated, thanx a lot dear, may god bless you
I wish for your speedy recovery ❤️ And thank you for showing love and support for my channel
Tq for ur video sir,as i asked this question you made a video on it,iam so glad...
Welcome
sir could you pls tell me how to do this by using datastep?
ill make a short video on it and upload
Hi which SAS Function is used to convert a given column value 27-10-2023 to 01-10-2023
Intnx function with alignment b
@@divyanshu9535 can you show one example
Also if you can show example for below also write a sas Macro to divide any given table (table name = input table)such a way that each table has 10 rows from the original table (the final table can have <=10 rows)
Intnx('month', date , 0 , 'b');
@@aanchalsrivastava8550 no need for macro We can use proc survey select I'll make a video on it
You are providing valuable content, keep doing bro👏.
Thank you Stay tuned for more videos !
Hello sir,I have been under clinical sas training,how is the job market for clinical sas in present days?could you pls tell me sir?
I will make a detailed video on it But right now clinical sas opportunity for freshers is slightly low U will need patience to get into it Growth is really good once u get in