topic Re: Defining dummy variables in SAS in SAS Procedures

Defining dummy variables in SAS

deleted_user — Fri, 01 Apr 2011 09:33:13 GMT

Hi,

I've created dummy categories (outside of SAS) for a single variable. I now need to "define" these categories in SAS and create a new data set that contains them. My thoughts are to create a new format using a PROC FORMAT and VALUE statement, then use a PROC FREQ, TABLES, and FORMAT statement save to a file.

I'm extremely extremely new to SAS and data mining as a whole but based on past assignments would think the two commands would look something like this (values in quotes are what I established as dummy variables):

PROC FORMAT library=library;

VALUE vage

LOW – 17 = ‘0001’
18-19 = ’0010’
20-21=’0100’;

Run;
.........

PROC FREQ data=save.train;
TABLES vage;
FORMAT vage vage.;

Run;

Any assistance would be greatly appreciated.

Regards,

Re: Defining dummy variables in SAS

Ksharp — Fri, 01 Apr 2011 10:29:32 GMT

Your code looks good.

Ksharp

Re: Defining dummy variables in SAS

sss — Fri, 01 Apr 2011 14:12:51 GMT

Hi...

As per you post your code is correct and if you want to create new dataset and want to apply the formatting on them use the code

data new_dataset;
set save.train;
format vage vage.;
run;

Re: Defining dummy variables in SAS

deleted_user — Mon, 04 Apr 2011 09:12:39 GMT

Thanks for your response!