About michtka

michtka · ‎04-13-2012

I got it proc summary data=new nway missing; class treattxt eff_rslt visder; var itt; output out=newsum(drop=_:) n=n; run;

michtka · ‎04-13-2012

Hi everyone, I need help with this for using proc summary.... I've got the next dataaset : Obs VISit classy pop TREAT 1 Baseline Missing 1 Placebo 2 Week 12 LOCF I 1 Placebo 3 Baseline II 1 Placebo 4 Baseline II 1 Placebo 5 Baseline II 1 Placebo 6 Baseline II 1 Placebo 7 Baseline II 1 Placebo 8 Baseline II 1 Placebo 9 Baseline II 1 Placebo 10 Baseline II 1 Placebo 11 Baseline II 1 Placebo 12 Baseline II 1 Placebo 13 Baseline II 1 Placebo 14 Baseline II 1 Placebo 15 Baseline II 1 Placebo 16 Baseline II 1 Placebo 17 Baseline II 1 Placebo 18 Baseline II 1 Placebo 19 Baseline II 1 Placebo 20 Baseline II 1 Placebo 21 Baseline II 1 Placebo 22 Baseline II 1 Placebo 23 Baseline II 1 Placebo 24 Baseline II 1 Placebo 25 Baseline II 1 Placebo 26 Baseline II 1 Placebo 27 Baseline II 1 Placebo 28 Baseline II 1 Placebo 29 Week 12 LOCF II 1 Placebo I type: proc summary data=new nway; class treat classy visit; var pop; output out=newsum(drop=_:); run; and I obtain: Obs TREAt class VISit pop 1 Placebo I Week 12 LOCF 1 2 Placebo I Week 12 LOCF 1 3 Placebo I Week 12 LOCF 1 4 Placebo I Week 12 LOCF 1 5 Placebo I Week 12 LOCF . 6 Placebo II Baseline 26 7 Placebo II Baseline 1 8 Placebo II Baseline 1 9 Placebo II Baseline 1 10 Placebo II Baseline 0 11 Placebo II Week 12 LOCF 1 12 Placebo II Week 12 LOCF 1 13 Placebo II Week 12 LOCF 1 14 Placebo II Week 12 LOCF 1 15 Placebo II Week 12 LOCF . I was expecting the real summary and as well the missing value, and it is not...what I am doing wrong here ? Thanks in advance.

michtka · ‎04-13-2012

Hi MikeZdeb...using your advice with the next dadtaset : Obs VISit classy pop TREAT 1 Baseline Missing 1 Placebo 2 Week 12 LOCF I 1 Placebo 3 Baseline II 1 Placebo 4 Baseline II 1 Placebo 5 Baseline II 1 Placebo 6 Baseline II 1 Placebo 7 Baseline II 1 Placebo 8 Baseline II 1 Placebo 9 Baseline II 1 Placebo 10 Baseline II 1 Placebo 11 Baseline II 1 Placebo 12 Baseline II 1 Placebo 13 Baseline II 1 Placebo 14 Baseline II 1 Placebo 15 Baseline II 1 Placebo 16 Baseline II 1 Placebo 17 Baseline II 1 Placebo 18 Baseline II 1 Placebo 19 Baseline II 1 Placebo 20 Baseline II 1 Placebo 21 Baseline II 1 Placebo 22 Baseline II 1 Placebo 23 Baseline II 1 Placebo 24 Baseline II 1 Placebo 25 Baseline II 1 Placebo 26 Baseline II 1 Placebo 27 Baseline II 1 Placebo 28 Baseline II 1 Placebo 29 Week 12 LOCF II 1 Placebo following your advice, i type: proc summary data=new nway; class treat classy visit; var pop; output out=newsum(drop=_:); run; and I obtain: Obs TREAt class VISit pop 1 Placebo I Week 12 LOCF 1 2 Placebo I Week 12 LOCF 1 3 Placebo I Week 12 LOCF 1 4 Placebo I Week 12 LOCF 1 5 Placebo I Week 12 LOCF . 6 Placebo II Baseline 26 7 Placebo II Baseline 1 8 Placebo II Baseline 1 9 Placebo II Baseline 1 10 Placebo II Baseline 0 11 Placebo II Week 12 LOCF 1 12 Placebo II Week 12 LOCF 1 13 Placebo II Week 12 LOCF 1 14 Placebo II Week 12 LOCF 1 15 Placebo II Week 12 LOCF . I was expecting the real summary and aswell the missing value, and it is not...what i am doing wrong here ? Thanks in advance.

