cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
VRD
‎09-01-2015
  • 33 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: sentence case

by Calcite | Level 5 in SAS Programming
‎12-17-2014 08:14 AM
‎12-17-2014 08:14 AM
Hi all, I somehow cant get it cracked as for my variable i still get few observations with upcase ex: SMALL PARTICLES IN THE RESERVOIR, APPEAR TO BE SILICONE PARTICLES is it because there is no comma or full stop which is not working in this case ... View more

Re: sentence case

by Calcite | Level 5 in SAS Programming
‎12-17-2014 05:59 AM
‎12-17-2014 05:59 AM
i do not have any other signs other than .(full stop). will it still work because i am getting all in upcase after  using patricks code ... View more

Re: sentence case

by Calcite | Level 5 in SAS Programming
‎12-17-2014 05:47 AM
‎12-17-2014 05:47 AM
unfortunately they are not working ... View more

sentence case

by Calcite | Level 5 in SAS Programming
‎12-17-2014 04:49 AM
‎12-17-2014 04:49 AM
I want to make sentence case  through out my variables. For ex: in 3 parts of my paper there are remarks. please go through them. This should become like this In 3 parts of my paper there are remarks. Please go through them. How can this be done. ... View more

i get the following warning when using proc boxplot

by Calcite | Level 5 in Graphics Programming
‎09-22-2014 08:05 AM
‎09-22-2014 08:05 AM
WARNING: Group variable values will be truncated to 32 characters. WARNING: Formatted subgroup variable values will be truncated to 32 characters. i get this warning when using proc boxplot. symbol value=dot color=salmon;    proc boxplot data=endp;       plot rbw * treatlbl /                      cboxes   = dagr                      cboxfill = ywh;             label  rbw = 'Relative Body Weight  change (%)';    run; ... View more

Re: I want to replace missing values with 0

by Calcite | Level 5 in SAS Programming
‎09-03-2014 07:05 AM
‎09-03-2014 07:05 AM
I tried it but unfortunately it didnt work. Also the values in the variable are in character so i followed your step like this. rtp=tranwrd(variable,"( )","(  0 )"); ... View more

Re: I want to replace missing values with 0

by Calcite | Level 5 in SAS Programming
‎09-03-2014 06:27 AM
‎09-03-2014 06:27 AM
It is just a final data set which i need to use in the report. These are counts of N (%)  E  R. Can i use something as if ord=30 and replace the missing values of all treaments into a 0 (0.0) 0  0? ... View more

I want to replace missing values with 0

by Calcite | Level 5 in SAS Programming
‎09-03-2014 05:29 AM
‎09-03-2014 05:29 AM
text ord XXX1 xxxx2 xxxx3 cccc4 bbbb2 nnnn2 mmm2n nbhgb2 All Su 10 1496 2515 3976 429 Exp 15 760 1853 3050 436 All [identified risk] 20 9 ( 0.6)     9  1.2 66 ( 2.6)    78  4.2 132 ( 3.3)   190  6.2 19 ( 4.4)    19  4.4 3 (  . )     3 . 13 (  . )    13 . Meand fsdf gdfag 30 4 ( 0.3)     4  0.5 45 ( 1.8)    51  2.8 90 ( 2.3)   138  4.5 11 ( 2.6)    11  2.5 3 (  . )     3 . 7 (  . )     7 . bdgngndsjmfhjmfh 30 4 ( 0.3)     4  0.5 45 ( 1.8)    51  2.8 90 ( 2.3)   138  4.5 11 ( 2.6)    11  2.5 3 (  . )     3 . 7 (  . )     7 . dgnsfgmn 30 4 ( 0.3)     4  0.5 44 ( 1.7)    50  2.7 88 ( 2.2)   136  4.5 11 ( 2.6)    11  2.5 2 (  . )     2 . 7 (  . )     7 . dxv rthfrthsfbn 30 1 ( 0.0)     1  0.1 2 ( 0.1)     2  0.1 1 (  . )     1 . bhdsfgnfsdgmnfhs 30 5 ( 0.3)     5  0.7 25 ( 1.0)    27  1.5 50 ( 1.3)    52  1.7 8 ( 1.9)     8  1.8 6 (  . )     6 . dbdbdsgjnfgjmnfsgjmnf 30 5 ( 0.3)     5  0.7 25 ( 1.0)    27  1.5 48 ( 1.2)    50  1.6 6 ( 1.4)     6  1.4 6 (  . )     6 . fghnsfggbn cvbnsfgja 30 5 ( 0.3)     5  0.7 25 ( 1.0)    27  1.5 44 ( 1.1)    46  1.5 3 ( 0.7)     3  0.7 6 (  . )     6 . sjhngfjhnsdfhjasdthn 30 4 ( 0.1)     4  0.1 3 ( 0.7)     3  0.7 tasjntgshnsgsgsdfng 30 2 ( 0.1)     2  0.1 2 ( 0.5)     2  0.5 sngdggfnasdfgnasdna 30 2 ( 0.1)     2  0.1 2 ( 0.5)     2  0.5 ... View more

