concat a numeric column into a char with a leading '0'

cnilsen — Fri, 06 Oct 2017 14:57:29 GMT

I'm processing a table with DI Studio (4.901)

I have a column that is numeric (best6.) input.. I need to convert the column to character (char40).. (simple enough)

BUT, if the numeric value of the input column is less than/equal to 99.... I need to add a zero to the leading side of the value in it's character result. I have to use this result character column to join with another table.. so a value of 99 needs to be '099'

I tried to use a case statement such as :

case

when <= 99

then cat('0', numeric_column)

else numeric_column

end

when I try to validate the code I get this error:

71 proc sql;
72 validate
73 select case
74 when <= 99
__
22
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant,
a missing value, BTRIM, INPUT, PUT, SUBSTRING, USER.

75 then cat (0, channel_code)
76 else channel_code
77 end from work.etls_EFITable;

I think I'm just overlooking something simple in my logic..

Regards.

Re: concat a numeric column into a char with a leading '0'

PaigeMiller — Fri, 06 Oct 2017 15:00:09 GMT

You want to use the Z format

something like

charvar=put(numvar,z3.);

Re: concat a numeric column into a char with a leading '0'

cnilsen — Fri, 06 Oct 2017 15:11:45 GMT

wow.. that was incredibly quick and painless.

that tried and worked excellent. I'm looking up that Z format to learn more about it.

Thanks for the help!

topic concat a numeric column into a char with a leading '0' in SAS Data Management

concat a numeric column into a char with a leading '0'

Re: concat a numeric column into a char with a leading '0'

Re: concat a numeric column into a char with a leading '0'