About knveraraju91

knveraraju91 · ‎08-17-2017

Dear, In my data three subjects with 11 obs present. The subject 'a' has all visit obs. The subject 'b' and 'c' has a few missing visits. I need to populate all the visits with values from previous 'aval' variable values. Each subject should have all the visit obs Eg; Subject b has missing visit 2. The 'visitnum= 2' obs is populated with aval from visitnum;=1 Thank you data one; input name $ visitnum aval; datalines; a 1 10 a 2 20 a 3 30 a 4 40 a 5 50 b 1 10 b 3 30 b 4 40 b 5 50 c 1 10 c 2 20 ; out put needed; a 1 10 a 2 20 a 3 30 a 4 40 a 5 50 b 1 10 b 2 10 b 3 30 b 4 40 b 5 50 c 1 10 c 2 20 c 3 20 c 4 20 c 5 20

knveraraju91 · ‎06-23-2017

Dear, I need to sort the data by different sorting order based on Total value. if Total is not equal to 0 then sort order should be "descending total id". if total is equal =0 then sort order should be "descending total descending placebo id" The OBS (id=d and id=e) has total values equal=0. As per alphabetical order the id=d should come first. But I need id=e should come before id=d as its placebo value is greater than id=d. Please help. Thank you Output needed; b 4 8 12 3 i 6 6 12 1 c 7 4 11 0 j 7 3 10 0 a 2 4 6 1 f 1 0 1 2 g 1 0 1 3 e 0 0 0 3 d 0 0 0 2 data one; input id$ _10mg _20mg Total placebo; datalines; a 2 4 6 1 c 7 4 11 0 b 4 8 12 3 d 0 0 0 2 e 0 0 0 3 f 1 0 1 2 g 1 0 1 3 i 6 6 12 1 j 7 3 10 0 ;

knveraraju91 · ‎06-05-2017

Dear, Thank you very much for the code.You code works for me for the sample data I posted. But if the bodsys values increase it is not getting the output i need. In the below example, The decod value='lymph' is populating for next OBS where bodsys='clsd' Output needed; output needed; Bodsys decod sev blsd mild blsd moderate blsd severe blsd anae blsd anae mild blsd anae moderate blsd anae severe blsd lymp blsd lymp mild blsd lymp moderate blsd lymp severe clsd mild clsd moderate clsd severe clsd cnae clsd cnae mild clsd cnae moderate clsd cnae severe data one; input bodsys $4. +1 decod $4. +1 sev $8.; datalines; blsd mild blsd moderate blsd severe blsd anae blsd mild blsd moderate blsd severe blsd lymp blsd mild blsd moderate blsd severe clsd mild clsd moderate clsd severe clsd cnae blsd mild blsd moderate blsd severe ; data want; set one; retain hold; if not missing(decod) then hold=decod; decod=hold; run; output getting; Bodsys decod sev blsd mild blsd moderate blsd severe blsd anae blsd anae mild blsd anae moderate blsd anae severe blsd lymp blsd lymp mild blsd lymp moderate blsd lymp severe clsd lymp mild clsd lymp moderate clsd lymp severe clsd cnae clsd cnae mild clsd cnae moderate clsd cnae severe

knveraraju91 · ‎06-05-2017

Dear, For sorting a dataset I need to populate the decod values all relavent OBS . Please help. Thank you very much output needed; Bodsys decod sev blsd mild blsd moderate blsd severe blsd anae blsd anae mild blsd anae moderate blsd anae severe blsd lymp blsd lymp mild blsd lymp moderate blsd lymp severe ; data one; input bodsys $4. +1 decod $4. +1 sev $8.; datalines; blsd mild blsd moderate blsd severe blsd anae blsd mild blsd moderate blsd severe blsd lymp blsd mild blsd moderate blsd severe ;

knveraraju91 · ‎06-02-2017

