DATA Step, Macro, Functions and more

macro code for keep and drop statement in datastep

Reply
Frequent Contributor
Posts: 76

macro code for keep and drop statement in datastep

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

Super User
Posts: 9,691

macro code for keep and drop statement in datastep

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

Frequent Contributor
Posts: 76

macro code for keep and drop statement in datastep

Dear Ksharp,

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

Thanks,

Regards,

Ashwini

Super User
Posts: 9,691

macro code for keep and drop statement in datastep

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

Frequent Contributor
Posts: 76

macro code for keep and drop statement in datastep

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

Super User
Posts: 9,691

macro code for keep and drop statement in datastep

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

Frequent Contributor
Posts: 76

macro code for keep and drop statement in datastep

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

Super User
Posts: 9,691

macro code for keep and drop statement in datastep

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

Ask a Question
Discussion stats
  • 7 replies
  • 247 views
  • 0 likes
  • 2 in conversation