About ambadi007

ambadi007 · ‎04-11-2022

Hi team, i have a tricky requirement with 3 scenarios , scenario 1 i need to create an additional flag=y with the closest value of awtarget Scenario 1 Same subject same param same avisitn with different ADY (AWDIFF=awtarget-ady) USUBJID VISIT VISITNUM AVISIT AVISITN PARAM AVAL AWTARGET ADY AWDIFF 101 WEEK1 25 Week 1 20 PAR1 55 5 4 1 101 WEEK 1 25 Week 1 20 PAR1 50 5 3 2 (closest values of AWDIFF with awtarget will be flagged FLG="Y" so here the first record should be flagged as Y since the closest awdiff is low for that record ) Scenario 2 Same subject same param same avisitn with same ADY (AWDIFF=awtarget-ady) USUBJID VISIT VISITNUM AVISIT AVISITN PARAM AVAL AWTARGET ADY AWDIFF 102 WEEK 1 25 Week 1 20 PAR1 55 5 4 1 102 WEEK 1 25 Week 1 20 PAR1 50 5 4 1 (need to create an additional record with average of AVAL for these multiple records and create new variable dtype="AVERAGE" and FLG="Y" for that record) Scenario 3 Same subject same param different avisitn with same ADY and AWDIFF=0 USUBJID VISIT VISITNUM AVISIT AVISITN AVAL PARAM AWTARGET ADY AWDIFF 103 UNS 20.01 Week 1 20.01 20 PAR1 55 5 5 0 103 UNS 20.02 Week 1 20.02 20 PAR1 50 5 5 0 103 UNS 20.03 Week 1 20.03 20 PAR1 50 5 5 0 need to create an additional record with average of AVAL for these multiple records and create new variable dtype="AVERAGE" and FLG="Y" so the needed output is below USUBJID VISIT VISITNUM AVISIT AVISITN PARAM AVAL AWTARGET ADY AWDIFF FLG DTYPE 101 WEEK 1 25 Week 1 20 PAR1 55 5 4 1 Y 101 WEEK 1 25 Week 1 20 PAR1 50 5 3 2 102 WEEK 1 25 Week 1 20 PAR1 5 5 5 4 1 102 WEEK 1 25 Week 1 20 PAR1 50 5 4 1 102 WEEK 1 25 Week 1 20 PAR1 Avg 5 4 1 Y AVG etc...

ambadi007 · ‎08-17-2021

Hi Experts , I have a dataset below , I need to find the 96 hr dates i to a different column Called "Date 96" I was using a filter in the Timepont variable like timepoint="96hr". But now my requirement is i need to take the last date if the subject is reacched 96hr timepoint and if the subject is not reached 96 hr time point (eg:Subject 102) then i dont need show that date.i Date 96 column Subject Timepoint Date 100 24hr 12/10/2020 100 36hr 12/11/2020 100 96hr 12/12/2020 101 24hr 12/9/2021 101 36hr 30/10/2021 101 96hr 15/10/2021 101 Rate Change 25/12/2021 102 24hr 12/9/2021 102 36hr 30/10/2021 102 Rate Change 25/12/2021 So the new column should looks like below Subject Timepoint Date 96hrdate 100 24hr 12/10/2020 100 36hr 12/11/2020 100 96hr 12/12/2020 12/12/2020 101 24hr 12/9/2021 101 36hr 30/10/2021 101 96hr 15/10/2021 101 Rate Change 25/12/2021 25/12/2021 102 24hr 12/9/2021 102 36hr 30/10/2021 102 Rate Change 25/12/2021

ambadi007 · ‎03-17-2021

thanks it worked for me

ambadi007 · ‎03-17-2021

parta; prtb 101 102 102 101 103 103 here the parta is the main dataset.. if i have parta and part b same subject (eg-103) i need to display only parta subjects information since this the initial data that is collected

ambadi007 · ‎03-17-2021

it would be good if we can set the datasets

ambadi007 · ‎03-17-2021

Hi Team, I have 2 datasets First dataset name is Part1 and other is Part2.. in Part1 have some subjects and information and PArt2 has some other Subjects information Now i need to set these 2 datasets using subject, and the condition is if Part1 and Part2 have same subjects then I need to display only the information from Part1 dataset while setting or merging Could you please help me on these

ambadi007 · ‎10-10-2020

could you please provide me a code for this, then it would be great

ambadi007 · ‎10-10-2020

Dear Experts, I need a help based on the data i provided. I need to create a new variable (in data i named as Wanted_Var) based on the visits . Need to to concatenate the result variable with a comma horizontally based on the visits for a particular id ( need the complete result to concatenate for a particular id for all the visits.) , The Wanted Variable should have added a numeric value also ( ie if its None then it should be like 0-None, or Severe it should like 1-Severe). Below the data is available id Visit result Wanted_Var 100 vs1 None 0-None,1-Severe,2-Moderate,2Moderate 100 vs2 Severe 0-None,1-Severe,2-Moderate,2Moderate 100 vs3 Moderate 0-None,1-Severe,2-Moderate,2Moderate 100 vs4 Moderate 0-None,1-Severe,2-Moderate,2Moderate 101 vs1 None 0-None,1-Severe 101 vs2 Severe 0-None,1-Severe 102 vs1 Moderate 2-Moderate,2-Moderate,2-Moderate,2-Moderate,1-Severe 102 vs2 Moderate 2-Moderate,2-Moderate,2-Moderate,2-Moderate,1-Severe 102 vs3 Moderate 2-Moderate,2-Moderate,2-Moderate,2-Moderate,1-Severe 102 vs4 Moderate 2-Moderate,2-Moderate,2-Moderate,2-Moderate,1-Severe 102 vs5 Severe 2-Moderate,2-Moderate,2-Moderate,2-Moderate,1-Severe

