topic Re: replacing contents of a variable in Statistical Procedures

replacing contents of a variable

ammarhm — Sat, 24 Jan 2015 11:31:52 GMT

A simple question

I have a dataset containing a variable 'Sex', with values 1 and 2 (this is a numerical variable)

I want to change the contents of the variable to Female if Sex=1 and Male if Sex =2.

So the type of the variable will need to be changed too

Any simple way of doing it (without creating a temporary dummy variable?)

Best wishes

mohamed_zaki — Sat, 24 Jan 2015 13:13:23 GMT

It is the way mentioned in sas doc

may i ask what is the problem with this way?

You can do the convert also in PROC SQL

check this old thread

KachiM — Sat, 24 Jan 2015 14:03:42 GMT

Not sure of your question.

Do you want a solution like this?

proc format;

value num2ch 1 = 'Female'

2 = 'Male'

;

run;

data have;

input Sex;

datalines;

;

run;

data want;

set have;

format Sex num2ch.

run;

proc print data = want;

run;

proc contents data = want;

run;

But the type of SEX is still Number in WANT data set.

Reeza — Sat, 24 Jan 2015 18:54:32 GMT

Not really without temporary variables.

You can use a format to change the display, depending on what you're doing, a Class statement in many procs will accomplish this automatically.