DR. SAS (Learn Base & Advanced SAS)
DR. SAS (Learn Base & Advanced SAS)
  • 54
  • 38 832
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!
Переглядів: 554

Відео

Where Statement In SAS - Interview Question
Переглядів 4269 місяців тому
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
Переглядів 5899 місяців тому
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
Переглядів 9319 місяців тому
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
Переглядів 99910 місяців тому
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
Переглядів 58411 місяців тому
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
Переглядів 89811 місяців тому
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
Переглядів 696Рік тому
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
Переглядів 826Рік тому
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 - ua-cam.com/video/f0w1xv8CzCg/v-deo.html
How To Divide SAS Table Into Multiple SAS Table - Interview Question
Переглядів 775Рік тому
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
Переглядів 465Рік тому
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
Переглядів 812Рік тому
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
Переглядів 352Рік тому
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
Переглядів 1,2 тис.Рік тому
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 - ua-cam.com/video/SN6Hmwm-z4A/v-deo.html
Update Statement - A Special Type Of Merge In SAS - Interview Question
Переглядів 430Рік тому
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
Переглядів 702Рік тому
Proc append in SAS - Interview Question
PROC MEAN VS MEAN FUNCTION IN SAS - Interview Question
Переглядів 635Рік тому
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
Переглядів 524Рік тому
How To Form a Date If Year, Month, and Day are Given In SAS - Interview Question
What Is Reverse Function In SAS ? - Interview Question
Переглядів 635Рік тому
What Is Reverse Function In SAS ? - Interview Question
DO WHILE VS DO UNTIL IN SAS - INTERVIEW QUESTION
Переглядів 879Рік тому
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
Переглядів 656Рік тому
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
Переглядів 863Рік тому
Translate And Tranwrd In SAS - Character Function - Interview Question
How To Get The Last Date Of A Month In SAS ? - Interview Question
Переглядів 650Рік тому
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
Переглядів 1,1 тис.Рік тому
How To Get The Second Highest Salary From A Dataset In SAS ? - Interview Question
Inobs and Outobs in Proc Sql || SASv9.4 || Interview Question
Переглядів 492Рік тому
Inobs and Outobs in Proc Sql || SASv9.4 || Interview Question
How To Find The Exact Age Of A Person Using SAS? - Interview Question
Переглядів 799Рік тому
How To Find The Exact Age Of A Person Using SAS? - Interview Question
How To Find Today's Date Using SAS? - Interview Question
Переглядів 417Рік тому
How To Find Today's Date Using SAS? - Interview Question
INDEX || INDEXC || INDEXW IN SAS
Переглядів 1,7 тис.Рік тому
INDEX || INDEXC || INDEXW IN SAS
ADVERSE EVENT VS CLINICAL EVENT IN SDTM || SAS || INTERVIEW QUESTION
Переглядів 641Рік тому
ADVERSE EVENT VS CLINICAL EVENT IN SDTM || SAS || INTERVIEW QUESTION
FIRSTOBS and OBS in SAS? Interview Question
Переглядів 444Рік тому
FIRSTOBS and OBS in SAS? Interview Question

