topic Re: a question on tranwrd in SAS Procedures

a question on tranwrd

aarony — Fri, 18 Apr 2014 01:56:42 GMT

i have ran a code:

data us99;

set us13;

annualreportdate=tranwrd(annualreportdate,'Dec','');

run;

for some strange reason, after i get rid of Dec, I get a space between my year ie: (space)2013

how can i remove that space so that the ones that i removed Dec aligns with other year observations?

thank you!

Re: a question on tranwrd

Reeza — Fri, 18 Apr 2014 02:41:45 GMT

I think there's better ways to do what you want to do...but you need to provide more details.

You can use compress to remove spaces to solve your immediate problem.

Re: a question on tranwrd

Jagadishkatam — Fri, 18 Apr 2014 06:26:25 GMT

In case you would like to remove the character data from the variable, you can try the below code

data have;

annualreportdate='01Dec2013';

annualreportdate=compress(annualreportdate,,'kd');

run;

Thanks,

Jag

Re: a question on tranwrd

Peter_C — Fri, 18 Apr 2014 07:13:10 GMT





annualreportdate=tranwrd(annualreportdate,'Dec','');


for some strange reason, after i get rid of Dec, I get a space between my year ie: (space)2
how can i remove that space

AnnualReportDate = tranwrd( annualreportdate, 'Dec2', '2' ) ;

You might need to repeat it for the 1900s if your reports go that far back (but that seems less likely)

Re: a question on tranwrd

Ksharp — Fri, 18 Apr 2014 09:56:16 GMT

Use another function.

data us99;
annualreportdate='Dec2014';
annualreport=prxchange('s/Dec//',-1,annualreportdate);
run;

Xia Keshan

Re: a question on tranwrd

data_null__ — Fri, 18 Apr 2014 11:32:17 GMT

To replace to null string, length 0, you need "new" TRANSTRN function and to specify a 0 length string you need a function like TRIMN.

data _null_; 
   x = '18DEC2013'; 
   a = tranwrd(x,'DEC',trimn(' '));
   b = tranSTRN(x,'DEC',trimn(' '));
   put 'NOTE: ' (_all_)(=);
   run; 

NOTE: x=18DEC2013 a=18 2013 b=182013