topic why is the proc print format showing error, for example 3.8 in R. Cody learning SAS by example? in New SAS User

why is the proc print format showing error, for example 3.8 in R. Cody learning SAS by example?

DJ3 — Tue, 28 Sep 2021 17:40:28 GMT

the data step:

data Financial;
infile 'C:\books\learning\Bank.txt';
input Subj $ 1-3 DOB $ 4-13 Gender $ 14 Balance 15-21;
run;

and 3.8 below follows on the data step for reading raw data from fixed columns:

Program 3.8: Demonstrating a FORMAT Statement
title "Listing of Financial";
proc print data=Financial;
format DOB mmddyy10.
Balance dollar11.2;
run;

produce error:

ERROR: You are trying to use the character format $ with the numeric variable Gender in data set
WORK.FINANCIAL
I appreciate your feedback

Re: why is the proc print format showing error, for example 3.8 in R. Cody learning SAS by example?

Reeza — Tue, 28 Sep 2021 17:45:20 GMT

ERROR: You are trying to use the character format $ with the numeric variable Gender in data set

You read in DOB as a character variable, since you included the $ sign in the INPUT statement. This means you cannot apply a date format, because that requires a numeric value. You need to modify your first data step to appropriately read the DOB as a date or you need to convert it first before applying the SAS format.

Re: why is the proc print format showing error, for example 3.8 in R. Cody learning SAS by example?

andreas_lds — Tue, 28 Sep 2021 17:49:23 GMT

@DJ3 wrote:

the data step:

data Financial;
infile 'C:\books\learning\Bank.txt';
input Subj $ 1-3 DOB $ 4-13 Gender $ 14 Balance 15-21;
run;

and 3.8 below follows on the data step for reading raw data from fixed columns:

Program 3.8: Demonstrating a FORMAT Statement
title "Listing of Financial";
proc print data=Financial;
format DOB mmddyy10.
Balance dollar11.2;
run;

produce error:

ERROR: You are trying to use the character format $ with the numeric variable Gender in data set
WORK.FINANCIAL
I appreciate your feedback

Please post the full code and log in readable form.

The code you have posted won't create the error message, because you have no statement assigning a format to the variable "Gender".

Re: why is the proc print format showing error, for example 3.8 in R. Cody learning SAS by example?

DJ3 — Tue, 28 Sep 2021 18:00:59 GMT

I appreciate the feedback from all.

I introduce the DOB format in the input and run the code. it worked fine, no error:

data financial;
infile 'V:\Examples\learning\Bank.txt';
input subj $ 1 - 3
@4 DOB mmddyy10.
Gender $ 14
Balance 15 -21;
run;
proc print data=Financial;
format DOB mmddyy10.
Balance dollar11.2;
run;

this worked.

Re: why is the proc print format showing error, for example 3.8 in R. Cody learning SAS by example?

Reeza — Tue, 28 Sep 2021 18:02:40 GMT

data Financial;
infile 'C:\books\learning\Bank.txt';
informat DOB mmddyy10.;
input Subj $ 1-3 DOB  4-13 Gender $ 14 Balance 15-21;
run;

Add an INFORMAT statement for DOB that specifies how it is displayed in the text file. This tells SAS how the date should be read in. SAS will then read in the date and convert it to a SAS date, which is numeric and represents the number of day from January 1, 1960.
Remove the $ in the INPUT statement by DOB to tell SAS to read it in as numeric value, not character

Then try printing it and applying a format.

@DJ3 wrote:

the data step:

data Financial;
infile 'C:\books\learning\Bank.txt';
input Subj $ 1-3 DOB $ 4-13 Gender $ 14 Balance 15-21;
run;

and 3.8 below follows on the data step for reading raw data from fixed columns:

Program 3.8: Demonstrating a FORMAT Statement
title "Listing of Financial";
proc print data=Financial;
format DOB mmddyy10.
Balance dollar11.2;
run;

produce error:

ERROR: You are trying to use the character format $ with the numeric variable Gender in data set
WORK.FINANCIAL
I appreciate your feedback

Re: why is the proc print format showing error, for example 3.8 in R. Cody learning SAS by example?

Reeza — Tue, 28 Sep 2021 18:03:30 GMT

Please mark the question as answered as you know have a solution.