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)
data loans2;
length ln_no $10;
set loans;
if Account__ = . then ln_no = ' ';
else ln_no = put(input(Account__,??10.),z10.);
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.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.