Re: I have a data set in the below format(1) and need to make it like ...

by Calcite | Level 5 in SAS Programming
‎08-29-2014 09:16 AM
‎08-29-2014 09:16 AM
btext1 btext2 btext3 trt1 trt2 trt3 sample1 XXX XXX XXX sample1 ana1 XXX XXX XXX sample1 ana1 ban1 XXX XXX XXX sample1 ana1 ban2 XXX XXX XXX sample1 ana1 ban3 XXX XXX XXX sample1 ana1 ban4 XXX XXX XXX text trt1 trt2 trt3 sample1 XXX XXX XXX ana1 XXX XXX XXX ban1 XXX XXX XXX ban2 XXX XXX XXX ban3 XXX XXX XXX ban4 XXX XXX XXX can any one help me in this? ... View more

i have a dataset like below and need to make it like the second one

by Calcite | Level 5 in SAS Programming
‎08-29-2014 09:09 AM
‎08-29-2014 09:09 AM
btext1 btext2 btext3 trt1 trt2 trt3 sample1 XXX XXX XXX sample1 ana1 XXX XXX XXX sample1 ana1 ban1 XXX XXX XXX sample1 ana1 ban2 XXX XXX XXX sample1 ana1 ban3 XXX XXX XXX sample1 ana1 ban4 XXX XXX XXX text trt1 trt2 trt3 sample1 XXX XXX XXX ana1 XXX XXX XXX ban1 XXX XXX XXX ban2 XXX XXX XXX ban3 XXX XXX XXX ban4 XXX XXX XXX can any one help me in this? ... View more

Re: I have a data set in the below format(1) and need to make it like ...

by Calcite | Level 5 in SAS Programming
‎08-29-2014 08:17 AM
‎08-29-2014 08:17 AM
Sorry for the confusion. I did not mean to drop the last five records. I just forgot to paste them. Sorry. I want to compute such that btext                val    btext1           val       btext2       val should follow in this order along with values. ... View more

I have a data set in the below format(1) and need to make it like ment...

by Calcite | Level 5 in SAS Programming
‎08-29-2014 07:43 AM
‎08-29-2014 07:43 AM
btext btext1 btext2 N (%) dsdf XXX (XX) sdfg XXX (XX) sdsa XXX (XX) asfer XXX (XX) dfdfa XXX (XX) dsdf dfg XXX (XX) sdfg ssa XXX (XX) sdsa ggd XXX (XX) asfer wer XXX (XX) dfdfa dnv XXX (XX) dsdf xvfsdb XXX (XX) sdfg vsadva XXX (XX) sdsa svasdv XXX (XX) asfer Afgs XXX (XX) dfdfa sdvfas XXX (XX) I need to make it  like below -2 N (%) dsdf XXX (XX) dfg XXX (XX) xvfsdb XXX (XX) sdfg XXX (XX) ssa XXX (XX) vsadva XXX (XX) sdsa XXX (XX) ggd XXX (XX) svasdv XXX (XX) ... View more

Re: Not able to convert numeric variable to character

by Calcite | Level 5 in SAS Programming
‎05-28-2014 05:16 AM
‎05-28-2014 05:16 AM
It didnt work. i get same result and in numeric. ... View more

Not able to convert numeric variable to character

by Calcite | Level 5 in SAS Programming
‎05-28-2014 05:06 AM
‎05-28-2014 05:06 AM
     I have a dataset where i have few numeric variables and want to convert them into character. I used put function but it is not getting converted to character. the variable has   TYPE: NUM  LENGTH: 8  FORMAT: BEST12.  INFORMAT: 12. ... View more

how to remove the last 7 letters from the data in a variable

by Calcite | Level 5 in SAS Programming
‎05-06-2014 08:56 AM
‎05-06-2014 08:56 AM
I have a dataset which has a variable in which data is for example tmmd_fdf_er and i want to remove_fdf_er from the data. I dont know whether substr can be used in this case ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Quick links