SushilKumar Tracker

Re: How to convert 1 as one and 2 as two without Proc format

SushilKumar — Mon, 02 Jun 2014 11:16:20 GMT

Re: How to convert 1 as one and 2 as two without Proc format

SushilKumar — Thu, 15 May 2014 05:09:39 GMT

jairedp you can easily convert this

X	1	First
Y	2	Second
Z	3	Third
A	4	Fourth
B	5	Fifth

If you have 22 ,56 99 etc how will display that in words like twentytwo, fiftysix,lke that

Re: How to convert 1 as one and 2 as two without Proc format

SushilKumar — Wed, 19 Feb 2014 06:46:49 GMT

Thanks to every one,

Could anyone help me is it possible to convert one as First and 2 as Second and goes on

X	1	First
Y	2	Second
Z	3	Third
A	4	Fourth
B	5	Fifth

How to convert 1 as one and 2 as two without Proc format

SushilKumar — Thu, 13 Feb 2014 10:10:49 GMT

Hi,

Could any one help me how to convert Numeric Value 1 as one and 2 as two and 3 as three............ etc without using Proc Format

for egi do have dataset like,

X	1
Y	2
Z	3
A	4
B	5

and i want dataset to be like below without using Proc Format

X	1	One
Y	2	Two
Z	3	Three
A	4	Four
B	5	Five

and also is it possible to convert 1as First and 2 as Second and 3 as Third etc without using Proc Format

Re: How to Use Proc Sort Using Macros

SushilKumar — Tue, 20 Aug 2013 09:48:41 GMT

thank you

Re: How to Use Proc Sort Using Macros

SushilKumar — Tue, 20 Aug 2013 07:17:50 GMT

Thank you murray

Could you explain me how it works, because i new to sas macros

How to Use Proc Sort Using Macros

SushilKumar — Mon, 19 Aug 2013 08:44:43 GMT

Hi ,

Could any one help me Out that how to use Proc sort in macros.

Re: How to use index function and tranwrd function

SushilKumar — Tue, 26 Mar 2013 13:11:02 GMT

yes thank you i got that

Need Assistance in Array

SushilKumar — Tue, 26 Mar 2013 08:02:43 GMT

Could any One Help About Array

Why it is Used and How it can be used ?

I Want to Learn array completely how many it cab be used

How to use index function and tranwrd function

SushilKumar — Tue, 26 Mar 2013 07:38:08 GMT

I Created dataset as

data sushil.tsk1;

input subjid$ InvestigatorName$5-25;

datalines;

1001 Ramachandiran

1002 Umabadi

1003 Seshadi

1004 Mandadi

1005 Kodumudivenu

1006 Vadivelu

1007 SevadiKesavamoorhty

1008 Semmadirajan

run;

I wrote the code, to find the position of "di" in Investigator variable and replace the "di" with Change but its not working Could any one help me.

data sushil.task1;

set sushil.tsk1;

Inv_Pos = index(InvestigatorName,'id');

Inv_Change = Tranwrd(InvestigatorName,'id','CHANGE');

run;

Using this Code Required Output is not coming Could any one help me

Re: How To Seprate Character Variable and Numeric Variable

SushilKumar — Fri, 22 Mar 2013 07:53:27 GMT

Could You write the Code

Re: How to display the old Obervation Number in the dataset when dataset is sorted

SushilKumar — Fri, 22 Mar 2013 07:52:26 GMT

Could You write the Code How to assgin it.

How to display the old Obervation Number in the dataset when dataset is sorted

SushilKumar — Thu, 21 Mar 2013 07:14:27 GMT

I Have Created a Dataset as

RF101	101	10001	ALPHA	XABC	RF10110110001
RF101	101	10001	BETA	XABC	RF10110110001
RF101	101	10001	GAMMA	RFAB	RF10110110001
RF101	101	10002	GAMMA	GAG	RF10110110002
RF101	101	10002	ZURO	MAM	RF10110110002
RF101	101	10002	GAAFAZ	GAG	RF10110110002
RF101	101	10002	XELFO	MAM	RF10110110002

And i Sorted the dataset as

RF101	101	10001	GAMMA	RFAB	RF10110110001
RF101	101	10001	ALPHA	XABC	RF10110110001
RF101	101	10001	BETA	XABC	RF10110110001
RF101	101	10002	GAAFAZ	GAG	RF10110110002
RF101	101	10002	GAMMA	GAG	RF10110110002
RF101	101	10002	XELFO	MAM	RF10110110002
RF101	101	10002	ZURO	MAM	RF10110110002

I Want the Obersvation Number of the dataset (which is not sorted) in the Output dataset in a Variable called Result

How To Seprate Character Variable and Numeric Variable

SushilKumar — Thu, 21 Mar 2013 06:50:16 GMT

I Created a Dataset In a Character Variable it contains character and Numeric Value,

I want to Split character and Numeric Value

I Have a dataset which is subject and result are character variable

subject	Result
1001	20
1002	>50
1003	Positive
1004	30.5

I Want the Dataset to be

subject	Result	Numeric	Character
1001	20	20
1002	>50		>50
1003	Positive		Positive
1004	30.5	30.5

Could Any one Help Me