About jay_bhavsar

jay_bhavsar · ‎08-11-2021

The posted data is same as before. the only difference is i removed some column to see how code can be apply when the sequence of Week1-Week10 is not there. As for all available columns the code provided previously is working perfectly. but i just curious to know what if we have columns which are not in sequence.

jay_bhavsar · ‎08-11-2021

data Have; infile datalines ; input SUB Arm $ Screen Week1 Week2 Week5 Week6 Week7 Week9 Week10 TIME_TO_ACHIVE_TARGET ; datalines4; 1 Test 8 8.2 8.4 9 9.2 9.4 9.8 1 10 2 Test 8.7 8.9 9.1 9.7 9.9 1 5 7 7 3 Ref 9 9.2 9.4 10 2 4 8 11 5 4 Test 9.5 9.7 9.9 5 7 9 11.3 11.5 3 5 Ref 9.8 10 2 8 11 11.2 11.6 11.8 1 6 Ref 3 5 7 11.3 11.5 11.7 12.1 12.3 . 7 Test 8 8.2 8.4 9 9.2 9.4 9.8 10 10 8 Ref 9.2 9.4 9.6 2 4 6 11 11.2 4 9 Ref 8.6 8.8 9 9.6 9.8 10 4 6 7 10 Test 8.3 8.5 8.7 9.3 9.5 9.7 1 3 9 ;;;;

jay_bhavsar · ‎08-11-2021

OK i am attaching file.

jay_bhavsar · ‎08-10-2021

which format is fine for you? SAS DATASET of any other??

jay_bhavsar · ‎08-10-2021

Thank you Andreas, The code is giving desired results. One more thing to see what is some weeks in between are not there (file attached). variables "Arm" and "Screen" is just for carry no need to check condition in that.

jay_bhavsar · ‎08-10-2021

Hi friend, may be i failed to explain the query i run the the code but its not giving answer as i accepted. let me explain you the situation. SUB 1 reached to score of more then 10 at week10 so "Time to achieve target 10" has value 10. Likewise SUB 1 reached to score of more then 10 at week7 so "Time to achieve target 10" has value 7. and for sub 3 its week5, for sub 4 its week3, for sub 5 its week1, for sub 7 its week10, for 8 week4 and so on. and what if all Column name is not in sequence (Ex: Jan Mar May Sep Dec) then how can we get values of time to achieve target 10.

jay_bhavsar · ‎08-09-2021

Hello all, I have below data SUB Arm Screen Week1 Week2 Week3 Week4 Week5 Week6 Week7 Week8 Week9 Week10 TIME TO ACHIVE TARGET 10 1 Test 8 8.2 8.4 8.6 8.8 9 9.2 9.4 9.6 9.8 10.1 10 2 Test 8.7 8.9 9.1 9.3 9.5 9.7 9.9 10.1 10.3 10.5 10.7 7 3 Ref 9 9.2 9.4 9.6 9.8 10 10.2 10.4 10.6 10.8 11 5 4 Test 9.5 9.7 9.9 10.1 10.3 10.5 10.7 10.9 11.1 11.3 11.5 3 5 Ref 9.8 10 10.2 10.4 10.6 10.8 11 11.2 11.4 11.6 11.8 1 6 Ref 10.3 10.5 10.7 10.9 11.1 11.3 11.5 11.7 11.9 12.1 12.3 - 7 Test 8 8.2 8.4 8.6 8.8 9 9.2 9.4 9.6 9.8 10 10 8 Ref 9.2 9.4 9.6 9.8 10 10.2 10.4 10.6 10.8 11 11.2 4 9 Ref 8.6 8.8 9 9.2 9.4 9.6 9.8 10 10.2 10.4 10.6 7 10 Test 8.3 8.5 8.7 8.9 9.1 9.3 9.5 9.7 9.9 10.1 10.3 9 i want to check that at which week subject has reached score of 10, in last column answer are there i want that column to be generated by coding if score is greater then 10 at screen we will drop that subject. Thanks in advance.

jay_bhavsar · ‎03-04-2021

Thank you KurtBremser, this code is doing good, But one problem is it showing DTYPE = LOCF where locf is not done. and i dnt want to locf baseline (visit 0) values but in this code its doing that.

jay_bhavsar · ‎03-04-2021

