data master;
input ID Type $ A B C;
datalines;
1 A 10 100 200
2 B 15 105 300
3 C 20 120 200
4 B 30 125 300
5 A 25 110 400
;
run;
I have a data set like above
Now I need the output like
The condition is for id-1 and type-A, I need to get the value of variable A for id-1 in the Value variable i.e, 10 and for id-2 and type-B I need only need to get the value of variable B for id 2 which is 105. like this let say there are so many IDs and many Types. So, now, someone please help me with a code which is fully automated for any no of IDs and Types.
See my answer in your other thread
https://communities.sas.com/t5/SAS-Programming/SAS-real-time-scenario/m-p/589030
try
data want;
set master;
array vars(*) a b c d ;
do i = 1 to dim(vars);
if lowcase(type)=lowcase(vname(vars(i))) then value=vars(i);
end;
run;
See my answer in your other thread
https://communities.sas.com/t5/SAS-Programming/SAS-real-time-scenario/m-p/589030
You have already have two replies.
I want to know how you have placed the hand-written figure inside this Editor.
Perhaps snapped a photo if it, saved it as a file, then attached by clicking on the Photos icon.
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.