macro code for keep and drop statement in datastep

[Ashwini]

There are 100 variable in a dataset .I want to select  70 variable with out change any change in dataset by using macro code .
Kindly help me

Regards
Ashwini

[Ksharp]

You can use colon operation to select some variables started with the same characters.

data want;

set have(keep= abc: );

run;

If your logic is more complicated then use dictionary table columns and LIKE operation to push the variables you need into a macro variable.

Ksharp

[Ashwini]

Dear Ksharp,

Is the any macro code or macro statement to do the same query.

Thanks,

Regards,

Ashwini

[Ksharp]

What does your dataset look like ?

and what type of variables do you want to pull out?

You should post an example, then someone will help you .

Ksharp

[Ashwini]

Dear Ksharp,

My dataset contain 100 variable .It is contain both character and numeric variable.So I have to keep 70 variable out of 100 variable.Is there any way to create a dataset using macro code with out using keep and drop statement.

Regards,

Ashwini

[Ksharp]

Hi.

I think Answer is Yes.

Could you post an example?  Like

I have a table look like:

name     sex    age    weight     height

Patrick   M       25       65            121.2

..............

I want to pull out sex and height.

You 'd better to illustrate the logic of pulling out . Like

I want to pull out 2th,5th variables.

Ksharp

[Ashwini]

Dear Ksharp,

I have an data set contain colomn A , B , C, D, E , F , G , H...........Z The required data set is contain only 3 colomn like A,C,G,K ,O, P  .Pls write code using macro code .

Regards,

Ashwini

[Ksharp]

I don't understand what your logic is when you pull out some variables?

Why you choose

A,C,G,K ,O, P

not choose

B,D,E,F   ?

Ksharp