topic Re: Traditional SAS Programming in SAS Programming

Recode values

Zula — Wed, 17 Oct 2018 02:08:35 GMT

Hi.

I would like to record variable dynamically (I don’t know how many unique values) from:

Blue sky

white snow

etc

value1

value2

value3

etc.

thank you.

Re: Traditional SAS Programming

novinosrin — Wed, 17 Oct 2018 02:02:02 GMT

What's your question?

Re: Traditional SAS Programming

Reeza — Wed, 17 Oct 2018 02:09:42 GMT

A format is probably your best bet. Does the order matter? Do you need to keep consistency between the variables, ie value1 is always Blue Sky.

*get list of unique values;
proc freq data=sashelp.cars noprint;
table origin / out=unique_origin;
run;

*create data set for proc format;
data origin_fmt;
set unique_origin;
start=origin;
label = catt("Value", put(_n_, 8. -l));
fmtname='origin_fmt';
type='C';
run;

*create fomrat;
proc format cntlin=origin_fmt;
run;

*apply format;
data remapped;
set sashelp.cars;
Origin_New = put(origin, $origin_fmt.);
run;

Similar ID to this I suppose:

https://gist.github.com/statgeek/fd94b0b6e78815430c1340e8c19f8644

@Zula wrote:

Hi.

I would like to record variable dynamically (I don’t know how many unique values) from:

Blue sky

white snow

etc

to

value1

value2

value3

etc.

thank you.

Re: Recode values

Reeza — Wed, 17 Oct 2018 02:09:28 GMT

Note that I edited your question title as it was too generic. Please use a more descriptive title in the future.