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
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
Dear Ksharp,
Is the any macro code or macro statement to do the same query.
Thanks,
Regards,
Ashwini
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
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
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
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
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.