About DmytroYermak

DmytroYermak · ‎10-18-2017

Thank you for the quick reply!

DmytroYermak · ‎10-18-2017

Thank you, Cynthia. I need some time to be familiarized with. I will return with questions later on, if any.

DmytroYermak · ‎10-18-2017

Hi all, I have string value: Cohort 33 / 0.1 mg/kg and have to add 3 more empty spaces between slash and 6, like this one: Cohort 39 / 0.2 mg/kg What is the best solution for the case? Transword and simple concatination are not working.

DmytroYermak · ‎10-18-2017

Hi all, Hi all, Could you please help in the following case. I have to shift text within one column in Proc Report. At the moment I have two variables: 1 - Timepoint and 2 - Statistic. In the table ones have to be 'almost in one column'.

DmytroYermak · ‎10-17-2017

Thank you! I have coded as you recommended: *...**; LN_PCORRESN=log(PCORRESN); *...**; proc means data=pretable2 mean std cv min median max; var PCORRESN LN_PCORRESN; class PCSEQ TRT01AN; run; *...**; data pretable4; set pretable3; Geom_mean=exp(LN_PCORRESN_Mean); run; Just one question left: You provided the following formula of Geometric %CV: geo_cv = sqrt{exp[std_lnx**2]-1} On the same time in the in the programming specification I have found the following one: CV% geo-mean = sqrt (exp (variance for log transformed data)-1)*100. Just one question left: Is the 'variance for log transformed data' equal to 'std_lnx**2'? Or " **2 " was missed in the specification formula?

DmytroYermak · ‎10-17-2017

Thank you for the explanations! It has worked.

DmytroYermak · ‎10-17-2017

Hi RW9. Thank you for your code. The matter is that the CAT1 does not correspond to Min, Max and Mean. It is just a coincidence. The CAT1 should be left as is.

DmytroYermak · ‎10-17-2017

Hi all, Could you please help to transpose the table below as picture - the algorythm. I have attached a code as well. Should it be proc transpose or arrays are more applicable here. Thank you! data test; infile datalines; input cat1 cat2 min max mean; datalines; 1 1 1 9 5 1 2 2 7 4 1 3 3 8 5 1 4 2 8 5 1 5 2 9 4 1 6 1 7 5 1 7 2 9 4 1 8 3 8 4 2 1 4 7 5 2 2 1 8 6 2 3 2 9 5 2 4 3 8 6 2 6 3 8 6 2 7 1 7 5 2 8 2 9 5 3 1 2 7 4 3 3 3 8 5 3 4 3 9 6 3 5 1 8 5 3 6 3 9 4 3 7 1 7 5 3 8 2 9 6 ; run;

DmytroYermak · ‎10-17-2017

Thank you, Cynthia. In my understanding the style Journal is a default style of SAS and it is standard for clinical trials Listings and Tables. It means that even we use a %print it just calls for this template 'Journal' and does not modify it. Is it correct interpretation? How could I access the template and modify it?

DmytroYermak · ‎10-14-2017

Thank you for the replies! I will publish the code here later on.

DmytroYermak · ‎10-13-2017

Hi all, Could you please advise what SAS procedure can complete all this analysis? Timepoint Statistic -------------------------------------- Pre-Dose n Arithmetic Mean Geometric Mean SD %CV Geometric %CV Min Median Max

DmytroYermak · ‎10-11-2017

It has worked! Thank you very much!

DmytroYermak · ‎10-11-2017

Hi all, Please advise how to manage the following case. I have to select the values FLAG1 and FLAG2 from the first line of the group and FLAG3 and IDENT from the last line. Could you please advise a compact algorythm? The sample code is attached. Thank you! data test; infile datalines dlm='/'; input FLAG1 : $1. FLAG2 : $1. FLAG3 : $1. IDENT : $7.; datalines; Y / N / / ABC-101 N / N / / ABC-101 N / N / Y / ABC-101 Y / N / / ABC-102 N / N / / ABC-102 N / N / / ABC-102 N / N / / ABC-102 N / N / / ABC-103 N / N / / ABC-103 N / N / / ABC-103 N / N / N / ABC-103 ; run;

DmytroYermak · ‎10-09-2017

Thank you, Cynthia. I'm using the code below. It think that the style is defined in system options before the block but I have not found it. Possibly they are in system macros.

DmytroYermak · ‎10-08-2017

Hi all, Could you please help in the following case. There is a line on each page when final listing is printed. Please see the picture below. Is there a method to eliminate the line?

Online Status	Offline
Date Last Visited	‎12-14-2025 06:28 AM

Re: Proc Freq and Variable Worth

Re: Proc Freq and Variable Worth

Proc Freq and Variable Worth

Re: Proc mixed: formats of the output dataset

Re: Proc mixed: formats of the output dataset

Proc mixed: formats of the output dataset

Re: Proc sgplot: how to add one empty category on y axis and change th...

Re: Proc sgplot: how to add one empty category on y axis and change th...

Proc sgplot: how to add one empty category on y axis and change the sc...

Extending keylegend for group proc sgplot

Add new dataset options for changing variable attributes other than na...

Re: Proc mixed: formats of the output dataset

Re: Proc mixed: formats of the output dataset

Re: Proc mixed: formats of the output dataset

Re: Extending keylegend for group proc sgplot

Re: Values of 'Proc Mean' into dataset

Meaning of variables AEENRF and AEENRTPT from AE Domain (from SDTM)

Re: How to make graph area wider in proc sgplot

Re: How to covert MMM YYYY to iso format?

Re: Import excel data and time

Re: Insert more than one space into character variable

Re: Shift within one column in Proc Report

Insert more than one space into character variable

Shift within one column in Proc Report

Re: Geometric Mean and %CV

Re: Transpose of complex table #2

Re: Transpose of complex table #2

Transpose of complex table #2

Re: The 'end'-horizontal line to be eliminated in listing after 'proc ...

Re: Geometric Mean and %CV

Geometric Mean and %CV

Re: Selecting several first and last values of variables

Selecting several first and last values of variables

Re: The 'end'-horizontal line to be eliminated in listing after 'proc ...

The 'end'-horizontal line to be eliminated in listing after 'proc repo...