I have a field Header1 ($20) of the form:
Header 1 |
---|
485 |
1 |
AB27834 |
134 |
A/DD123 |
678423167 |
AB1266 |
12 |
and where the cell is a string where the characters are number I want to convert to the format;
0000000001 where Header1 is 1
0000000134 where Header1 is 134
and so on.
for the cells where the string contains a mix of letters and number I want to leave them as they are.
I tried using this code:
Header1new = put(input(header1,20.),z10.);
This converts the numbers the way I want but it produces loads of errors for the non-numbers. Is there code that allows for this i.e.
if the string header 1 contains at least one character then do leave as is.
Thanks
Almost there;
If anyalpha(Header1) = 0 then Header1new = put(input(header1,20.),z10.);
Almost there;
If anyalpha(Header1) = 0 then Header1new = put(input(header1,20.),z10.);
You need to test if it is a number. Also what about values that look like numbers such as:
1.5
12E5
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.