Hello all data new X input RANDOMNO Visit Value X DATALINESX 1 0 1 1 1 5 1 2 . 1 3 7 1 4 . 1 5 1 2 0 3 2 1 . 2 2 . 2 3 4 2 4 5 2 5 . 3 0 . 3 1 . 3 2 6 3 3 . 3 4 8 3 5 0 X RUNX Proc sort data= new X By RANDOMNO Visit X Run X DATA LOCFX LENGTH DTYPE $15X RETAIN retain X SET new X BY RANDOMNO Visit X IF FIRST.RANDOMNO and Visit=0 THEN retain=. X IF Value NE . and Visit^=0 THEN retain=Value X IF Value=. THEN DO X VLOCF=retain X DTYPE='LOCF' X END X ELSE VLOCF=Value X RUN X REPLACED SEMICOLE WITH X AS SAS ASK TO REMOVE TO DO THIS BEFORE POSTING ---------------------------------------------------------- Above code I am using to do LOCF. it is giving me a correct result for this data. It may be not correct for large data. Can you confirm that condition I applied is correct. is this code will work for a large data also. please suggest if further refinement to this code should be done.

jay_bhavsar · ‎02-21-2021

Thank you so much for your reply i tried my best to explain my problem. Yes this is i want to print new variable like this, but there is only one small addition that i want "/" symbol after each variable name i.e. Mary/ 15/ F/ 66.5/ 112 Can i do this using proc report or in your code of "Catx".

jay_bhavsar · ‎02-19-2021

Thank you cynthia, i just want to learn that if there is two variable system organ class and preferred term and in ods rtf output i want to present them as single variable separating by "/" and i want preferred term value in second line.

jay_bhavsar · ‎02-18-2021

Data i have SUBJECTID SITEID PT SOC SUBSITE SOCPT AEYN SS0010006 SS001 COVID-19 pneumonia Infections and infestations SS001/SS0010006 Infections and infestations/COVID-19 pneumonia Yes SS0010006 SS001 Acute respiratory distress syndrome Respiratory, thoracic and mediastinal disorders SS001/SS0010006 Respiratory, thoracic and mediastinal disorders/Acute respiratory distress syndrome Yes SS0010007 SS001 Sinus bradycardia Cardiac disorders SS001/SS0010007 Cardiac disorders/Sinus bradycardia Yes proc report data = ae2 center missing headline headskip nowd split = '|' spacing = 1; column SUBSITE SOCPT AEYN ; define SUBSITE /order order=internal width=30 "SUBJECT|SITE" flow ; define SOCPT /order order=internal flow width=50 "SOC|PT" ; define AEYN /order order=internal width=12 left "Collection|Date" ; run;

jay_bhavsar · ‎02-18-2021

Hello ALL, i have data like SUBJECTID SITEID PT SOC SS0010001 SS001 COVID-19 pneumonia Infections and infestations SS0010002 SS001 Acute respiratory distress syndrome Respiratory, thoracic and mediastinal disorders this is my data i want to print it in word by proc report like below Site/ SubjectID System Organ Class/ Preferred Term MX001/ MX0010001 Infections and infestations/ COVID-19 pneumonia MX001/ MX0010002 Respiratory, thoracic and mediastinal disorders/ Acute respiratory distress syndrome I used flow option but it is not working for me.

jay_bhavsar · ‎01-16-2021

It worked... I learned new thing today. Thank you so much for your support.

jay_bhavsar · ‎01-15-2021

Dear PeterClemmensen, Thanks for your answer. your SQL giving me the result, but one more thing i want to add the i only want to consider yes from result variable. so i added onw more patient. Then how to calculate the count? data have; input Result $ PID treatment $; datalines; Yes 1 T No 1 T Yes 1 T Yes 1 O No 2 R Yes 2 R Yes 2 O Yes 3 T Yes 3 T Yes 3 T Yes 3 O No 4 R No 4 R ;

Online Status	Offline
Date Last Visited	‎08-17-2021 04:06 AM

Re: Check Condition in multiple variables

Re: Check Condition in multiple variables

Re: Check Condition in multiple variables

Re: Check Condition in multiple variables

Re: Check Condition in multiple variables

Re: Check Condition in multiple variables

Check Condition in multiple variables

Re: locf CODE CONFIRMATION

locf CODE CONFIRMATION

Re: PROC REPORT FLOW

Re: Unique value count by variable

Re: Check Condition in multiple variables

Re: Check Condition in multiple variables

Re: Check Condition in multiple variables

Re: Check Condition in multiple variables

Re: Check Condition in multiple variables

Re: Check Condition in multiple variables

Check Condition in multiple variables

Re: locf CODE CONFIRMATION

locf CODE CONFIRMATION

Re: PROC REPORT FLOW

Re: PROC REPORT FLOW

Re: PROC REPORT FLOW

PROC REPORT FLOW

Re: Unique value count by variable

Re: Unique value count by variable