topic Re: SAS real-time scenario in SAS Programming

SAS real-time scenario

Siddhu — Mon, 16 Sep 2019 13:02:00 GMT

Please go through the pdf file for full details.

Re: SAS real-time scenario

PeterClemmensen — Mon, 16 Sep 2019 13:11:11 GMT

@Siddhu welcome to the SAS Community 🙂 Next time you post a question, please do not specify your request in an image file. Describe your problem and provide usable code. Makes it much easier to help you.

Here you go though

data have;
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
;

data want;
    set have;
    array _{*} A--C;
    do i=1 to dim(_);
        if vname(_[i])=type then value=_[i];
    end;
    keep id type value;
run;

Re: SAS real-time scenario

Jagadishkatam — Mon, 16 Sep 2019 13:11:23 GMT

Please try the below code

data have;
input id type$ a b c d;
cards;
1 A 1 2 3 4
2 B 1 2 3 4
3 C 1 2 3 4
;

data want;
set have;
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: SAS real-time scenario

Siddhu — Tue, 17 Sep 2019 02:04:54 GMT

Can you please explain me about the background work of "vname" in SAS arrays. If possible, please try to explain it by a video or post a link as I couldn't get it.

Re: SAS real-time scenario

PeterClemmensen — Tue, 17 Sep 2019 06:21:44 GMT

Whenever you encounter a function in SAS you're unsure of, do consult the documentation.

in this case

SAS Documentation: VNAME Function

Re: SAS real-time scenario

Ksharp — Tue, 17 Sep 2019 11:54:36 GMT

Why not use VVALUEX() ?

data want2;
 set have;
 value=vvaluex(type);
run;

Re: SAS real-time scenario

PeterClemmensen — Tue, 17 Sep 2019 11:56:03 GMT

@Ksharp tbh, didn't even cross my mind 🙂 Kudos!