Dear, i am using the below program to read the dates in data one. Please suggest any other way to convert the dates. Thank you. data one; input date $11.; datalines; Oct//5/2012 Jan/20/2012 ; data two; set one; date2=put(input(strip(scan(date,2,'/'))||strip(scan(date,1,'/'))||strip(scan(date,3,'/')),date9.),is8601da.); run;

knveraraju91 · ‎05-28-2017

Dear, I am trying to calculate number of subjects for dose and Total number in my data. I got the values i need in my output except for "Total " variable. In the program below, there are 6 distinct subjects in the data. But I am getting 8 for total value. Please help in my code to get 6 for 'Total' variable. Thank you data one; input id term$ dose$; datalines; 1 hache 10mg 1 sache 20mg 2 epain 20mg 2 lpain 10mg 3 rash placebo 4 coli 40mg 5 capin 40mg 6 naus 40mg 6 vomit 20mg ; proc sql; create table two as select count(distinct ID) as NS,dose from one where dose in ('10mg' '20mg' '40mg' 'placebo') group by dose; quit; proc transpose data=two out=three(drop=_NAME_); var NS; id dose; run; data four; set three; array data _10mg _20mg _40mg placebo; do over data; if missing(data) then data=0; end; TOTAL=_10mg + _20mg + _40mg ; run;

knveraraju91 · ‎05-25-2017

Then my output is NS TRT 2 30mg 3 45mg 1 placebo 1 15mg Thank you

knveraraju91 · ‎05-25-2017

Dear, In the ouput result of the below program (in the grey box), I need to have zero count(NS=0) when there are no subjects present for the treatment. Output needed: NS TRT 2 30mg 3 45mg 1 placebo 0 15mg output getting NS TRT 2 30mg 3 45mg 1 placebo data one; input id trt$ sflag$; datalines; 1 45mg Y 2 30mg Y 3 15mg N 4 30mg Y 5 45mg Y 6 plcebo Y 7 45mg Y ; PROC SQL; create table two as select count(distinct id) as NS,trt from one where sflag='Y' group by trt; quit; I think I can get the output by two proc transpose and two datsteps inbetween. But please suggest me if any better way to do this. Thank you very much program I am running to get output I need proc transpose data=two out=three(drop=_NAME_); var NS; id TRT; run; data four; set three; array data _15mg _30mg _45mg placebo; do over data; if missing(data) then data=0; end; TOTAL=_15mg + _30mg + _45mg ; run; proc transpose data=four out=five; var placebo _15mg _30mg _45mg total ; run;

knveraraju91 · ‎05-20-2017

Dear, After running the below program the output i got is(Document attached). But I need to have in my outdata inaddition to the output is eg; for dose='100mg' and term='bleed' and sev='severe' there is only one obs in the output. I need to have obs with zero values for all SEV variable values for all OBS. Please help in my code. Thank you eg: output needed for a obs: term sev 50 100 bleed mild 0 0 bleed moderate 0 0 bleed severe 0 1 output getting term sev 50 100 bleed severe 0 1 data one; input id dose $ term $ sev $; datalines; 1 50mg hache mild 2 50mg naus moderate 3 100mg vomi mild 4 50mg ulce mild 5 100mg bleed severe 6 100mg rash moderate 7 50mg naus moderate 8 50mg naus mild ; proc sql; create table two as select count(distinct ID) as NS,dose,term,sev from one group by dose,term,sev; quit; proc sort data=two; by dose term sev; run; proc transpose data=two out=three(drop=_NAME_); by dose term sev ; var NS; id dose; run; data four; set three; array data _50mg _100mg; do over data; if missing(data) then data=0; end; TOTAL= _50mg + _100mg ; run;

knveraraju91 · ‎05-16-2017

Resolved. I had to use %global statement before proc sql statement. Thank you

knveraraju91 · ‎05-16-2017

