06-09-2015 02:11 PM
On running format command i am getting an error "
ERROR: You are trying to use the numeric format AGE_FMT with the character variable Age in data
Below is the code i am trying to execute:
title 'Decision by Age';
proc freq data=&hmda_file order=freq;
format age age_fmt. action status_fmt.; table age * action / missing nocum nopercent nocol; run;
Thanks in advance.
06-09-2015 02:19 PM
You provide the answer in your question.
You are using a numeric format (age_fmt.) for a character variable (age).
You can either remove age age_fmt. from the format command or before this step change the character age to numeric age.
infile cards dsd;
input age $;
age_2 = input(age,8.);