comp.soft-sys.sas - The SAS statistics package.
Hello, =20 I'm creating a excel file using ODS and I am trying to maintain leading zeros in one of the fields. I created it as a character field in SAS but in excel it reads it as numeric and cuts off the leading zeros. =20 Any suggestions? =20 Thanks in advance, =20 Jessica
I was hoping that someone may be able to help me with this seemingly simple exercise. I have 2 numeric variables - county (values 1-88) and station (values 1-30). I want to create a new variable called check_station by concatenating the county and station. I've used the put function to convert the fields to character variables and I used the compress and concatenate functions to get what I wanted - almost. What I need help with is the following: When station is < 10, I want a leading zero (0) added. Example: County=33; station=5 Current result:335 Desired result:3305 Any help would be greatly appreciated. tonk