Dear, In the program below I had to create macro variables using proc sql in a macro. When I created the macro variables &a1 and &b1 outside of %macro one, I am able to use in data step two. But when I used the SQL code in the %macro one, I am getting errors when I call the macro variables &a1 and &b1 in data two. The % global statement is not working here. Please help. Thank you very much data one; input id flag1$ flag2$; datalines; 1 Y N 2 Y N 3 Y Y 4 Y Y 5 Y N 6 N Y 7 N Y 8 N N ; %macro one(var1=,var2=); proc sql noprint; select count(distinct id) into :&var1 from one where flag1='Y'; select count(distinct id) into :&var2 from one where flag2='Y'; quit; %global a1 b1; %mend; %one(var1=a1,var2=b1); %put &a1 &b1; data two; set one; if flag1='Y' then ns=&a1; if flag2='Y' then ns=&b1; run;

knveraraju91 · ‎05-12-2017

Thank you very much. % global statemnt worked. Thank you

knveraraju91 · ‎05-12-2017

Thank you very much for the reply. Some one suggested me to use "%global b1 c1 d1 f1;" in the macro. I think I got my answer. Thank you very much for the outstanding support

knveraraju91 · ‎05-12-2017

Dear, I am able to call the macro variables values created by datastep(withoutmacro) where ever I can by calling "&b1,&c1,&d1,&e1". But the macro variables created by macro step(shown below), I am not able call the macro variables. When I use "&b1,&c1,&d1,&e1" in a datastep,the values of the macrovariables are not called Please help how can I use the macro variables created by the macro step below. Thank you very much data one; input NS trt01a $ ; datalines; 45 150MG 71 300MG 15 75MG 131 TOTAL ; %macro two(var1=,var2=,var3=,var4=,var5=,var6=,var7=); data &var2; set &var1; if trt01a='75MG' then trt="&var3"; if trt01a='150MG' then trt="&var4"; if trt01a='300MG' then trt="&var5"; if trt01a='TOTAL' then trt="&var6"; run; data &var7; set &var2; call symputx(trt,ns); run; %mend; %two(var1=one,var2=two,var3=b1,var4=c1,var5=d1,var6=f1,var7=three); data one; input NS trt01a $ ; datalines; 45 150MG 71 300MG 15 75MG 131 TOTAL ; data withoutmacro; set one; if trt01a='75MG' then trt="b1"; if trt01a='150MG' then trt="c1"; if trt01a='300MG' then trt="d1"; if trt01a='TOTAL' then trt="e1"; run; data withoutmacro1; set withoutmacro; call symputx(trt,ns); run;

knveraraju91 · ‎05-12-2017

Thank you very much. I got the output with the below statement. %put &&&var6 &&&var7 &&&var8 &&&var9;

Online Status	Offline
Date Last Visited	‎12-11-2023 01:43 PM

How to skip every third number in DO iterative loop

how to get l_bin and U_bin values in ods output dataset in proc freq

How to include subjects when calculating commonrisdiff when subject pr...

Re: How insert text in table using proc report in PDF output

How insert text in table using proc report in PDF output

Need help in calculating stratified p-value in my pgm

Re: How to add stratified variables in proc freq code when finding ris...

How to add stratified variables in proc freq code when finding risk di...

How to output one sided pvalue into a dataset

How to have evenly space x-axis using tickvaluelist in proc template

Re: How to skip every third number in DO iterative loop

Re: How to skip every third number in DO iterative loop

Re: how to get l_bin and U_bin values in ods output dataset in proc fr...

Re: how to get l_bin and U_bin values in ods output dataset in proc fr...

Re: Need help in calculating stratified p-value in my pgm

How to output one sided pvalue into a dataset

How to populate LOCF values to all missing obs

How to sort a data set OBS by different sorting order in same step

Re: How to populate a group variable values to all obs

How to populate a group variable values to all obs

Reading date containing multiple delimiters

proc sql help for counting Number of subjects

Re: How to get count as zero when there are no subjects in the data

How to get count as zero when there are no subjects in the data

How to have obs with zero values when the data does not exsit

Re: Macro help

Macro help

Re: Macro help

Re: Macro help

Macro help

Re: Macro help