- 339
- 624 199
mycsg
India
Приєднався 27 жов 2014
Відео
SDTM: TR domain - Easily remember the variables in TR domain
Переглядів 1,2 тис.5 місяців тому
www.mycsg.in
SDTM: TU domain - Easily remember the variables in TU domain
Переглядів 1,6 тис.5 місяців тому
www.mycsg.in
Clinical SAS: Maximum allowed Dataset size and How to split it
Переглядів 1 тис.6 місяців тому
Clinical SAS: Maximum allowed Dataset size and How to split it
Clinical SAS: Introduction to US FDA Data Standards Catalog
Переглядів 9846 місяців тому
Clinical SAS: Introduction to US FDA Data Standards Catalog
Clinical SAS: ADaM BDS: 6 Rules: Easily remember the rules
Переглядів 3 тис.7 місяців тому
www.mycsg.in/tasks.php?area=TASKS&concept=HIS Other Playlists: R for SAS programmers: ua-cam.com/play/PLPtw8CzW9VNWFXjD18xPqkW_i0ta0yqSm.html SDTM with R:ua-cam.com/play/PLPtw8CzW9VNXA_F-9r0fyN6_WEWfVK-Zc.html ADaM with R: ua-cam.com/play/PLPtw8CzW9VNUOd83_abB4DdkB-wHt9WIs.html TFLs with R: ua-cam.com/play/PLPtw8CzW9VNWSNHhIbtAhpOzqFYSvi2xq.html SDTM (SAS): ua-cam.com/play/PLPtw8CzW9VNVo8Fs18CV...
Clinical SAS: SDTM - Difference between BLFL and LOBXFL
Переглядів 2,2 тис.7 місяців тому
www.mycsg.in/tasks.php?area=TASKS&concept=HIS Other Playlists: R for SAS programmers: ua-cam.com/play/PLPtw8CzW9VNWFXjD18xPqkW_i0ta0yqSm.html SDTM with R:ua-cam.com/play/PLPtw8CzW9VNXA_F-9r0fyN6_WEWfVK-Zc.html ADaM with R: ua-cam.com/play/PLPtw8CzW9VNUOd83_abB4DdkB-wHt9WIs.html TFLs with R: ua-cam.com/play/PLPtw8CzW9VNWSNHhIbtAhpOzqFYSvi2xq.html SDTM (SAS): ua-cam.com/play/PLPtw8CzW9VNVo8Fs18CV...
Clinical SAS: Check if a dose of a concomitant medication is taken within study treatment period
Переглядів 1,2 тис.9 місяців тому
www.mycsg.in/tasks.php?area=TASKS&concept=HIS Other Playlists: R for SAS programmers: ua-cam.com/play/PLPtw8CzW9VNWFXjD18xPqkW_i0ta0yqSm.html SDTM with R:ua-cam.com/play/PLPtw8CzW9VNXA_F-9r0fyN6_WEWfVK-Zc.html ADaM with R: ua-cam.com/play/PLPtw8CzW9VNUOd83_abB4DdkB-wHt9WIs.html TFLs with R: ua-cam.com/play/PLPtw8CzW9VNWSNHhIbtAhpOzqFYSvi2xq.html SDTM (SAS): ua-cam.com/play/PLPtw8CzW9VNVo8Fs18CV...
Clinical SAS: Filter all records of subjects with a duplicate record in ADSL
Переглядів 7269 місяців тому
www.mycsg.in/tasks.php?area=TASKS&concept=HIS Other Playlists: R for SAS programmers: ua-cam.com/play/PLPtw8CzW9VNWFXjD18xPqkW_i0ta0yqSm.html SDTM with R:ua-cam.com/play/PLPtw8CzW9VNXA_F-9r0fyN6_WEWfVK-Zc.html ADaM with R: ua-cam.com/play/PLPtw8CzW9VNUOd83_abB4DdkB-wHt9WIs.html TFLs with R: ua-cam.com/play/PLPtw8CzW9VNWSNHhIbtAhpOzqFYSvi2xq.html SDTM (SAS): ua-cam.com/play/PLPtw8CzW9VNVo8Fs18CV...
Clinical SAS: Compare a table output dataset after removing spaces
Переглядів 5359 місяців тому
www.mycsg.in/tasks.php?area=TASKS&concept=HIS Other Playlists: R for SAS programmers: ua-cam.com/play/PLPtw8CzW9VNWFXjD18xPqkW_i0ta0yqSm.html SDTM with R:ua-cam.com/play/PLPtw8CzW9VNXA_F-9r0fyN6_WEWfVK-Zc.html ADaM with R: ua-cam.com/play/PLPtw8CzW9VNUOd83_abB4DdkB-wHt9WIs.html TFLs with R: ua-cam.com/play/PLPtw8CzW9VNWSNHhIbtAhpOzqFYSvi2xq.html SDTM (SAS): ua-cam.com/play/PLPtw8CzW9VNVo8Fs18CV...
Clinical SAS: Last dosing date before an adverse event start date
Переглядів 7859 місяців тому
www.mycsg.in/tasks.php?area=TASKS&concept=HIS Other Playlists: R for SAS programmers: ua-cam.com/play/PLPtw8CzW9VNWFXjD18xPqkW_i0ta0yqSm.html SDTM with R:ua-cam.com/play/PLPtw8CzW9VNXA_F-9r0fyN6_WEWfVK-Zc.html ADaM with R: ua-cam.com/play/PLPtw8CzW9VNUOd83_abB4DdkB-wHt9WIs.html TFLs with R: ua-cam.com/play/PLPtw8CzW9VNWSNHhIbtAhpOzqFYSvi2xq.html SDTM (SAS): ua-cam.com/play/PLPtw8CzW9VNVo8Fs18CV...
Clinical SAS: Change from previous non-missing result
Переглядів 5659 місяців тому
www.mycsg.in/tasks.php?area=TASKS&concept=HIS Other Playlists: R for SAS programmers: ua-cam.com/play/PLPtw8CzW9VNWFXjD18xPqkW_i0ta0yqSm.html SDTM with R:ua-cam.com/play/PLPtw8CzW9VNXA_F-9r0fyN6_WEWfVK-Zc.html ADaM with R: ua-cam.com/play/PLPtw8CzW9VNUOd83_abB4DdkB-wHt9WIs.html TFLs with R: ua-cam.com/play/PLPtw8CzW9VNWSNHhIbtAhpOzqFYSvi2xq.html SDTM (SAS): ua-cam.com/play/PLPtw8CzW9VNVo8Fs18CV...
Clinical SAS: Check if an element start date is same as previous element end date in SE
Переглядів 5329 місяців тому
www.mycsg.in/tasks.php?area=TASKS&concept=HIS Other Playlists: R for SAS programmers: ua-cam.com/play/PLPtw8CzW9VNWFXjD18xPqkW_i0ta0yqSm.html SDTM with R:ua-cam.com/play/PLPtw8CzW9VNXA_F-9r0fyN6_WEWfVK-Zc.html ADaM with R: ua-cam.com/play/PLPtw8CzW9VNUOd83_abB4DdkB-wHt9WIs.html TFLs with R: ua-cam.com/play/PLPtw8CzW9VNWSNHhIbtAhpOzqFYSvi2xq.html SDTM (SAS): ua-cam.com/play/PLPtw8CzW9VNVo8Fs18CV...
Clinical SAS: Get the latest transfusion date on or before each lab collection date
Переглядів 3829 місяців тому
www.mycsg.in/tasks.php?area=TASKS&concept=HIS Other Playlists: R for SAS programmers: ua-cam.com/play/PLPtw8CzW9VNWFXjD18xPqkW_i0ta0yqSm.html SDTM with R:ua-cam.com/play/PLPtw8CzW9VNXA_F-9r0fyN6_WEWfVK-Zc.html ADaM with R: ua-cam.com/play/PLPtw8CzW9VNUOd83_abB4DdkB-wHt9WIs.html TFLs with R: ua-cam.com/play/PLPtw8CzW9VNWSNHhIbtAhpOzqFYSvi2xq.html SDTM (SAS): ua-cam.com/play/PLPtw8CzW9VNVo8Fs18CV...
Clinical SAS: Extract the last two characters from the values of a character variable
Переглядів 7549 місяців тому
www.mycsg.in/tasks.php?area=TASKS&concept=HIS Other Playlists: R for SAS programmers: ua-cam.com/play/PLPtw8CzW9VNWFXjD18xPqkW_i0ta0yqSm.html SDTM with R:ua-cam.com/play/PLPtw8CzW9VNXA_F-9r0fyN6_WEWfVK-Zc.html ADaM with R: ua-cam.com/play/PLPtw8CzW9VNUOd83_abB4DdkB-wHt9WIs.html TFLs with R: ua-cam.com/play/PLPtw8CzW9VNWSNHhIbtAhpOzqFYSvi2xq.html SDTM (SAS): ua-cam.com/play/PLPtw8CzW9VNVo8Fs18CV...
Clinical SAS: Identify the overlap of dates in exposure intervals
Переглядів 8509 місяців тому
Clinical SAS: Identify the overlap of dates in exposure intervals
Clinical SAS: SDTM - FA - Findings About (Gastroenteritis) dataset programming - SDTM_FA_LGE01
Переглядів 2,1 тис.10 місяців тому
Clinical SAS: SDTM - FA - Findings About (Gastroenteritis) dataset programming - SDTM_FA_LGE01
Clinical SAS: SDTM - CE - Clinical Events (Gastroenteritis) dataset programming - SDTM_CE_LGE01
Переглядів 1,3 тис.10 місяців тому
Clinical SAS: SDTM - CE - Clinical Events (Gastroenteritis) dataset programming - SDTM_CE_LGE01
Clinical SAS: SDTM - IE - Inclusion/Exclusion Criteria Not Met- SDTM_IE_L101
Переглядів 1,2 тис.10 місяців тому
Clinical SAS: SDTM - IE - Inclusion/Exclusion Criteria Not Met- SDTM_IE_L101
Clinical SAS: SDTM - AE - Adverse Events dataset programming - SDTM_AE_LCSG001
Переглядів 4,5 тис.10 місяців тому
Clinical SAS: SDTM - AE - Adverse Events dataset programming - SDTM_AE_LCSG001
Clinical SAS: SDTM - FT - Functional Tests - Six Minute Walking Test- SDTM_FT_L6MWT
Переглядів 50610 місяців тому
Clinical SAS: SDTM - FT - Functional Tests - Six Minute Walking Test- SDTM_FT_L6MWT
Clinical SAS: SDTM - EX- Exposure - domain creation - SDTM_EX_LCSG001
Переглядів 2,5 тис.10 місяців тому
Clinical SAS: SDTM - EX- Exposure - domain creation - SDTM_EX_LCSG001
Clinical SAS: SDTM - EC- Exposure as collected - domain creation - SDTM_EC_LCSG001
Переглядів 1,4 тис.10 місяців тому
Clinical SAS: SDTM - EC- Exposure as collected - domain creation - SDTM_EC_LCSG001
Clinical SAS: SDTM - RP- Reproductive System Findings domain creation - SDTM_RP_L101
Переглядів 40410 місяців тому
Clinical SAS: SDTM - RP- Reproductive System Findings domain creation - SDTM_RP_L101
Clinical SAS: SDTM - PR- Procedures domain creation - SDTM_PR_L101
Переглядів 84410 місяців тому
Clinical SAS: SDTM - PR- Procedures domain creation - SDTM_PR_L101
Clinical SAS: SDTM - TI - Trial Inclusion/Exclusion Criteria domain creation - SDTM_TI_LCSG801
Переглядів 91910 місяців тому
Clinical SAS: SDTM - TI - Trial Inclusion/Exclusion Criteria domain creation - SDTM_TI_LCSG801
Clinical SAS: SDTM - TV - Trial visit domain creation - SDTM_TV_LCSG801
Переглядів 1,3 тис.10 місяців тому
Clinical SAS: SDTM - TV - Trial visit domain creation - SDTM_TV_LCSG801
Clinical SAS: SDTM - TA - Trial Arms domain creation - SDTM_TA_LCSG801
Переглядів 1,9 тис.10 місяців тому
Clinical SAS: SDTM - TA - Trial Arms domain creation - SDTM_TA_LCSG801
Clinical SAS: SDTM - TE - Trial Elements domain creation
Переглядів 1,3 тис.10 місяців тому
Clinical SAS: SDTM - TE - Trial Elements domain creation
Clinical SAS: SDTM - Easily remember examples of The three general observation classes
Переглядів 1,2 тис.11 місяців тому
Clinical SAS: SDTM - Easily remember examples of The three general observation classes
instead of writing months with if then conditions . can we use formats for it? please reply sir...
yes...you can use any other alternative approaches which gives the same result..
hai, Whats the need of where 1=1 i really could not understand. thanks for your videos.
it's just a placeholder filter... it technically filters all data from the input dataset... output wouldn't be impacted even if we remove that line of code
Hi sir as per spec we assign dsstdtc variable derivation, but my doubt is most of the cases we must and should assign rficdtc variable direct from DM domain to rficdt variable correct sir??
yes, those two will be in sync in most cases ... we can use rficdtc also ...
@@mycsg Thank you sir
Thanks
Welcome
Thank you so much for this video. Please keep making more videos if you have time.
Thank you, I will
Nice explanation for TLFs thank you so much for real time project explanation,please upload ADAM related Real time scenarios
glad you found it helpful... for ADaM , please see the adam playlist. there are a lot of concepts covered
This video is very helpfull please upload some more videos for TLFs thank you so much sharing this.......................👏👏👏👏👏
sure. glad you found it helpful...
Hi @mycsg thanks for the easy understanding way of teaching. I have a little confusion about Domains like in my mnc most of them communicate as EFFICACY Domains, SAFETY Domains. What are they and on what basis they were classified as it is.
Open to anyone's response
a dataset may get classified as efficacy if it contains some information that is used to evaluate efficacy as determined in the protocol... all the other datasets may get classified as safety... so, the classification of the data using this terminology is very study specific...
Hi sir , thanks for insights of timing variables, here PCRFTDTC means can we assume RFSTDTC?
if pk samples are collected after different doses, the value in pcrftdtc will differ on different rows . so, we cannot directly assume that it is same as rfstdtc without knowing the study design
Cannot stress how valuable this channel is going to be. I found this a day prior to my interview for the Clinical DBA role at an oncology center and I have binged through your videos all afternoon. Unlike other channels, you have amazing explanation and presentation skills, your mic is good, wwell defined and segregated playlists and a webstie with loads of resources to learn from. I would definitely carry on learning from you. If I happen to secure this job, my success at work will be owed to you
Hi Joel, your comment actually resonates with the vision and purpose of existence of the channel and website... glad you found it helpful... all the best...
Sir pls answer ..Is it compulsory to done SAS training from SAS website of US for getting certificate? Or 2nd method is that we can learn from you and give only test for certification.. what's your view about this pls share..
it's not mandatory to learn sas directly from sas institute... you can learn sas anywhere and get certification done... btw, we don't provide any training as of now...
@@mycsg Sir pls mention some website where only I can get certificate after giving Test for SAS..
Thank you so much sir for your efforts! Very well explained not only this, every video of yours. You are god for self-learners.
glad to hear that the content is helpful... all the best...
Any recommendations on additional studying for the sas base programming cert with limited budget? I appreciate these videos, they are very helpful for my review.
download the certification preparation guide from internet and go through it completely... that should be sufficient...
Thanks for explaining PC PP concepts, Could you please make a video on EG domain as well , that will help me alot. i cannot find it in the playlist
It may take some time. Now that you are aware of how to look at the medical concepts and associated SDTM domains, you should try to visualize/remember things based on the description of the domain.
@mycsg is it possible to add any other testcds other than TUMIDENT in TUTESTCD
yes... see the controlled terminology for tutestd to get an idea.. www.mycsg.in/meta_sdtm_ct_paired_master.php?codelist=C96784
Thank you so much for your videos!
Glad you found them helpful....
If we want only 1st letters without last letters
firsttwo=substr(var,1,2)
Can you please let me know the defination for the big N and small n.
big N is the total participants who received a particular treatment. small 'n' is the number of participants who had a particular adverse event.. Not all participants may experience a particular event, so 'n' will be less than or equals to 'N'..
@@mycsg thank you very much
Hi Sir Good morning, Great information, I have a doubt what is difference between sdtmigv3.2 and sdtmig3.3. And I kindly request please do video for re-screening subjects.
Hi, the best place understand the modifications between ig 3.2 and ig3.3 is to refer the section 1.3 of ig 3.3. I will try to create a video on re-screening subjects soon.
@@mycsgThank you sir
what is the ddifference between on treatment flag and criteria flags do we have analysis flags and criteria flags in occds
1) Analysis flags can be added in OCCDS datasets. 2) These two variables differ by definition and purpose. Criteria flags are used to identify if a record meets a 'predefined criteria' like systolic blood pressure > 160 etc. Most often these are based on AVAL, CHG, PCHG, R2BASE etc. On treatment flag is a standard variable which is used to identify if a record can be attributed to the treatment based on comparison of treatment start and end dates.
@@mycsg thanks for explaining them so clearly. I have a request could you make videos on interview questions w.r.t to ADaM TLFS for experienced candidates
Super Bro. Can you please upload a video on BE,BS,SU and MB domain.
glad you found it helpful... sure, will do videos for BE/BS too...it will take some time though...
Very nice
Glad you liked the approach...
What is the best way to make it work the next day? It only works on the same workday but I can't open the file the next day even though it is still pinned.
is this happening in a remote desktop like citrix connection? in such systems, sometimes, user profiles are reset on each sigin in and these kind of setting get lost..
What is cmnt1 option ?? How the commented lines are generated ? Can you pls guide ?
it's a keyboard macro... you can find the details here.. ua-cam.com/video/VkMIZJnnn-A/v-deo.html
@@mycsgThank you for reply 😊Will check.
Hello sir, if there were 2 records with 2 day difference from target day, which one we will consider?
we may be asked to use the earliest or latest of those two.... in some cases, we may even be asked to use the record with best result or worst result
thank you for sharing, your videos are so helpful and easily understanding , nice keep it up
Glad you like them!
But one more doubt how to do %include steps and links ( which means a path where the file is stored) Because I tried but errors are shown.
can you please share additional details like the error message...
Nice to explain thanks
you are welcome
How is the importance of shift table in tables ?
This video may be of help to you. ua-cam.com/video/5m0fpe-v644/v-deo.html
What is difference between solicited and unsolicited adverse events with respect to vaccines trial?
with some vaccines, symptoms like fever and body pains are expected, such expected symptoms are considered as soloicited... similarly for injection based vaccines , pain, redness at the site of injection are expected.. those are also considered solicited... all other events which are not considered solicited in the protocol are considered unsolicited...
@@mycsg Thanks a lot
please make a video on topic of Sample size calculation
generally statisticians do sample size calculation... I don't know the details of that
viewed in right time. Much useful !!
Glad it was helpful!
Sir, Thank you for all these videos they are comprehensive and very useful. Could you please let me know about Trial disease assessment which comes under Trial design domain itself
I personally have not worked on TD yet... will try to add in future
Thank you! Can you make an easily remember the variables video for FA domain
its similar to vs or ra domain except that you will have objective variable...FAOBJ...
Its great but how can we do it programming wise ,Please upload a video on that?
please see the videos in adam playlist.. most of them are covered there...
@@mycsg oh my bad i have overlooked,thanks for the quick reply.
great explanation sir ...thanku
glad you found it helpful...
Great lesson
Glad you found it helpful.
Bless u and ur family, This means a lot for people like us
Thank you very much and all the best.
Hi Sir, I am unable to access the task file. can you please give the permission?
Some codes have access restriction on the website. This is a very short code, you can pause the video and manually type the code.
@@mycsg Yes, Thank You
Thank you so much
You're most welcome
Sir pls can u upload SU domain
It may take some time before we make a video for it.. but the code is already available here. www.mycsg.in/sdtm.php?area=SDTM&concept=SU&lesson=SDTM_SU_L101
Thank you Sir for providing helpful information. one question: Raw data is from RAVE database? Can we have a link for the SAS code for practise?
www.mycsg.in/sdtm.php?area=SDTM&concept=DM&lesson=SDTM_DM_LCSG001 yes, raw data of the example is in RAVE structure
Please correct your audio even u are explaining 4th as right option but during explanation you are reading as 0.01 which is not correct 0.01 gives 99% so please check once I hope this will be help full for some one not get confused
Sir pls can u upload some efficacy tables thank u.
it's work in progress, may take some more weeks.
One or more record, not one record - BDS structure. Very easy way of explanation and very much useful.
Glad that you found the explanation useful. When we say 'timepoint', it has a broad definition to cover analysis visit, date, time, timepoint of collection as well. It also includes derived records like LOCF etc. So, we can technically only have 'one record per parameter per timepoint' - not 'one or more'. I do not mean to disagree with you but just conveying my intepretaion of it.
Thank you nice explanation
Glad you liked it
Nice Review
Thanks!
Is there openings for SAS now
unfortunately, we do not track openings.. please check recruitment sites like LinkedIn, indeed, naukri..
Can you please explain in one video how to call macro in real field?
please see the videos related to macros, which covers the real time examples
Thanks sir for sharing this wonderful information
Most welcome