PROC FORMAT?

[piplani81]

Hello All,

I am not able to create user define format can you pls check below 2 code and let me know where i am doing mistake.

Proc format;
value typefmt
'PA'='Passenger'
'CA'='Car';
run;

Proc print Data =S.Car;
Format Vehicle_type $typefmt.;
run;

and 

Proc format;
Value Newgrp low-175='<175'
175-<200='175-200'
200-High= '>200';
run;
proc Freq data =S.Car;
Format Length Newgrp.;
Table Length;
run;

[error_prone]

If you want to create a char-format, the name must begin with $.
I can't say anything about the second problem, because you failed to explain what the problem is.

[piplani81]

I have a car sales data set in which one variable is Vehicle_type ( Passenger and Car) i would like to show  

'PA'='Passenger'
'CA'='Car'

but after run the following code neither i am getting any error nor format created. Pls help.

Proc format;
value $typefmt
'PA'='Passenger'
'CA'='Car';
run;

Proc print Data =S.Car;
Format Vehicle_type $typefmt.;
run;

[Kurt_Bremser]

When you have a problem, ALWAYS post the log from your code. Use the {i} button for posting logs.

[gamotte]

Works for me :

libname S "c:\temp";

data S.car;
input Vehicle_type $;
cards;
PA
CA
;
run;

Proc format;
value $typefmt
'PA'='Passenger'
'CA'='Car';
run;

Proc print Data =S.Car;
Format Vehicle_type $typefmt.;
run;

What does the log indicate ?

[RW9]

What error, post the log part.

[RW9]

Please formulate the question which exact descriptions of hat the issue is, what logs say, test data/required output etc.  In the first instance typefmt is missing a $, in the second?

http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a000063536.htm

[ballardw]

Proc format;
Value Newgrp 
low-175='<175'
175-<200='175-200'
200-High= '>200';
run;

has an issue with 175 being in two groups (and not a multilabel format). From your label text I suspect that you might actually want:

Proc format;
Value Newgrp 
low -< 175='<175'
175 -< 200='175-200'
200 -   High= '>200';
run;