topic Re: format command in SAS Procedures

format command

ahuja — Tue, 09 Jun 2015 18:11:15 GMT

Hi,

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

set CDRIVE.BANK_DATA2."

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;

Kindly help.!

Thanks in advance.

Steelers_In_DC — Tue, 09 Jun 2015 18:19:18 GMT

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.

data have;

infile cards dsd;

input age $;

cards;

;

run;

data want(rename=(age_2=age));

set have;

age_2 = input(age,8.);

drop age;

run;

ahuja — Tue, 09 Jun 2015 18:37:18 GMT

Hi Mark,

Thanks for your help, You are a savior i got it right.

Thanks.