topic Removing asterick from the field in SAS Procedures

Removing asterick from the field

raveena — Fri, 16 Sep 2011 20:24:23 GMT

Hi ,

I have a field name called provno,

PROVNO

123456789

*67890077

*67890642

879645700

098754376

*90875535

Some of the provno starts with *, i need to eliminate those * from the provno.

Output should be ,

123456789

67890077

67890642

879645700

098754376

90875535

Thanks

FriedEgg — Fri, 16 Sep 2011 20:47:04 GMT

compress(provno,'*');

raveena — Fri, 16 Sep 2011 21:52:54 GMT

In case if i want to remove whole provno that starts with * means ?

Please let me know.

Thanks

raveena — Fri, 16 Sep 2011 22:04:15 GMT

Yes i got it.. i have used not equal function as below,

proc sql;

select provno from test

where substr(provno,1,1) <> '*';

quit;

Ksharp — Sat, 17 Sep 2011 03:36:19 GMT

data x;
input PROVNO $10.;
cards;
123456789
*67890077
*67890642
879645700
;
run;
proc sql;
 select *
  from x
   where provno net '*';
quit;

Ksharp