Пікірлер
@sadiya2418 2 күн бұрын
How do you calculate age variable?
@mycsg 2 күн бұрын
Age is a collected directly on crf, and not derived...
@prashanthiprashanthi8186 5 күн бұрын
Sir, Why in most of the DM domain date variables are considered as Qualifier variables why not Timing Variables
@prashanthiprashanthi8186 9 күн бұрын
sir,one silly question EOS is not SDTM domain right,In above video you used EOS from where you get it?is it intermediate dataset?if no means from where we will get DEATH details in AE(I think this death first we will considered into AE)
@mycsg 6 күн бұрын
EOS is a raw dataset that is used to capture the end of study status for the subject.
@xinwenliang705 10 күн бұрын
谢谢！
@mycsg 10 күн бұрын
Thank you..
@xinwenliang705 11 күн бұрын
Please keep posting this great videos regarding domains ❤
@mycsg 10 күн бұрын
Thank you, I will
@xinwenliang705 11 күн бұрын
谢谢！
@mycsg 10 күн бұрын
Thank you...
@xinwenliang705 11 күн бұрын
Finally found what I wanted🎉
@mycsg 10 күн бұрын
glad you found it helpful...
@juansaldana2799 11 күн бұрын
what a great job!!!
@mycsg 11 күн бұрын
glad you liked it...
@carlosparrarojas6588 11 күн бұрын
Very well explained, thanks so much for your dedication. Which program are you using for annotating the table print? It seems so useful.
@mycsg 11 күн бұрын
glad you found it helpful... Screenshot tool faststone capture is used
@somagandem270 12 күн бұрын
Hi sir can you explain basics in R
@mycsg 12 күн бұрын
if you already know SAS, the videos in this playlist are considered as basics of R tidyverse package
@somagandem270 13 күн бұрын
Thank you so much sir 😊 can you explain tables programing in R
@mycsg 13 күн бұрын
Yes, soon
@venkatravi2161 14 күн бұрын
Thanks!
@mycsg 13 күн бұрын
Welcome!
@prabhakarareddy9652 18 күн бұрын
Good in spec and easy to understand 👍.
@mycsg 18 күн бұрын
Glad you liked it
@Sharoonshaik 23 күн бұрын
Very nice explanation sir...its very helpful...please explain the chapters also....its a request
@mycsg 23 күн бұрын
You can find the playlist covering almost all chapters here. kzbin.info/aero/PLPtw8CzW9VNWzLgHnwaF60YZtd7iOghf8
@Henduro 28 күн бұрын
Should we include tumor identifier in RS as well, as we are assessing response for each tumor as well as overall?
@mycsg 28 күн бұрын
no, we assess the response overall if it is based on recist criteria... not sure if there is guideline or study specific requirement to check response of individual tumors... if so, then tumor identifier has meaning in RS too..
@laurendai1731 Ай бұрын
thank you so much explaining this ?? before best or yymmdd10. This ?? was used a lot in other clinical trail codes.
@mycsg Ай бұрын
Glad it was helpful!
@ravirai796 Ай бұрын
Hi sir, i have a small doubt, which treatment we consider from adsl dataset planned or actual.. We follow the SAP?
@mycsg Ай бұрын
in general, for outputs based on safety analysis set we use actual treatment and for other analysis we use planned treatment... but these will be specified in SAP of each study as well...
@bhanu99-1 Ай бұрын
Please arrange the Video in Playlist- for SAS learning for beginners. I am in QA and Interested SAS learning
@mycsg Ай бұрын
the playlists of sdtm, adam and tfls are ordered logically...
@anandupvenu6027 Ай бұрын
hi sir what if there is an cross over study for that there would be two treatment element so if we use this method then (there are duplicate in ID statement in proc transpose) we will get this error
@mycsg Ай бұрын
epoch names will be different in cross over studies, like trt1 and trt2
@anandupvenu6027 Ай бұрын
@@mycsg here anyway it would be under treatment i meant the start date would be trt1 date and end date would be trt2 end date. that is sorted now but i merge with the main dataset why i have this error like(merge statement has more than one dataset with by values) how to solve this. because here we are only using usubjid as by variable
@mubasirulamidi2806 Ай бұрын
This made my day.
@mycsg Ай бұрын
glad you found it helpful..
@my_gadget Ай бұрын
Hello actually I am little confused on merging like if I create ADSL dataset so I have need to merge DM with VS Which merging should I do here like inner, full, left and right merging?
@mycsg Ай бұрын
you will have to process your vs data such that there is one record per subject and do left join with adsl as left dataset
@my_gadget Ай бұрын
@@mycsg After sorting the dataset data merg1 ; Merge dm (in=a) vs(in=b) ; By usubjid ; If a ; Run; This is correct for dm and vs?
@my_gadget Ай бұрын
@@mycsg ok because vs have many so firstly have to process ok gotit
@mycsg Ай бұрын
correct, provided your vs dataset has one record per subject... most common parameter from vs is baseline weight - if your vs is processed like that for baseline weight then it is correct
@my_gadget Ай бұрын
@@mycsg if I create sdtm vs as per specification then it process like one record per subject or not ?
@naveensai5730 Ай бұрын
Hi, Can you please make a video for aCRF
@VijayKumar-y1s7g Ай бұрын
Hello Sir, I have one doubt. The derivation logic for each variables in your spec will varry depends on study design? will that be given to us by sponcer or should we remember all these ourself ? Please advise.
@mycsg Ай бұрын
derivations of some variables and parameters remain same/similar across studies... for other things, details will be available in statistical analysis plan and spec should be drafted based on those details...
@VijayKumar-y1s7g Ай бұрын
@@mycsg Thank you so much! I’m currently learning statistical programming, and your lessons are fantastic. You’re providing an invaluable service, and I truly appreciate it! Would it possible to reach you over phone.?
@mycsg Ай бұрын
@@VijayKumar-y1s7g you can reach us using contact us page on mycsg.in website
@seetharambabu5242 Ай бұрын
Please provide your mail id, want to take training
@laurendai1731 Ай бұрын
why ARMNRS for 1003 is different from 1006?
@mycsg Ай бұрын
1003 is assumed to be a screen failure where as 1006 is assumed to be a screen pass but not randomised... so, the reasons would differ... we do see such cases in real time
@laurendai1731 Ай бұрын
??best. what this mean?
@mycsg Ай бұрын
explained it on one of your other same comment
@prabhusubramaniyan3304 Ай бұрын
Hi , your videos are very helpful. Please explain about figures also.
@mycsg Ай бұрын
glad you found them helpful.... will try
@ketul_duleraa18 Ай бұрын
Amazing explanation keep doing it❤
@mycsg Ай бұрын
glad you found it helpful...
@harsharani6194 Ай бұрын
Hello sir, Appreciate your effort and teaching skills,. Your website is completely different compared to your videos on KZbin. there is no input data and output dataset and also many tabs are missing, it would be helpful if we could see the input and output of your programs in your blog.
@mycsg Ай бұрын
for various reasons, we cannot provide some of the files used in videos cannot be shared... the main purpose of the videos is to help viewers understand the concept... you can reach us using contact us page on the website if you need more details
@laurendai1731 Ай бұрын
indsname=_x; what this mean? why repeat twice?
@mycsg Ай бұрын
it's not a repeat... the first instance is creaing the temporary variable named _x using indsname option of the set statement. second instance is creating a permanent variable named indsname by using the value from _x.
@laurendai1731 Ай бұрын
??best what this mean?
@mycsg Ай бұрын
?? is an informat modifier which tells sas to convert the values to numeric only if its a valid numeric value and do not write any message to log file for invalid numeric data...
@laurendai1731 Ай бұрын
if nmiss(tr01sdt,tr02sdt) ne 2 then trtsdt=coalesce(tr01sdt,tr02sdt);, what's the first nonmissing date? by descending order?
@mycsg Ай бұрын
coalesce doesn't compare the values, it only fetches the first non-missing value of the two variables passed..
@bhanu99-1 Ай бұрын
Thanks for sharing, Which tool you are using ?
@mycsg Ай бұрын
Microsoft whiteboard
@bhanu99-1 Ай бұрын
@@mycsg Thanks !
@janaveebhoi6428 Ай бұрын
Thank you for sharing these informative videos. Please upload how to do efficacy dataset also
@mycsg Ай бұрын
glad you found it helpful... the flow of an efficacy will remain the as other adam datasets as the underlying principles are same for safety and efficacy datasets...
@janaveebhoi6428 Ай бұрын
@@mycsg thank you
@laurendai1731 Ай бұрын
MERGE EX(IN=A) DATES03(IN=B) , Ex? SHOUBE MERGE DATES02(IN=A) DATES(IN=B)
@mycsg Ай бұрын
no, the purpose of this merge is to visually examine the source records where at least one overlap exists...
@ravig-r3z Ай бұрын
Hi sir, Good Evening, excellent explanation. Could you please video on WOCF and BLOCF derivation and also kindly request please do video on rescreening subjects, Thank you.
@mycsg Ай бұрын
Will try
@laurendai1731 Ай бұрын
If your presentation on screen is printing out format, that would be very clear to read it .
@mycsg Ай бұрын
like a ppt?
@naveensai5730 Ай бұрын
How do we creare define.xml? If possible can you explain breief steps
@mycsg Ай бұрын
Hope the below video helps. kzbin.info/www/bejne/anmlY6KNetWNrNU
@AnugulaSrikanth-z2i Ай бұрын
instead of writing months with if then conditions . can we use formats for it? please reply sir...
@mycsg Ай бұрын
yes...you can use any other alternative approaches which gives the same result..
@BhargaviPottam Ай бұрын
hai, Whats the need of where 1=1 i really could not understand. thanks for your videos.
@mycsg Ай бұрын
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
@ravisas Ай бұрын
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??
@mycsg Ай бұрын
yes, those two will be in sync in most cases ... we can use rficdtc also ...
@ravisas Ай бұрын
@@mycsg Thank you sir
@anilasahu Ай бұрын
Thanks
@mycsg Ай бұрын
Welcome
@maneshbv1 Ай бұрын
Thank you so much for this video. Please keep making more videos if you have time.
@mycsg Ай бұрын
Thank you, I will
@praneethkumar8476 2 ай бұрын
Nice explanation for TLFs thank you so much for real time project explanation,please upload ADAM related Real time scenarios
@mycsg 2 ай бұрын
glad you found it helpful... for ADaM , please see the adam playlist. there are a lot of concepts covered
@praneethkumar8476 2 ай бұрын
This video is very helpfull please upload some more videos for TLFs thank you so much sharing this.......................👏👏👏👏👏
@mycsg 2 ай бұрын
sure. glad you found it helpful...
@gurusaidatta422 2 ай бұрын
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.
@gurusaidatta422 2 ай бұрын
Open to anyone's response
@mycsg Ай бұрын
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...
@purushotham714 2 ай бұрын
Hi sir , thanks for insights of timing variables, here PCRFTDTC means can we assume RFSTDTC?
@mycsg 2 ай бұрын
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
@joelmhaske8185 2 ай бұрын
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
@mycsg 2 ай бұрын
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...
@rshpharmatv4548 2 ай бұрын
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..
@mycsg 2 ай бұрын
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...
@rshpharmatv4548 2 ай бұрын
@@mycsg Sir pls mention some website where only I can get certificate after giving Test for SAS..
@DivyaG-x7b 2 ай бұрын
Thank you so much sir for your efforts! Very well explained not only this, every video of yours. You are god for self-learners.
@mycsg 2 ай бұрын
glad to hear that the content is helpful... all the best...