About vraj1

vraj1 · ‎10-03-2017

i have a datastep which i am using to calculate withdrawals but i need to set condition by using another dataset which has multiple reasons for withdrawals. Can i do that in same datastep? any help. data attached: datastep used is : the one which is bold should be overwritten with the other dataset(_adds) which is attached. How can i take this new dataset by using any condition in the below dataset data work.Disp_Withdraw_w2; set work.Disp_Withdraw_w1; length desc $50. dsreas_fmt $50. sort1 sort2 8.; if compress(actarm) = "BLINDED" then do; desc = vlabel(SAFFL); dsreas_num_BLINDED = 1; dsreas_fmt = "Number of Patients"; sort1 = 1; sort2 = 0; output; if SAFFL='Y' then do; if EOTSTT = 'Completed' then do; dsreas_num_BLINDED = 1; dsreas_fmt = " Completed"; sort2 = 1; output; end; else if EOTSTT ='Discontinued' then do; dsreas_num_BLINDED = 1; dsreas_fmt = " Withdrawn"; sort2 = 2; output; end; end; if PDCTREAS ne "" then do; desc= "ByPrim"; dsreas_num_BLINDED = 1; dsreas_fmt = " "||PDCTREAS; sort1 = 88; output; end; end; if compress(actarm) = "PENDING" then do; desc = vlabel(SAFFL); dsreas_num_PENDING = 1; dsreas_fmt = "Number of Patients"; sort1 = 1; sort2 = 0; output; if SAFFL='Y' then do; if EOTSTT = 'Completed' then do; dsreas_num_PENDING = 1; dsreas_fmt = " Completed"; sort2 = 1; output; end; else if EOTSTT ='Discontinued' then do; dsreas_num_PENDING = 1; dsreas_fmt = " Withdrawn"; sort2 = 2; output; end; end; if PDCTREAS ne "" then do; desc= "ByPrim"; dsreas_num_PENDING = 1; dsreas_fmt = " "||PDCTREAS; sort1 = 88; output; end; end; run;

vraj1 · ‎09-29-2017

If it fulfills all conditions then it should be multiple. But what i get is multiple obs of subjids for almost most of them

vraj1 · ‎09-29-2017