michtka · ‎04-13-2012

Thanks Mikezdeb totally understand using class, and proc summary nway with the (drop=_:) in the output...it is most better than using two proc sorting and proc means before get the proc transpose. Thanks a lot . V.

michtka · ‎04-13-2012

Thanks Ksharp, I like what about (been told by data_null): ... proc means data=new2 noprint ; by cpevent sex; var age; output out=new3(drop=_type_ _freq_) n=n min=min max=max mean=mean std=std median=median range=range; format n 3. min 3. max 3. mean 6.1 std 6.2 media 3. range 3.; run; proc transpose data=new3 out=new4 (where=_name_ ne 'CPEVENT' ); by cpevent ; id sex; var n min max mean std median range cpevent; /* adding cpevent to change the variables (F,M) from numeric to character */ run; Another 2 questions in the way of optimizing my code... 1. What do you think of the idea to use class rather than by in the proc means? I know that using class instead of by and ridding off a previous proc sorting is a bit tentative...but any sugestion in favour of ussing by rather than class? 2. Which is the difference between proc means of proc summary nway Many thanks in advance.

michtka · ‎04-12-2012

Thanks, it works although you have to force all the statistical values to have the same format , but thanks for your reply. About by and class, thanks again, it works too ussing class withouth pre- proc sorting unlike I did choosing by....but There are two differences (I think you will know): Firstly - BY only works if your dataset is sorted on the specified BY variables; CLASS works whether or not your dataset is sorted (but if you want good performance, you should have enough memory to handle all the classification levels without incurring swapping.) Secondly - Unlike BY variables, CLASS variables give you automatic subtotals (unless you specify a keyword such as NWAY or LEVELS). In your example, CLASS a b will give you an overall total, a subtotal for each distinct value of a, a subtotal for each distinct value of b, and a subtotal for each combination of a and b. These different subtotals are flagged by different values of the _TYPE_ variable which is created automatically in your output dataset.

michtka · ‎04-12-2012

any sugestion, you mean convert the numeric mean to character before the transposition? Thanks.

michtka · ‎04-12-2012

retain Hi Everyone, anyone can tell me why the variable mean dont retain the format when I make proc transpose? Thanks in advance, V proc means data=newss noprin; var vsbasech; by vstext visit cpevent treattxt; output out=newssmed n=n mean=mean std=std median=median min=min max=max; format mean 6.1; run; proc sort data=newssmed out=newssmeds; by visit cpevent; run; proc transpose data=newssmeds out=newssmedst (drop=_label_); by visit cpevent; id vstext treattxt; var n mean std median min max; run;

michtka · ‎04-12-2012

Thanks Ksharp, it works. Another weird problem, when I format the variable mean in proc means, when i make proc transpose, the mean dont retain the format before. do you know Why? proc means data=newss noprin; var vsbasech; by vstext visit cpevent treattxt; output out=newssmed n=n mean=mean std=std median=median min=min max=max; format mean 6.1; run; proc sort data=newssmed out=newssmeds; by visit cpevent; run; proc transpose data=newssmeds out=newssmedst (drop=_label_); by visit cpevent; id vstext treattxt; var n mean std median min max; run;

michtka · ‎04-11-2012

Hi everyone, if you run the below piece of code, you will obtain the next dataset *: Please can someone help me to calculate a final dataset including the median and range to this dataset * using the below piece of code, resulting something like that: cpevent _stat_ f m week1 max week1 mean week1 n week1 std week1 median week1 range and so on... dataset * -------------------- cpevent _STAT_ F M Week1 MAX 12.0000 12.0000 Week1 MEAN 11.6667 11.7500 Week1 MIN 11.0000 11.0000 Week1 N 3.0000 4.0000 Week1 STD 0.5774 0.5000 Week2 MAX 14.0000 14.0000 Week2 MEAN 13.5000 13.6667 Week2 MIN 13.0000 13.0000 Week2 N 4.0000 3.0000 Week2 STD 0.5774 0.5774 Week3 MAX 15.0000 16.0000 Week3 MEAN 15.0000 15.3333 Week3 MIN 15.0000 15.0000 Week3 N 2.0000 3.0000 Week3 STD 0.0000 0.5774 piece of code: ------------------- data new (keep=cpevent sex age); set sashelp.class; if 12 => age then cpevent='Week1'; else if 12 < age < 15 then cpevent='Week2'; else cpevent='Week3'; run; proc sort data=new out=new2; by cpevent sex; run; proc means data=new2 noprint; by cpevent sex; var age; output out=new3 (drop=_type_ _freq_); run; proc sort data=new3 out=new4; by cpevent _stat_; run; proc transpose data=new4 out=new5 (drop=_name_); by cpevent _stat_; id sex; var age; run; Thanks in advance. V.

