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.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and save with the early bird rate—just $795!
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.