ambadi007 · ‎08-16-2020

I have tried already with descending total, but it works only with that particular record, i need to move up the other 2 sub category also with this.. is there any way to create a new sort variable to sort this in such a way

ambadi007 · ‎08-16-2020

I have a data set as below ord Label Mild Moderate Severe Total 1 Number of subjects dosed 6 2 Number of subjects with an Event 2 1 0 3 3 Gastrointestinal disorders 1 0 0 1 4 Vomiting 1 0 0 1 5 General Disorder 1 0 0 1 6 Chills 1 0 0 1 7 Innjury,poisoning and other 1 1 0 1 8 Prodeduralheadache 1 1 0 1 9 prodeduralpain 1 0 0 1 10 NervousSystem Disorders 2 0 0 2 11 Headache 1 0 0 1 12 Parasthesia 1 0 0 1 Here in the column label colored in Red is the heading for the different diseases and down for that is names . I need to sort the data set in such a way that the label NervousSystem Disordersdisorder total is 2 , so it should come above in the dseas names. so after the ord2 NervousSystem Disorders and the particular names should come...Below is the sample dataset which i need for better understanding i have marked the changed values in green ord Label Mild Moderate Severe Total 1 Number of subjects dosed 6 2 Number of subjects with an Event 2 1 0 3 3 NervousSystem Disorders 2 0 0 2 4 Headache 1 0 0 1 5 Parasthesia 1 0 0 1 6 Gastrointestinal disorders 1 0 0 1 7 Vomiting 1 0 0 1 8 General Disorder 1 0 0 1 9 Chills 1 0 0 1 10 Innjury,poisoning and other 1 1 0 1 11 Prodeduralheadache 1 1 0 1 12 prodeduralpain 1 0 0 1

ambadi007 · ‎08-15-2020

Hi Team, I need to sort the attached data set (attached a data set image) as per the values (Col5) Actually the sorting needs to be started from ord3. ord 1 and 2 should be as it is. The requirement is the Ord10 respective col5 value is 2 So the sorting should be , instead of ord3 and 4. it should be ord 10-12. (ord 11 and 12 is the sub category of ord10) Also if the col5 values all are equal then it should sort the alphabetic wise the dataset image

ambadi007 · ‎07-28-2020

it worrked which has data ... but for getting cat1=0 that time it is not working

ambadi007 · ‎07-28-2020

I just need two macro variable if the dateset is empty then cat1=0 else cat1=1 like wise for another dataset if no records cat2=0 else cat2=1 because i need to use these macros variable later in my code

ambadi007 · ‎07-28-2020

I tried the code but Iam getting if the data is available i.e the cat1=1 but if no records Iam not getting the zero value in the macro variable @Reeza wrote: %macro drive(index); %let dsid=%sysfunc(open(test&index)); %if &dsid ne 0 %then %do; %let cnt=%sysfunc(attrn(&dsid,nlobs)); %let rc=%sysfunc(close(&dsid)); %if &cnt ne 0 %then %do; %let var&index = 1; %end; %else %do; %let var&index = 0; %end; %end; %else %put test&index cannot be open.; %mend drive; %drive(1) %drive(2) Untested and modified from here - which has full details of the macro. @ambadi007 wrote: I have 2 datasets named named Test1 and Test2 Test1 is having no records now and i need to create a macro variable (cat1) from test1 with a value cat1=0 since this has no records , but in future if data comes that macro value should be cat1=1. similarly test2 has data so this macro variable name should be cat2=1 , also if no data in future I should get a macro which cat2=0 like this the code should be dynamic ... Any help appreciated ...

ambadi007 · ‎07-28-2020

I have 2 datasets named named Test1 and Test2 Test1 is having no records now and i need to create a macro variable (cat1) from test1 with a value cat1=0 since this has no records , but in future if data comes that macro value should be cat1=1. similarly test2 has data so this macro variable name should be cat2=1 , also if no data in future I should get a macro which cat2=0 like this the code should be dynamic ... Any help appreciated ...

Online Status	Offline
Date Last Visited	‎07-16-2025 10:59 PM

need to calculate ne/PY and ne/100py

Calculating Ne/Py and nE/100PY

Re: Need counts of subjects available in visit

Re: Need counts of subjects available in visit

Re: Need counts of subjects available in visit

Re: Need counts of subjects available in visit

Re: Need counts of subjects available in visit

Re: Need counts of subjects available in visit

Need counts of subjects available in visit

Re: Logistic regression Analysis

Re: Want the counts aggregately by visit wise.

Re: Filtering a condition using time points

Re: File format

Re: Auto run of the SAS jobs

Re: Auto run of the SAS jobs

Create password protetcted excel sheet

Creating flag and additional record

Filtering a condition using time points

Re: Subject wise display while setting 2 datasets

Re: Subject wise display while setting 2 datasets

Re: Subject wise display while setting 2 datasets

Subject wise display while setting 2 datasets

Re: Need to get the result value horizontally based on the visit varia...

Need to get the result value horizontally based on the visit variable

Re: Need to sort the values as per the highest value in col5

Re: Need to sort the values as per the highest value in col5

Need to sort the values as per the highest value in col5

Re: Need to create a macro variable from a dataset

Re: Need to create a macro variable from a dataset

Re: Need to create a macro variable from a dataset

Need to create a macro variable from a dataset