topic Re: Change data format in SAS Programming

Change data format

akkivsviddu — Fri, 31 Aug 2018 05:58:55 GMT

how we change the format like

gender 0,1

to gender

0=male

1=female

format

akkivsviddu — Fri, 31 Aug 2018 06:06:16 GMT

how we change the format

for gender

0=male

1=female

Re: Change data format

Kurt_Bremser — Fri, 31 Aug 2018 07:20:42 GMT

It's always a very good idea to provide usable test/example data (in a data step with datalines, see my footnotes for converting existing data to such a step, and how to post it).

So I have to guess that you have a numeric variable that only contains ones and zeroes.

Create a value format with proc format:

proc format lib=work;
value gender
  0 = 'male'
  1 = 'female"
;
run;

Then you can use that format, eg by assigning in a data step, or with proc print:

proc print data=have;
format sex gender.;
run;

Re: Change data format

Kurt_Bremser — Fri, 31 Aug 2018 07:19:57 GMT

I also merged the double-post.

Re: Change data format

RW9 — Fri, 31 Aug 2018 07:59:20 GMT

Or if you don't want formats:

data want;
  set have;
  length genderc $20;
  if gender=0 then genderc="male";
  if gender=1 then genderc="female";
run;

Re: format

divekarcm — Fri, 31 Aug 2018 10:54:46 GMT

Hi,

If we take an example of class dataset...

Proc sql;
create table class1 as
Select name,

case when sex='M' then 0 else 1 end as Sex ,

age,height,weight from sashelp.class;
Quit;

And vice versa..