About raja777pharma

raja777pharma

Hi, I have two dataset and need to be assign value based on date ranges . subject Siteid Test date 1001 201 LDH 12-Aug-24 1001 201 LDH 22-Aug-24 1001 201 LDH 31-Sep-24 1001 201 ALT 12-Aug-24 1001 201 ALT 12-Aug-24 1002 202 LDH 18-Mar-24 1002 202 LDH 18-Mar-24 1002 202 ALT 18-Mar-24 1002 202 ALT 18-Mar-24 1002 202 ALT 25-Jun-24 Below Value need to add above dataset where same siteid and test and the date value between stdt and endt. if endt is missing then use only date and stdt for example subject 1001 and siteid = 201 ,test = LDH , date = 31Sep24 , value need be assign 27 and rest of two records will get value 24 . siteid test stdt endt value 201 LDH 10-Aug-24 15-Aug-24 24 201 LDH 30-Sep-24 27 201 ALT 10-Aug-24 15-Aug-24 1002 202 LDH 15-Mar-24 28-Mar-24 35 202 ALT 15-Mar-24 28-Mar-24 1021 202 ALT 20-Jun-24 1031

raja777pharma · ‎09-11-2024

Hi, Thank you for solution , but in my data some subjects have only one record and those not flagged see below screen shot Thank you, Raja.

raja777pharma · ‎09-11-2024

Hi , Thank you for resolution, however i am very poor to understanding the array in SAS. Is any other way to do the same task with out array. Thank you, Raja.

raja777pharma · ‎09-11-2024

Hi Team, I am working to assign flag values for below data ,as below are rules > if three row values for same date , same visit and two values 'Normal' and one values 'Abnormal' then latest record will flag as 'Y' > in three row records all are same then latest/last record will flag as 'Y' > in three results first one is normal and second one is abnormal and third one is Normal then , third normal values will flag 'Y' > if first two values are abnormal and last values is normal then second value abnormal will flag 'Y' Current data : Subjid Visit Date id Result 101 Visit1 10-Sep-24 1 Normal 101 Visit1 10-Sep-24 2 Normal 101 Visit1 10-Sep-24 3 Abnormal 102 Visiti2 13-Jun-24 1 Normal 102 Visiti2 13-Jun-24 2 Abnormal 102 Visiti2 13-Jun-24 3 Normal 103 Visit1 02-Mar-24 1 Abnormal 103 Visit1 02-Mar-24 2 Normal 103 Visit1 02-Mar-24 3 Abnormal 104 Visit1 23-Feb-24 1 Abnormal 104 Visit1 23-Feb-24 2 Abnormal 104 Visit1 23-Feb-24 3 Normal 105 Visit1 18-Jan-24 1 Normal 105 Visit1 18-Jan-24 2 Normal 105 Visit1 18-Jan-24 3 Normal 105 Visit2 25-Jan-24 1 Abnormal 105 Visit2 25-Jan-24 2 Abnormal 105 Visit2 25-Jan-24 3 Abnormal want assign flag values as below Subjid Visit Date id Result Flag 101 Visit1 10-Sep-24 1 Normal 101 Visit1 10-Sep-24 2 Normal Y 101 Visit1 10-Sep-24 3 Abnormal 102 Visiti2 13-Jun-24 1 Normal 102 Visiti2 13-Jun-24 2 Abnormal 102 Visiti2 13-Jun-24 3 Normal Y 103 Visit1 02-Mar-24 1 Abnormal 103 Visit1 02-Mar-24 2 Normal 103 Visit1 02-Mar-24 3 Abnormal Y 104 Visit1 23-Feb-24 1 Abnormal 104 Visit1 23-Feb-24 2 Abnormal Y 104 Visit1 23-Feb-24 3 Normal 105 Visit1 18-Jan-24 1 Normal 105 Visit1 18-Jan-24 2 Normal 105 Visit1 18-Jan-24 3 Normal Y 105 Visit2 25-Jan-24 1 Abnormal 105 Visit2 25-Jan-24 2 Abnormal 105 Visit2 25-Jan-24 3 Abnormal Y Thank you, Raja.

raja777pharma · ‎09-04-2024

