I am in EG 4.2 and forgot how to combine a numeric and character string. Somebody sent me data with a three letter prefix in one column and the number suffix in another. What do i do to recombine II does not seem to work.
If you're using PROC SQL code (and that means if you're writing an expression in the query builder too!!), just a warning that SAS won't do automatic conversion of numeric to character. You'd want a PUT function for that. There's a nice example here (PUT function is about 2/3 down the page):