About tsureshinvites

tsureshinvites · ‎01-26-2022

Thanks a lot, it works fine, Program is simple but effective. You support is really appreciated.

tsureshinvites · ‎01-26-2022

Need to to out the subjects that have not MHTYPE = "Medical History" Source Data: Source Data Subject InstanceName MHTYPE 1036190 Screening SURGICAL HISTORY 1036192 Screening VACCINE HISTORY 1036192 Screening MEDICAL HISTORY 1036192 Screening SURGICAL HISTORY 1036193 Screening VACCINE HISTORY 1036193 Screening MEDICAL HISTORY 1036193 Screening SURGICAL HISTORY 1036196 Screening VACCINE HISTORY 1036196 Screening MEDICAL HISTORY 1036196 Screening SURGICAL HISTORY 1036197 Screening SURGICAL HISTORY 1036197 Screening VACCINE HISTORY Expected output: Expected output 1036190 Screening SURGICAL HISTORY 1036197 Screening SURGICAL HISTORY 1036197 Screening VACCINE HISTORY

tsureshinvites · ‎01-15-2020

Hi, Please assist me to write algorithm for the below task. Input raw data: String = "Suresh Kumar thangaraj" Output required: New_String = "hseruS ramuK jaragnaht" But my output; My output; "jaragnaht ramuK hseruS"; My Code: data test; length New_string $30; string = "Suresh Kumar thangaraj"; L = length(string); do i = 1 to L; substr(New_string,i,1) = substr(string,L+1-i,1); end; run; Regards, Suresh Kumar

tsureshinvites · ‎01-03-2020

Thanks a lot for your wonderful support, but small request, could you please write in datastep. Thanks a lot.

tsureshinvites · ‎01-03-2020

Objective; I need to pick the subject(s) who has failed only one test(IE) and passed only one test (ex). then output, both condition should match for a subject. data raw_data; input Subject_id $ Test_Code $ Result $; datalines; 1001 IE01 Fail 1001 IE02 Pass 1001 IE03 Pass 1001 EX01 Pass 1001 EX01 Fail 1001 EX01 Fail 1003 IE01 Fail 1003 IE02 Fail 1003 EX01 Pass 1003 EX02 Pass ; output required; Subject_id Test_Code Result 1001 IE01 Fail 1001 EX01 Pass My code;

tsureshinvites · ‎01-02-2020

Question; Write a program to print like below based on input value; Rawdata; if input value P = 6; then output value should populate as below Output Required; P PP PPP PPPP PPPPP PPPPP My Code; No idea; Regards, Calvin

tsureshinvites · ‎12-28-2019

Thanks a lot it worked fine.

tsureshinvites · ‎12-28-2019

Hi i am very new to sas, please help out for the below scenario. My rawdata; data IE_Raw; input Subject_id $ Test_Code $ Result $; datalines; 1001 IE01 Pass 1001 IE02 Pass 1001 IE03 Pass 1001 IE04 Fail 1001 IE05 Fail 1002 IE01 Fail 1002 IE02 Pass 1002 IE03 Pass 1002 IE04 Pass 1002 IE05 Pass 1002 EX01 Pass 1002 EX02 Pass 1002 EX03 Pass 1002 EX04 Fail 1002 EX05 Fail 1003 EX01 Fail 1003 EX02 Pass 1003 EX03 Pass 1003 EX04 Pass 1003 EX05 Pass ; Required Output: Form the above data set need to extract record, those (subject or patient) are failed in only one test of IE tests category and the subject passed only one test in EX tests category by subject wise. like below. Note; if a subject failed or passed more than one test, it should not be extracted. Subject_id Test_Code Result 1002 IE 01 Fail 1003 EX 01 Pass My code; Regards, Suresh Kumar

tsureshinvites · ‎12-19-2019

data sv_raw1; input PT_ID $ Visit $ Res; datalines; 2 4 10 2 5 15 1 1 20 1 2 40 1 3 30 2 1 30 2 2 60 2 3 50 3 1 . 3 2 40 3 3 60 3 4 70 4 1 30 4 2 20 4 3 30 4 4 35 5 1 90 5 2 91 5 3 30 5 4 40 5 5 70 6 1 . 6 2 . 6 3 30 6 4 40 1 0 10 2 0 10 3 0 10 4 0 10 5 0 10 6 0 10 ; Scenario: 1. Baseline visit = 2. 2. Prior baseline visit's res value ( 0,1) should populate in BASE (Variable) 3. Post Baseline visit's res value (3+ visits) should populate in BASE (Variable) 3. if Visit 2 value is missing then prior visit's value should populate in BASE (Variable) Output Required: PT_ID Visit Res Base 1 0 10 10 1 1 20 10 1 2 40 40 1 3 30 40 2 0 10 10 2 1 30 10 2 2 60 60 2 3 50 60 2 4 10 60 2 5 15 60 3 0 10 10 3 1 . 10 3 2 40 40 3 3 60 40 3 4 70 40 4 0 10 10 4 1 30 10 4 2 20 20 4 3 30 20 4 4 35 20 5 0 10 10 5 1 90 10 5 2 91 91 5 3 30 91 5 4 40 91 5 5 70 91 6 0 10 10 6 1 . 10 6 2 . 10 6 3 30 10 6 4 40 10 My code: proc sort data=sv_raw1 out=sv1; by PT_ID Visit Res; run; data baseline1; set sv1; retain Base; by PT_ID Visit Res; if first.PT_ID then Base = Res; else if visit eq '2' then Base = Res; else if visit not in ('2') then run;

tsureshinvites · ‎12-17-2019

