need help with format

vicky07 — Thu, 29 Mar 2012 23:35:10 GMT

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

;

Quit

Thanks in advance for your help!

need help with format

PGStats — Thu, 29 Mar 2012 23:44:50 GMT

Use put()

Proc Sql;

Create table sal_amt as

select

Salary,

put(Salary, salfmt.) as Sal_Rng

from

;

Quit;

need help with format

vicky07 — Fri, 30 Mar 2012 00:39:40 GMT

PG - It worked. Thanks!!

topic need help with format in SAS Programming

need help with format

need help with format

need help with format