Hi , Below values are not have same value by ID 15 Jan 1 x 15 Jan 2 Y 15 Jan 3 x

raja777pharma · ‎09-03-2024

Hi, How to separate data that have duplicate records when by id those are more than 2 records. example: data test; date id value 22Mar 1 x 22MAr 2 x 22 Mar 3 x 24 Mar 1 x 24 Mar 2 x 28 Mar 1 x 30 Sep 1 x 15 Jan 1 x 15 Jan 2 Y 15 Jan 3 x want two data set Duplicate by date and value ,in duplicate include single records also in red color in one dataset those are duplicate by value and green in another data set which are not duplicate by value Note: if only one record for the date the records also consider as duplicate and separate Thank you, Rajasekhar.

raja777pharma · ‎07-15-2024

Hi Team, I am trying to convert the dates below to IS8601DA , but one date was not considering that one is in date9. format. Thank you, Raja.

raja777pharma · ‎12-27-2023

Hi Team, I am new to Proc Mixed to use it for ANOVAL model. As per below, i have to use Proc Mixed for ANCOVA model. "The Change From Baseline in LSM compared between study treatments at week 48 using ANCOVA with study treatments as the main effect in the model and baseline score as a covariate." In my dataset variables are : TRT(Treatments distinct values are 1,2,3) , AVAL(Value),AVISIT(Week 48 value) , CHG (Change ) , BASE(Baseline) I am using below statement , but not sure is correct one as per above statement , and how to use Main model and covariate proc mixed data=inds covtest ; class trt ; model chg = trt base; lsmeans trt cl alpha=0.20; ods output Diffs=fib_dif; ods output LSMeans=fib_means; run; please let me is above statement is correct , if not let me now how to adjust the code. Thank you, Raja.

raja777pharma · ‎08-24-2023

Hi, Thank you for code. Here is the data. data picture2; infile datalines dsd truncover; input USUBJID:$60. EXLNKID:$30. AOCCUR:$1. ATRT:$200. ADOSE:32. ASTDT:DATE9. AENDT:DATE9. AVISITN:32. APHASE:$40. APHASEN:32.; format ASTDT DATE9. AENDT DATE9.; label USUBJID="Unique Subject Identifier" EXLNKID="Link ID"; datalines4; 73763989HPB2003-100004,NA-20211102T1040,Y,TENOFOVIR ALAFENAMIDE (TAF),25,02NOV2021,16FEB2023,28,Open-label,2 73763989HPB2003-100004,NA-20210420T1045,Y,TENOFOVIR DISOPROXIL (TD),245,20APR2021,01NOV2021,0,Open-label,2 ;;;; data picture1; infile datalines dsd truncover; input USUBJID:$60. APHASE1:$9. APHASE2:$10. APHASE3:$9. APHASE4:$6. PH1SDT:DATE9. PH1EDT:DATE9. PH2SDT:DATE9. PH2EDT:DATE9. PH3SDT:DATE9. PH3EDT:DATE9. PH4SDT:DATE9. PH4EDT:DATE9.; format PH1SDT DATE9. PH1EDT DATE9. PH2SDT DATE9. PH2EDT DATE9. PH3SDT DATE9. PH3EDT DATE9. PH4SDT DATE9. PH4EDT DATE9.; label USUBJID="Unique Subject Identifier" APHASE1="Description of Phase 1" APHASE2="Description of Phase 2" APHASE3="Description of Phase 3" APHASE4="Description of Phase 4" PH1SDT="Phase 1 Start Date" PH1EDT="Phase 1 End Date" PH2SDT="Phase 2 Start Date" PH2EDT="Phase 2 End Date" PH3SDT="Phase 3 Start Date" PH3EDT="Phase 3 End Date" PH4SDT="Phase 4 Start Date" PH4EDT="Phase 4 End Date"; datalines4; 73763989HPB2003-100004,Screening,Open-label,Follow-up,,25MAR2021,19APR2021,20APR2021,21MAR2022,22MAR2022,16FEB2023,, ;;;;

raja777pharma · ‎08-24-2023

Hi , Please let me know how i can create sas code with data values by using CSV file data. Thank you, Raja.

raja777pharma · ‎08-24-2023

