topic PROC FORMAT? in SAS Programming

PROC FORMAT?

piplani81 — Mon, 06 Aug 2018 07:12:55 GMT

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;

Re: PROC FORMAT?

error_prone — Mon, 06 Aug 2018 07:18:20 GMT

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.

Re: PROC FORMAT?

RW9 — Mon, 06 Aug 2018 07:34:20 GMT

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

Re: PROC FORMAT?

piplani81 — Mon, 06 Aug 2018 07:53:48 GMT

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;

Re: PROC FORMAT?

Kurt_Bremser — Mon, 06 Aug 2018 07:57:25 GMT

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

Re: PROC FORMAT?

gamotte — Mon, 06 Aug 2018 07:58:27 GMT

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 ?

Re: PROC FORMAT?

RW9 — Mon, 06 Aug 2018 07:59:19 GMT

What error, post the log part.

Re: PROC FORMAT?

ballardw — Mon, 06 Aug 2018 15:06:28 GMT

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;