need help with format

[vicky07]

Hi,

Below is my code. What I am trying to do is apply format to salary and the sal_rng column shows the formated value as numeric, is there anyway that I can change the data type to char in the same SQL step. I mean i want the Sal_rng column as Char.

Proc Format;

  Value sallfmt

low-<1200      =  '$0-<$1200'

1200-<5200    =  '$1200-<$5200'

5200-<9200    =  '$5200-<$9200'

9200-<11200  =  '$9200-<$11200'

11200-<15200 = '$11200-<$15200'

15200-high     =  '$15200+'

;

Run

Data a;

Input salary;

cards;

1230

3456

7353

7252

12098

5690

37812

15789

14780

120

11344

;

Run;

Proc Sql;

Create table sal_amt as

select

Salary,

Salary format = salfmt. as Sal_Rng

from

a

;

Quit

Thanks in advance for your help!

[PGStats · Accepted solution]

Use put()

Proc Sql;

Create table sal_amt as

select

Salary,

put(Salary, salfmt.) as Sal_Rng

from

a

;

Quit;

PG

[vicky07]

PG - It worked. Thanks!!