Removing asterick from the field

[raveena]

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]

compress(provno,'*');

[raveena]

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

Please let me know.

Thanks

[raveena]

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 · Accepted solution]

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

Ksharp