data sv_raw; input PT_ID $ Visit $ Res ; datalines; 1 1 20 1 2 40 1 3 30 2 1 30 2 2 40 2 3 50 ; Need output: The result of first value of patient should be populated in Base (Variable) like below. objective is New variable has to be created in the name of base, the data value is 'first value of res(result) variable' PT_ID Visit Res Base 1 1 20 20 1 2 40 20 1 3 30 20 2 1 30 30 2 2 40 30 2 3 50 30 My code; data sv_raw; input PT_ID $ Visit $ Res $; datalines; 1 1 20 1 2 40 1 3 30 2 1 30 2 2 40 2 3 50 ; proc sort data=sv_raw out=sv; by PT_ID Visit Res; run; data baseline; set sv; by PT_ID Visit Res; if not missing(PT_ID)then Base = first.res; run;

tsureshinvites · ‎11-21-2019

Thanks a lot. your simple code made wonderful output.

tsureshinvites · ‎11-21-2019

attached file shot for your reference, in that visit of "baseline" , "c1w1" considered as double-blind treatment. (ie group A) Visit of "c1w2" considered as open label treatment (ie group B) so i want to group of (group A and Group B observation as) epoch as "Treatment".

tsureshinvites · ‎11-21-2019

I am not aware how to gourp the observations. I am new to clinical SAS, need help of for the below queries. Raw Data; input id$ Visit $ Date $ datalines; Raw Data ID Vist Start Date B1110001 Baseline 4/18/2016 B1110001 Visit 4/19/2016 B1110003 Baseline 4/18/2016 B1110003 Visit 1 4/20/2016 B1110004 Baseline 4/18/2016 B1110004 VISIT 1 4/19/2016 B1110004 VISIT 2 4/21/2016 Need outup; Output ID Vist Start Date End Date B1110001 Visit Group A 4/18/2016 4/19/2016 B1110003 Visit Group A 4/18/2016 4/20/2016 B1110004 Visit Group B 4/18/2016 4/21/2016 Notes; 1. want to sort same ID and make as one group. 2. assign start date as first visit date. 3. assign end date as last visit date. sample code; data want; set sashelp.class Please help me.

tsureshinvites · ‎11-12-2019

Thanks a lot sir, its simple and effective out. Great.....

tsureshinvites · ‎11-10-2019

Can anyone help me to derive the following scenario. My raw data; data dov; input SUBJID visdate $6-15 VISITNUM 16-17 VISIT $18-25; datalines; 1001 10Jan2015 1 VISIT1 1001 15Jan2015 2 VISIT2 1001 20Jan2015 3 VISIT3 1001 25Jan2015 4 VISIT4 1001 30Jan2015 5 VISIT5 1002 04Feb2015 1 VISIT1 1002 09Feb2015 2 VISIT2 1002 14Feb2015 3 VISIT3 1002 19Feb2015 4 VISIT4 1002 24Feb2015 5 VISIT5 1002 01Mar2015 6 VISIT6 1003 06Mar2015 1 VISIT1 1003 11Mar2015 2 VISIT2 1003 16Mar2015 3 VISIT3 1003 21Mar2015 4 VISIT4 1003 26Mar2015 5 VISIT5 1003 31Mar2015 6 VISIT6 1003 08Mar2015 UNSCH 1003 19Mar2015 UNSCH 1003 19Mar2015 UNSCH 1003 20Mar2015 UNSCH 1001 11Jan2015 UNSCH 1001 12Jan2015 UNSCH 1001 13Jan2015 UNSCH 1001 13Jan2015 UNSCH 1002 02Mar2015 UNSCH 1002 02Mar2015 UNSCH 1002 03Mar2015 UNSCH 1002 05Feb2015 UNSCH 1002 05Feb2015 UNSCH ; run; Need output like below; subjid date visitnum visit 1001 10Jan2015 1 VISIT1 1001 11Jan2015 1.01 UNSCHEDULED 1.01 1001 12Jan2015 1.02 UNSCHEDULED 1.02 1001 13Jan2015 1.03 UNSCHEDULED 1.03 1001 13Jan2015 1.03 UNSCHEDULED 1.03 the highlighted red color is same date record visit number also same. Mycode: proc sort data = dov; by SUBJID visdate; run; data UNSCH_date; set dov; if VISITNUM ne . then New_Visitnum = VISITNUM; else New_Visitnum+0.01; drop VISITNUM; rename New_Visitnum = VISITNUM; run; my output screenshot is attached. But it's not the exact result. Thanks Sures

Online Status	Offline
Date Last Visited	‎01-26-2022 02:59 PM

Re: Output where subject does not have any MHTYPE = "Medical History"

Output where subject does not have any MHTYPE = "Medical History"

Read string in revers

Re: Extract multiple criteria per subject

Extract multiple criteria per subject

Write a program for character population

Re: Extract Specif observation from multiple observation

Extract Specif observation from multiple observation

Derive Base line visit's Value

Deriving data values from first value of each observation into new var...

Re: Unschedule visit number derivation

Re: How to categorize the data value in multiple column to create new ...

Re: Output where subject does not have any MHTYPE = "Medical History"

Re: Grouping subject visit and assign dates

Re: Output where subject does not have any MHTYPE = "Medical History"

Output where subject does not have any MHTYPE = "Medical History"

Read string in revers

Re: Extract multiple criteria per subject

Extract multiple criteria per subject

Write a program for character population

Re: Extract Specif observation from multiple observation

Extract Specif observation from multiple observation

Derive Base line visit's Value

Deriving data values from first value of each observation into new var...

Re: Grouping subject visit and assign dates

Re: Grouping subject visit and assign dates

Grouping subject visit and assign dates

Re: Unschedule visit number derivation

Unschedule visit number derivation