About Vijay77

Vijay77 · ‎03-24-2020

I need output only if below condition satisfies Output if, Sample ID "Serum" is present in dataset A and (COL) = NO or MISSING in the dataset B for same acc ID. Populate NEW_VAR: Sample not collected in B

Vijay77 · ‎12-25-2019

I have a following date i have to convert it to numeric and iso8601 format UN-UNK-1975 UN-OCT-1986 18-OCT Expected o/p: 1975 10-1986 . Thanks

Vijay77 · ‎12-17-2019

need to create a new variable C_date and add B_date Values to C_date variable

Vijay77 · ‎12-17-2019

Hi There, i have a date variable in below format how to convert it to ISO 8601 date format B_date 22AUG19:18:39:28 31AUG19:08:42:53 09SEP19:19:21:23

Vijay77 · ‎11-21-2019

Is it possible to calculate Clopper-Pearson CIs for Proportions of zero. I have 0 obs in output, but i have created a dummy like with count of 0. var trt count A trt1 0 B trt2 0 C trt3 0 Is it possible to calculate Clopper-Pearson CIs for Proportions of zero. I only require upper and lower limits per trt. Thanks, vijay

Vijay77 · ‎10-30-2019

it Worked thank you cheers 😊

Vijay77 · ‎10-30-2019

Hi, i have the following data set , I need sum of group1 group2 and group3 in 4 th observation with Value as 'Tot' for Var1 Variable . obs Var Var1 grp1 grp2 grp3 1) best A 3 4 6 2) best B 4 1 7 3) best C 1 3 1 4) Worst G 5 7 1 5) Worst E 5 2 6 Expected :output; Var Var1 grp1 grp2 grp3 1) best A 3 4 6 2) best B 4 1 7 3) best C 1 3 1 4) Tot 8 8 14 5) Worst G 5 7 1 6) Worst E 5 2 6 7) Tot 10 9 7 (sum of "Worst") Thanks.

Vijay77 · ‎09-20-2019

Thank you

Vijay77 · ‎09-20-2019

Hi, i want data set like these Thanks

Vijay77 · ‎09-20-2019

Hi, I have following data i need count of first three obs in fourth obs with var as tot and count of next three(5,6,7) in obs 8 as var tot eg: obs var cnt 1 eg 3 2 eg 4 3 eg 5 4 tot 12 5 rt 3 6 rt 4 7 rt 1 8 tot 8

Vijay77 · ‎09-20-2019

5

Vijay77 · ‎09-19-2019

apologies its 7

Vijay77 · ‎09-19-2019

i have 3 obs like below i want sum of all 3 in 4th obs 1) 2 (40.0) 2) 1 (20.0) 3) 2 (40.0) 4) 8(100)

Vijay77 · ‎09-18-2019

PROC SQL; CREATE TABLE SL_1 AS SELECT distinct A,AEC,'Patients ' AS VARIABLE, 1 AS GRP, COUNT(DISTINCT SUBJID) AS CNT FROM A(WHERE=(FL='Y')) GROUP BY AEC UNION ALL SELECT distinct A,AEC,'Patients 2' AS VARIABLE, 2 AS GRP, COUNT(DISTINCT SUBJID) AS CNT FROM A(WHERE=(FL='Y' AND FFL='N')) GROUP BY AEC ;quit; How to write above code in Data step

Vijay77 · ‎09-09-2019

Hi, i have two date variables asdtc and estdtc i want to get max(estdtc) when estdtc<=astdtc by subect ? any help would be appreciated i have tried following proc sql; CASE WHEN substr(ESTDTC,1,10)<=ASTDTC THEN MAX(ESTDTC) group by subbjid; quit; but it giving values of max(estdtc) by subject not based on estdtc<=astdtc subjid estdtc astdtc 2008 2019-03-31T06:50 2019-04-02 2008 2019-03-28T19:02 2019-04-02 2008 2019-03-27T19:34 2019-04-02

Online Status	Offline
Date Last Visited	‎03-24-2020 06:12 AM

if condition

convert to iso8601 format

Re: convert to ISO 8601 date

convert to ISO 8601 date

Calculating CI %

Re: sum of values column wise

sum of values column wise

Re: sum of obsevations

Re: sum of obsevations

sum of obsevations

Re: how to append n columns into 1 column in a dataset

Re: Calculating CI %

if condition

convert to iso8601 format

Re: convert to ISO 8601 date

convert to ISO 8601 date

Calculating CI %

Re: sum of values column wise

sum of values column wise

Re: sum of obsevations

Re: sum of obsevations

sum of obsevations

Re: sum of column

Re: sum of column

sum of column

union all in data step

max of date