topic Re: Proc freq-9.2 in SAS Programming

Proc freq-9.2

robertrao — Sat, 20 Oct 2012 04:38:05 GMT

Hi Team,

I have a variable with values Y and N . Except that for one observation it is LEV.

I wrote a format as shown below;

value $SER

"Y", "LEV " = "YES"

"N"="NO"

;

RUN;

i apply the format

format variable $ser.

Unfortunately, the LEV stays as LEV and its messing my proc freq!!!!!

I want it to convert to YES

Could anyone help me please???

Thanks

Re: Proc freq-9.2

robertrao — Sat, 20 Oct 2012 04:41:51 GMT

I tried all the options like copy pasting the LEV from the dataset while creating format.

adding spaces to the left and to the right and so on.doesnt work out!!!!

Re: Proc freq-9.2

AncaTilea — Sat, 20 Oct 2012 05:00:33 GMT

Hi.

How about this?

PROC FORMAT;

VALUE $SER

"Y" = "Yes"

"LEV " = "YES"

"N"="NO"

;

QUIT;

Re: Proc freq-9.2

robertrao — Sat, 20 Oct 2012 05:06:39 GMT

Hi,

Thanks for the reply. It doesnt help...

Thanks

Re: Proc freq-9.2

AncaTilea — Sat, 20 Oct 2012 05:15:02 GMT

Sorry, I had capital "YES" and "Yes".

Try this:

PROC FORMAT;

VALUE $SER

"Y" = "Yes"

"LEV " = "Yes"

"N"="NO"

;

QUIT;

DATA temp;

input x $;

cards;

LEV

;

PROC FREQ DATA = temp;

TABLES x;

FORMAT x $ser.;

RUN;

Re: Proc freq-9.2

robertrao — Sat, 20 Oct 2012 05:23:52 GMT

This might work fine . But in My situation I do not understand how LEV is written.

Do youi recommend removing leading and trailing spaces if any///////////????

Could you show me how to acheive that?

Thanks

Re: Proc freq-9.2

AncaTilea — Sat, 20 Oct 2012 05:29:57 GMT

Say, one way would be to use the compress function on your variable:

data temp2;

set temp;

/*remove blanks*/

z = compress(x);

format z $ser.;

run;

proc freq data = temp2;

tables z;

run;

Re: Proc freq-9.2

robertrao — Sat, 20 Oct 2012 05:39:41 GMT

Hey Thanks a ton;

I decided to see what its length is and put so many trailing blanks. and went to see the attributes.

Its displayed as "LEV" in the dataset but when i pull using IN option(filtering on the editor) to see the different types I found it with the full form..

LEVEL. So I put "LEVEL"="YES" in my format immediately and it worked.

Thanks for your time.

Great Help