michtka · ‎04-11-2012

It works to me too. Thanks

michtka · ‎04-02-2012

Hi everyone, How can I transform this dataset A dataset using proc transpose in * dataset: A dataset agex treat Sex COUNT count2 13-24 drug F 4 6 13-24 drug M 2 6 13-24 PLA F 2 6 13-24 PLA M 4 6 less than 13 drug F 2 4 less than 13 drug M 2 4 less than 13 PLA F 1 3 less than 13 PLA M 2 3 * dataset Obs agex drugF drugM drugT PLAF PLAM plaT 1 13-24 4 2 6 2 4 6 2 less than 13 2 2 4 1 2 3 Thanks in advance. V

michtka · ‎04-02-2012

Hi everyone, after doing proc freq to a demog dataset I obtain new4f: agex treat Sex COUNT 13-24 drug F 4 13-24 drug M 2 13-24 PLA F 2 13-24 PLA M 4 less than 13 drug F 2 less than 13 drug M 2 less than 13 PLA F 1 less than 13 PLA M 2 Then, after doing proc sort and proc transpose I would expected the next datase *: proc sort data=new4f out=new4fs; by agex; run; proc transpose data=new4fs out=new4fst (drop=_label_ _name_); by agex; id treat sex; var count; run; I would expected somethign like : *dataset new4fst agex drugf drugm plaf plam 13-24 4 2 2 4 less than 13 2 2 1 2 but, windows sas log shown the next error: 151 by agex ; 152 id treat sex; --- 22 - 200 ERROR 22-322: Expecting ;. ERROR 200-322: The symbol is not recognized and will be ignored. what I am doing wrong? Thanks in advance. V

michtka · ‎03-29-2012

Hi guys, I would like to know more about the applicatibility of PCA (Principal Component Analysis) in the Pharma industry. I have experience using it in biophysics using MATLAB and I would like to start understanding the applicability of using this method in SAS. I know that not always the two reduce-dimensions of maximal variance obtaining with PCA, give you the maximal information of the problem, but it is a powerful method in multivariate analysis. Some refferences to books, examples or some papers could help too. Thanks. V.

michtka · ‎03-29-2012

Hi guys, I dont know about using the proc qsl for the structure I wanted: proc sort nodupkey proc frequency proc transpose I understand it looks like more code programming, but it is more intuitive to me Thanks anyway for the discussion.

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: HR interpretation for 3 different scenarios

Re: HR interpretation for 3 different scenarios

Re: HR interpretation for 3 different scenarios

Re: HR interpretation for 3 different scenarios

Re: HR interpretation for 3 different scenarios

HR interpretation for 3 different scenarios

get then minimum value when you have missing values

Re: macro (Warning:apparent symbol not resolved)

Re: macro (Warning:apparent symbol not resolved)

macro (Warning:apparent symbol not resolved)

Re: show row with missing data in a summary table

Re: code more efficient

Re: removing leading zeros of a character variable

Index where if

Re: multimacrovariables in sql

Re: sorting dataset descending frequency

Re: proc sql instead of proc sort nodupkey

Re: proc summary nway help

proc summary nway help

Re: retain the format var in proc transpose

Re: retain the format var in proc transpose

Re: median and range of a final dataset

Re: retain the format var in proc transpose

Re: median and range of a final dataset

retain the format var in proc transpose

Re: median and range of a final dataset

median and range of a final dataset

Re: proc transpose with two id variables

proc transpose two counts dataset

proc transpose with two id variables

PCA (Principal component analysis) in pharma

Re: proc sort nodupkey equivalent proc sql