topic macro code for keep and drop statement in datastep in SAS Programming

macro code for keep and drop statement in datastep

Ashwini — Thu, 19 Jan 2012 05:37:57 GMT

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

macro code for keep and drop statement in datastep

Ksharp — Thu, 19 Jan 2012 06:18:47 GMT

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

macro code for keep and drop statement in datastep

Ashwini — Thu, 19 Jan 2012 08:59:33 GMT

Dear Ksharp,

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

Thanks,

Regards,

Ashwini

macro code for keep and drop statement in datastep

Ksharp — Thu, 19 Jan 2012 09:50:39 GMT

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

macro code for keep and drop statement in datastep

Ashwini — Thu, 19 Jan 2012 10:52:59 GMT

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

macro code for keep and drop statement in datastep

Ksharp — Fri, 20 Jan 2012 03:32:36 GMT

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

macro code for keep and drop statement in datastep

Ashwini — Fri, 20 Jan 2012 10:51:07 GMT

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

macro code for keep and drop statement in datastep

Ksharp — Fri, 20 Jan 2012 12:01:28 GMT

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