КОМЕНТАРІ

  • @gupta126
    @gupta126 26 днів тому

    BEST CHANNEL TO LEARN SAS! HANDS DOWN! YOU HAVE BEEN A LIFE SAVER AT WORK FOR ME!

  • @13_alokamale71
    @13_alokamale71 Місяць тому

    THANK YOU SO MUCH FOR YOUR INFORMATION

  • @singampallieswari5677
    @singampallieswari5677 Місяць тому

    omgggg thank youu very much sir your videos helps me a lottt.

  • @purushotham714
    @purushotham714 4 місяці тому

    Thank you so much for clear explanation, please do videos regularly 🙏

  • @Manasi-m3n
    @Manasi-m3n 4 місяці тому

    Please upload more sdtm videos

  • @Manasi-m3n
    @Manasi-m3n 4 місяці тому

    Please upload more sdtm videos

  • @Manasi-m3n
    @Manasi-m3n 4 місяці тому

    Can you please upload more sdtm videos

  • @Swethareethika
    @Swethareethika 4 місяці тому

    good information for scan function(delimeter)

  • @vipulkaushik2294
    @vipulkaushik2294 4 місяці тому

    Amazing job👌

  • @rutujachavan9534
    @rutujachavan9534 5 місяців тому

    Concept is clear 👍🏻 Thank you . If possible give more examples.

  • @shazhu2455
    @shazhu2455 6 місяців тому

    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.

  • @juniorbosso6943
    @juniorbosso6943 7 місяців тому

    🎉great tutorial

  • @akd9977
    @akd9977 7 місяців тому

    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.

  • @satyaG-lj8bj
    @satyaG-lj8bj 7 місяців тому

    Please make a video on flow of creating data sets . which data sets create first and following remain in a project.

    • @divyanshu9535
      @divyanshu9535 5 місяців тому

      Packed with work , soon I'll start making videos again

  • @PenkeSiva-jo1lv
    @PenkeSiva-jo1lv 8 місяців тому

    thank you so much sir i got it

  • @nimmalaanitha3405
    @nimmalaanitha3405 8 місяців тому

    Thank you sir, Can you please explain about TLF AND macros

    • @divyanshu9535
      @divyanshu9535 8 місяців тому

      Suree soon I'll start making videos on it

  • @balaramamohan2370
    @balaramamohan2370 8 місяців тому

    Sir pls upload some Trail domain models 🙏 😀

  • @srinubabu1871
    @srinubabu1871 8 місяців тому

    Thankyou

  • @ananthuravalika7721
    @ananthuravalika7721 9 місяців тому

    Could u please tell me how to get only first observation?

    • @divyanshu9535
      @divyanshu9535 9 місяців тому

      If _n_ = 1 or firstobs= 1

    • @upendraarnepalli3848
      @upendraarnepalli3848 8 місяців тому

      How to extract both first and last observation from a dataset

    • @divyanshu9535
      @divyanshu9535 8 місяців тому

      @@upendraarnepalli3848 u can check my video on firstobs and obs.... ua-cam.com/video/t2GNRoz7kbw/v-deo.html

  • @nishasilori4222
    @nishasilori4222 9 місяців тому

    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

    • @divyanshu9535
      @divyanshu9535 9 місяців тому

      U can copy the syntax and paste it in comment section I'll check

  • @mohammadsaddam3
    @mohammadsaddam3 9 місяців тому

    Nice

  • @janaveebhoi6428
    @janaveebhoi6428 9 місяців тому

    Thank you for this informative video, please make video on clinical sas topics sdtm, adam, tlf

  • @srinubabu1871
    @srinubabu1871 9 місяців тому

    Thank You for your valuable videos. very useful for us. Could You post the proc ttest , proc mi,anova advanced SAS videos?

  • @Renuka-f8e
    @Renuka-f8e 9 місяців тому

    Hello sir gud mrng ur videos are sooo help to us thanku sooomuch and plz do more videos on sdtm Adam and tlfs

  • @ClinicalCodersCorner
    @ClinicalCodersCorner 9 місяців тому

    can we create FA (finding about) domain?

  • @ClinicalCodersCorner
    @ClinicalCodersCorner 9 місяців тому

    hello sir can you give one or two example of CUSTOM DOMAIN from real time project SDTM

    • @divyanshu9535
      @divyanshu9535 9 місяців тому

      Maybe I'll upload a video on it

  • @rajeshbehera2789
    @rajeshbehera2789 9 місяців тому

    Very good explanation about arrays ❤

  • @sowmyagudimella3641
    @sowmyagudimella3641 9 місяців тому

    Your explanation is very clear. Thank you so much...

  • @sipspdtre
    @sipspdtre 9 місяців тому

    Can you please tell me how to print last 5 obs

    • @divyanshu9535
      @divyanshu9535 9 місяців тому

      data want; set sashelp.class nobs=nobs; if _n_>nobs-5; run; this is an example for dataset sashelp.class

    • @sipspdtre
      @sipspdtre 9 місяців тому

      Thank you sir

  • @ajaykushwaha4233
    @ajaykushwaha4233 9 місяців тому

    Wrong, if more than 1 proper have same salary then this will not work.

    • @divyanshu9535
      @divyanshu9535 9 місяців тому

      Yes one drawback of this code, hence proc SQL is a better alternative for it ua-cam.com/video/y0n2fe1pZuk/v-deo.htmlsi=fflU5couK70-RXYf

  • @krishnaarumulla7254
    @krishnaarumulla7254 9 місяців тому

    Sir please make more detailed videos on sdtm domains

  • @TruptiUpadhyay-kl1bn
    @TruptiUpadhyay-kl1bn 10 місяців тому

    I like seeing your short videos which gives me brief introduction of main components in SAs👏🏻

  • @TruptiUpadhyay-kl1bn
    @TruptiUpadhyay-kl1bn 10 місяців тому

    Your All videos are amazing .. please do upload more n more videos to help understand SAS deliberately.

    • @divyanshu9535
      @divyanshu9535 10 місяців тому

      Thank you ! I'll be uploading more videos ..

  • @ajitmalakar6882
    @ajitmalakar6882 10 місяців тому

    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!

    • @divyanshu9535
      @divyanshu9535 10 місяців тому

      Soon I'll make a video on it

  • @yogendrasinghnegi4875
    @yogendrasinghnegi4875 10 місяців тому

    if you don't know how many numeric values are there then how you will perform do loop please ansr

    • @ravirai796
      @ravirai796 4 місяці тому

      We can use dim function in that we give array name, so it will take all numeric variables..dim(array name).

  • @vinaykurkal
    @vinaykurkal 10 місяців тому

    video is informative ! what happens if the height value is 60.5 in your example and will it format?

    • @divyanshu9535
      @divyanshu9535 10 місяців тому

      Yes vinay it will still work , u can try 😄

  • @janaveebhoi6428
    @janaveebhoi6428 11 місяців тому

    Very informative video you post sir, thank you. Please post sdtm mapping end to end and adam videos also sir. Thank you

    • @divyanshu9535
      @divyanshu9535 11 місяців тому

      Sure I'll post videos about sdtm Adam soon

  • @RaShu_HomeDecor
    @RaShu_HomeDecor 11 місяців тому

    How to join your Classes sir

    • @divyanshu9535
      @divyanshu9535 11 місяців тому

      I'm only available in UA-cam where I make videos 😄 I don't take classes

  • @venodhayachary-techstuff9146
    @venodhayachary-techstuff9146 11 місяців тому

    Excellent explanation

  • @40rohankale29
    @40rohankale29 11 місяців тому

    Please make more videos on scenario based questions

  • @khruthik1165
    @khruthik1165 11 місяців тому

    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

  • @lingamounika7079
    @lingamounika7079 Рік тому

    Just wow

  • @tanvinemane5418
    @tanvinemane5418 Рік тому

    Really Good explanation! Thank you so much for sharing.

  • @nayakbibhuti085
    @nayakbibhuti085 Рік тому

    Can’t we use intck option

  • @nayakbibhuti085
    @nayakbibhuti085 Рік тому

    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.

    • @divyanshu9535
      @divyanshu9535 Рік тому

      Proc rank can be used Or Sort the data and use if _n_ = 4 then do output

    • @nayakbibhuti085
      @nayakbibhuti085 Рік тому

      @@divyanshu9535 thank you

  • @Farming_talks
    @Farming_talks Рік тому

    Sir please make vedios like these it would be more helpful for us

    • @divyanshu9535
      @divyanshu9535 Рік тому

      Occupied with smthing Soon I'll start making videos again

  • @GrapeWine-u5m
    @GrapeWine-u5m Рік тому

    please make a SAS complete tutorial for scratch to advanced level

  • @Pandimoori_krish
    @Pandimoori_krish Рік тому

    Sir How to remove duplicates Proc sql; Select name,sex ,distinct age from sashelp.class group by name ; quit; Its not given correct output

    • @divyanshu9535
      @divyanshu9535 Рік тому

      Proc sql; Select distinct age, name, sex From sashelp.class Order by name; Quit; This will be correct 💯

  • @ananthuravalika7721
    @ananthuravalika7721 Рік тому

    Do we have clinical sas programmer jobs in present times?pls help me sir

    • @divyanshu9535
      @divyanshu9535 Рік тому

      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

    • @ananthuravalika7721
      @ananthuravalika7721 Рік тому

      TQ sir

    • @BelideKalyani
      @BelideKalyani 8 місяців тому

      Good info. I learnt a new thing short varnum, which I haven't seen earlier