08-06-2013 03:05 PM
I will pull a spreadsheet each month from an outside source. Their program requires the following: Account#
I had been using the following to show the ln_no however I am getting an Account_ unitialized. This is because the dataset I import in shows Account#.
1. Is there a way to rename the Account# even though sas evaluates this differently and not as a text
2. Also the account# needs to be a character and needs to show leading zeros if it is less than 10. Some of the account numbers show more than 10 (ie 9.4201471E12 or 88089745000)
length ln_no $10;
if Account__ = . then ln_no = ' ';
else ln_no = put(input(Account__,??10.),z10.);
08-06-2013 08:16 PM
You need to reference the variable as a name literal as it is not a valid SAS name. Enclose the variable name with quotation marks followed by an N like so Account#"n.