Hei,
I have a big dataset but i would selct some rows based in a condition.
i have som exeple:
ID org_nr kode v1 v2 v3 v4
1 3 3 x x x
1 3 2 x x x
1 3 2 x x x
1 3 2 x x x
1 3 2 x x x
I have to select
1 3 3
1 3 2
with v1, v2, v3 and v4
What is the prosedure?
Please do not re-open an old question. If you have a new question, open a new post. Include in your post test data - in the form of a datastep - and what the output should look like. Also, be clear as to the logic behind gettnig the output. In your description below you mention nothing of which row to take, 3, 3 appears once, however 3,2 appears multiple times, so which one should it be?
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.