Hi, Below is the CSV data; Picture1 data: USUBJID,APHASE1,APHASE2,APHASE3,APHASE4,PH1SDT,PH1EDT,PH2SDT,PH2EDT,PH3SDT,PH3EDT,PH4SDT,PH4EDT 73763989HPB2003-100004,Screening,Open-label,Follow-up,,25MAR2021,19APR2021,20APR2021,21MAR2022,22MAR2022,16FEB2023,, Picture2 data: USUBJID,EXLNKID,AOCCUR,ATRT,ADOSE,ASTDT,AENDT,AVISITN,APHASE,APHASEN 73763989HPB2003-100004,NA-20211102T1040,Y,TENOFOVIR ALAFENAMIDE (TAF),25,02NOV2021,16FEB2023,28,Open-label,2 73763989HPB2003-100004,NA-20210420T1045,Y,TENOFOVIR DISOPROXIL (TD),245,20APR2021,01NOV2021,0,Open-label,2 Thank you, Raja

raja777pharma · ‎08-24-2023

Hi, I need to split the record based on a group of date ranges. In picture 2 ATRT='TENOFOVIR ALAFENAMIDE (TAF)' record ASTDT and AENDT dates fall into two phases from picture 1 , so i need to make new records as in picture 3. Picture 1 Picture 2 Picture 3 please let me know ho to do it. Thank you, Raja.

raja777pharma · ‎05-07-2023

Hi , Thank you very much for identifying the issue, the space I have reentered and it worked. Thank you, Raj.

raja777pharma · ‎05-05-2023

Hi, I have tried your suggestion and other possible methods also, but still, i am getting error. Thank you, Raj.

raja777pharma · ‎05-04-2023

Hi Team, I am getting the below error while running proc sgpanel. proc sgpanel data = plot020a /*(where=(&whr.)) */ dattrmap=mymap /*sganno=anno*/ noautolegend pad=(left=35px); panelby avisit / border rowheaderpos =left columns=1 rows=2 spacing = 0 novarname ONEPANEl uniscale=column HEADERATTRS=(Size=14pt) layout=panel; scatter x=aval_&paramcd_x. y=aval_&paramcd_y./ group=apanel_ attrid=trtMap; rowaxis label= &rlabel. labelAttrs=(size=8) valueAttrs=(size=10pt) min=&ymin. max=&ymax. THRESHOLDMIN=1 THRESHOLDMAX=1 grid valueshint; colaxis label= &xlabel. labelAttrs=(size=6) valueAttrs=(size=9pt) min=&xmin. max=2 THRESHOLDMIN=1 THRESHOLDMAX=1 grid valueshint /*type=linear*/ fitpolicy=rotate valuesdisplay = ("0" "0.01" "1" "5" "10" "30" "50" "70" "90" "100") values = (-3.000000 -2.000000 0.000000 0.698970 1.000000 1.477121 1.698970 1.845098 1.954243 2.000000) offsetmin=0.05 ; run; Request you please suggest a solution. Thank you, Raj.

Online Status	Offline
Date Last Visited	3 weeks ago

Proc sql conditional date values merge

Re: How to assign Flag for two same values in three rows for last sam...

Re: How to assign Flag for two same values in three rows for last sam...

How to assign Flag for two same values in three rows for last same va...

Re: How to separate the non unique values

How to separate the non unique values

How to convert date format with multiple date format in one column

Proc Mixed for ANCOVA Model

Re: Split records based on group date ranges

Re: Split records based on group date ranges

Re: array_Assign new var based on multiple var values

Re: Transpose Data Based on value

Proc sql conditional date values merge

Re: How to assign Flag for two same values in three rows for last sam...

Re: How to assign Flag for two same values in three rows for last sam...

How to assign Flag for two same values in three rows for last same va...

Re: How to separate the non unique values

How to separate the non unique values

How to convert date format with multiple date format in one column

Proc Mixed for ANCOVA Model

Re: Split records based on group date ranges

Re: Split records based on group date ranges

Re: Split records based on group date ranges

Split records based on group date ranges

Re: Valuedisplay syntax error for Proc sgpanel

Re: Valuedisplay syntax error for Proc sgpanel

Valuedisplay syntax error for Proc sgpanel