topic Re: Extracting desired values in a dataset in SAS Programming

Extracting desired values in a dataset

Siddhu — Mon, 16 Sep 2019 13:28:44 GMT

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.

Re: Extracting desired values in a dataset

Jagadishkatam — Mon, 16 Sep 2019 13:29:43 GMT

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;

Re: Extracting desired values in a dataset

PeterClemmensen — Mon, 16 Sep 2019 13:33:20 GMT

See my answer in your other thread

https://communities.sas.com/t5/SAS-Programming/SAS-real-time-scenario/m-p/589030

Re: Extracting desired values in a dataset

KachiM — Mon, 16 Sep 2019 14:53:37 GMT

@Siddhu

You have already have two replies.

I want to know how you have placed the hand-written figure inside this Editor.

Re: Extracting desired values in a dataset

hashman — Mon, 16 Sep 2019 16:10:51 GMT

@KachiM:

Perhaps snapped a photo if it, saved it as a file, then attached by clicking on the Photos icon.

Re: Extracting desired values in a dataset

KachiM — Mon, 16 Sep 2019 16:18:19 GMT

@hashman

Thank you.