How do I extract leading non zero digits?
For example for .000212 I want to extract leading digit which is 2. and for 123.933 I want to extract leading digit which is 1.
How do I do this? plz help
How about:
data have;
input nn;
cards;
.00212
123.933
;
data want;
set have;
m=substr(compress(nn,'123456789','k'),1,1);
proc print;
run;
Obs nn m
1 0.002 2
2 123.933 1
Linlin
How about:
data have;
input nn;
cards;
.00212
123.933
;
data want;
set have;
m=substr(compress(nn,'123456789','k'),1,1);
proc print;
run;
Obs nn m
1 0.002 2
2 123.933 1
Linlin
Base on LinLin's method, another function choice would be first(), to save some typing:
data want;
set have;
m=first(compress(nn,'123456789','k'));
run;
Haikuo
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.