I have the below code with conditions and when i run it it creates double observations. I am creating a dataset which gives 1 if it satisfies a condition for each treatment group. But it resolves seperately and creates duplictes. i use the below condition to have treatment wise but it duplicates like below in my datastep %** Loop for each arm (to avoid transposing the data later) **; %do k = 1 %to %sysfunc(countw(&ArmList., #)); %** Start for each ArmVar **; if compress(&ArmVar.) = "%scan(&ArmList.,&k., #)" then do; %** if ArmVar condition **; and it is resolved to code attached. Can any one help me what i am doing wrong

vraj1 · ‎09-28-2017

I want to extract modified date of a dataset using proc contents. Any example or suggestion please

vraj1 · ‎09-27-2017

Sorry for it. Here is the below correct one data WORK.FINAL; infile datalines dsd truncover; input param:$36. adurn_count:BEST. adurn_percent:$3. de_dfg_count:BEST. de_dfg_percent:$4. total_count:BEST. total_percent:$4.; datalines4; base Tot Score Less Than Equal To 12,3,3.5,112,29.6,115,24.8 No Active next,1,1.2,15,4.0,16,3.4 Outpatient Status,2,2.4,6,1.6,8,1.7 YMRS Tot Score Less Than Equal To 12,1,1.2,25,6.6,26,5.6 ;;;;

vraj1 · ‎09-27-2017

This is how my output should look alike data WORK.FINAL; infile datalines dsd truncover; input dose_fmt:$6. PARAM:$36. COUNT:BEST. PERCENT:BEST.; datalines4; ADURN,base Tot Score Less Than Equal To 12,3,3.5 DE dfg,base Tot Score Less Than Equal To 12,112,29.6 TOTAL,base Tot Score Less Than Equal To 12,115,24.8 ADURN,No Active next,1,1.2 DE dfg,No Active next,15,4 TOTAL,No Active next,16,3.4 ADURN,Outpatient Status,2,2.4 DE dfg,Outpatient Status,6,1.6 TOTAL,Outpatient Status,8,1.7 ADURN,YMRS Tot Score Less Than Equal To 12,1,1.2 DE dfg,YMRS Tot Score Less Than Equal To 12,25,6.6 TOTAL,YMRS Tot Score Less Than Equal To 12,26,5.6 ;;;;

vraj1 · ‎09-27-2017

I need like below data WORK.FINAL; infile datalines dsd truncover; input dose_fmt:$6. PARAM:$36. COUNT:BEST. PERCENT:BEST.; datalines4; ADURN,base Tot Score Less Than Equal To 12,3,3.5 DE dfg,base Tot Score Less Than Equal To 12,112,29.6 TOTAL,base Tot Score Less Than Equal To 12,115,24.8 ADURN,No Active next,1,1.2 DE dfg,No Active next,15,4 TOTAL,No Active next,16,3.4 ADURN,Outpatient Status,2,2.4 DE dfg,Outpatient Status,6,1.6 TOTAL,Outpatient Status,8,1.7 ADURN,YMRS Tot Score Less Than Equal To 12,1,1.2 DE dfg,YMRS Tot Score Less Than Equal To 12,25,6.6 TOTAL,YMRS Tot Score Less Than Equal To 12,26,5.6 ;;;;

vraj1 · ‎09-27-2017

sorry below is my dataset data WORK.INC; infile datalines dsd truncover; input dose_fmt:$50. PARAM:$200. COUNT:32. PERCENT:32.; datalines4; ADURN,base Tot Score Less Than Equal To 12,3,3.5 DE dfg,base Tot Score Less Than Equal To 12,112,29.6 TOTAL,base Tot Score Less Than Equal To 12,115,24.8 ADURN,No Active next,1,1.2 DE dfg,No Active next,15,4 TOTAL,No Active next,16,3.4 ADURN,Outpatient Status,2,2.4 DE dfg,Outpatient Status,6,1.6 TOTAL,Outpatient Status,8,1.7 ADURN,YMRS Tot Score Less Than Equal To 12,1,1.2 DE dfg,YMRS Tot Score Less Than Equal To 12,25,6.6 TOTAL,YMRS Tot Score Less Than Equal To 12,26,5.6 ;;;; run; and i am using the belwo proc transpose proc transpose data=inc out=stab12; by param ; var count percent; id dose_fmt; run; In this output i get percent on one row and count on another whereas i need them to be next to each other.

vraj1 · ‎09-27-2017

i have variable dose param count percent 1_yt nhdi 23 34 2_tr sdg 21 32 I need to transpose these such that dose will be in the header and percent and param will be as it is. I am using the below code but i get percent in one obs and count in other obs. Can any one help me what i am missing proc transpose data=stab11 out=stab12 ; by param ; var count percent; id dose; run;

vraj1 · ‎09-22-2017

If i use the condition if PDCTREAS ne "" then do; then it removes everything which is missing but i need all the data and add new variables. I am not able to find out a way

vraj1 · ‎09-22-2017

Attached data. what i need is if PDCTREAS(resons for withdrawal is present then add a row in desc and desc_fmt and value for treatment as 1 . i am trying the below code but it doesnt work. if PDCTREAS ne "" then do; desc= "ByPrim"; dsreas_num_trt= 1; dsreas_fmt = " "||PDCTREAS; sort1 = 88; output; end;

vraj1 · ‎09-21-2017

Thanks, but this just gives H * or L * I need the entire values like if it is 345 H * i need the entire 345 H *

vraj1 · ‎09-21-2017

It doesnt work unfortunately var 8.3 22 * 6.7 H * 120 H * 34 L * I need the below var 6.7 H * 120 H * 34 L * there is space between number and H or L and *

vraj1 · ‎09-21-2017

I need to have values only which has either "L*" or "H*" values and the rest be deleted.

vraj1 · ‎09-21-2017

Thanks a lot can i include multiple conditions in it like where indexc(var_char,"H*" "L*"); so that i can extract values which has "H*" and "L*"?

Online Status	Offline
Date Last Visited	‎01-24-2023 11:53 AM

Re: extract libnames from excel and create macro variable to call libn...

Re: extract libnames from excel and create macro variable to call libn...

extract libnames from excel and create macro variable to call libnames

Re: how to extract hour minutes and seconds from sas datetime19.

how to extract hour minutes and seconds from sas datetime19.

Re: need to count positive and negative PID's

Re: need to count positive and negative PID's

Re: need to count positive and negative PID's

Re: need to count positive and negative PID's

need to count positive and negative PID's

Re: proc sql - syntax error

Re: new record based on condition

Re: where condition if using multiple datasets in proc sql join

Re: How to handle with length truncation and replacing with valuable i...

Re: Need to extract data from string with conditions

split data based on conditions

Re: Need to retain seq number for same visit

i have a datastep which i am using to calculate withdrawals but i need...

Re: double observations

double observations

can we extract modified date of sas dataset using proc contents

Re: proc tranpose with multiple var variables

Re: proc tranpose with multiple var variables

Re: proc tranpose with multiple var variables

Re: proc tranpose with multiple var variables

proc tranpose with multiple var variables

Re: need to add new row in existing dataset

need to add new row in existing dataset

Re: Need to extract data which has "*" as value

Re: Need to extract data which has "*" as value

Re: Need to extract data which has "*" as value

Re: Need to extract data which has "*" as value