topic How to make a new dataset which will be having only distict values of required variables from a dataset? in SAS Programming

How to make a new dataset which will be having only distict values of required variables from a dataset?

bonzybuddy — Fri, 26 Apr 2013 18:29:58 GMT

How to make a new dataset which will be having only distict values of required variables from a dataset? (using proc sql, if not possible then datastep.)

Re: %do loop inside proc sql

PaigeMiller — Fri, 26 Apr 2013 18:40:05 GMT

You will get the word "select" six times, the word "from" six times and the word "where" six times, plus of course the text in between six times.

That doesn't sound like what you want.

&sometext is not defined

None of this will work unless it is inside a macro, I hope you realize that

Your variables will be named var1_var, var2_var, ... (is that really what you want?) and each will be identical to the others because each time you are selecting distinct var1 from the same data set.

Not sure exactly what you want to obtain in this example ... in fact, its not even clear why you need a macro here unless the number 6 can change from run to run.

So basically, I don't understand what you are trying to do, and I think a bit of a description would be necessary before we could advise further.

Re: %do loop inside proc sql

bonzybuddy — Fri, 26 Apr 2013 18:48:10 GMT

Yes all this things are inside a macro. I just gave a rough example.

Bsically I want to create a dataset1 to which I want to add variables with unique values from another dataset2 with "WHERE" conditing. The WHERE condition itself gets values from a macro variable.

Re: %do loop inside proc sql

PaigeMiller — Fri, 26 Apr 2013 18:51:09 GMT

Perhaps you could write out a small example without macros to show me what you want to achieve. Because as stated, it seems like you are using the same var1 and dataset1 in each loop through the macro, which makes no sense, you will get the same results in each column.

Re: %do loop inside proc sql

bonzybuddy — Fri, 26 Apr 2013 18:58:44 GMT

OK. Explaining you otherway,

How to make a new dataset which will be having only distict values of required variables from a dataset? (using proc sql, if not possible then datastep.)

I hope this makes some sense. If not I will write steps;.

Re: %do loop inside proc sql

PaigeMiller — Fri, 26 Apr 2013 19:08:40 GMT

As far as I know, you'd have to create a data set separately for each required variable.

SQL doesn't really work if var1 has 12 distinct values and var2 has 5 distinct values, unless you want (possibly) 60 unique combinations of var1 and var2

Re: %do loop inside proc sql

bonzybuddy — Fri, 26 Apr 2013 19:12:32 GMT

May be if someone can comeup with something or using datastep.

Anyways, Thanks man.

Re: %do loop inside proc sql

Reeza — Fri, 26 Apr 2013 19:31:04 GMT

Post some example with data.

Re: How to make a new dataset which will be having only distict values of required variables from a dataset?

ChandraReddy — Fri, 26 Apr 2013 21:26:33 GMT

To get distinct varibale values, you may try the simple code:

Proc sql;

select distinct var1,var2,var3,var4,var5,var6

from dset1

where condt1;

quit;