How can I format $306.16 where input data is 0030616??

[GBL__]

Hello,

I am struggling to format numeric data that is always length of 7 and contains no decimals or commas, WITH decimals.

i.e.

0030316 --> 303.16

1836960 --> 18369.60

Obviously, this is easy and I am an idiot.

Thank you for your help!!!

[PaigeMiller]

Numeric data never has leading zeros, so it is either character, or formatted somehow.

Please show us the PROC CONTENTS output for this variable.

[GBL__]

Apologies for not being clear, I am reading this data in from an external text file like this:

"CUSTOMER NAME","ACCOUNT NUMBER","LOAN NUMBER","LOAN DATE","MATURITY DATE","TERM","PAYMENT AMOUNT","ODD PAYMENT AMOUNT","TOTAL OF PAYMENTS" 
"******, ****","15028","28","010919","011724","060","0030616","0030616","1836960"

[PaigeMiller]

But I specifically asked for the PROC CONTENTS output of your SAS data set, showing the results for this variable of interest.

Your presenting the external text file does not move us forward to understanding how to obtain the desired result.

[GBL__]

Variables in Creation Order
#	Variable	Type	Len
1	customer_name	Char	25
2	account_number	Char	8
3	loan_number	Char	5
4	loan_date	Num	8
5	maturity_date	Num	8
6	term	Num	8
7	payment_amount	Num	7
8	odd_payment_amount	Num	7
9	total_of_payments	Num	7

I told you it was a number with a length of 7, so here is also a picture that says it is a number with a length of 7

[PaigeMiller]

Edit: Ignore this

Please try PROC CONTENTS with the DETAILS option

PROC CONTENTS DATA=yourdatasetname DETAILS;

RUN:

[PaigeMiller]

So it is numeric with length 7, so it can't have leading zeros.

To get the output the way you want it, use 

format payment_amount dollar16.2;

[GBL__]

When I format as dollar16.2 I get $30,616.00

[PaigeMiller]

---

@GBL__ wrote:

When I format as dollar16.2 I get $30,616.00

---

You need to divide by 100 first.

[GBL__ · Accepted solution]

I used

INPUT
		customer_name					$
		account_number					$
		loan_number					$
		loan_date					:	anydtdte6.
		maturity_date					:	anydtdte6.
		term
		payment_amount					:	best7.2
		odd_payment_amount				:	best7.2
		total_of_payments				:	best7.2 ;

 And then formatted it as Dollarw.d

[Tom]

The way to have SAS put in an implied decimal point when converting text to numbers is to specify the number of decimal places in the INFORMAT.  So if the field is always 7 characters wide and you want to interpret the last 2 as being after the decimal point then use the 7.2 informat.  

I think you confused people by using the word FORMAT in your question. FORMATs are something you attach to a value that you already have in a SAS variable.  INFORMATs are what determine how to interpret text and convert it to values.