topic Is there a function to get a SAS member name? in SAS Programming

Is there a function to get a SAS member name?

advoss — Fri, 19 Nov 2010 22:15:27 GMT

I have come up with the following code to get the member names into the observations when I concatenate several members. I've looked, and other than using the open and fetch functions, I haven't found a function that I can use. Each member might have over a million rows of data, and I am not in a position to be able to ask that the member name be added to the table.

Thoughts?

Thank you.

DATA ABC;
SET JORDAN.G1INNETDEDG(IN=G1INNETDEDG)
JORDAN.G2INNETDEDG(IN=G2INNETDEDG)
JORDAN.G3INNETDEDG(IN=G3INNETDEDG)
JORDAN.G4INNETDEDG(IN=G4INNETDEDG);
ARRAY XMEMBERS {*} G1INNETDEDG G2INNETDEDG
G3INNETDEDG G4INNETDEDG ;
length whichmem $32;
WHICHMEM = '??';
DO I=1 to dim(Xmembers) while (whichmem = '??');
IF XMEMBERS{i} THEN WHICHMEM = VNAME(XMEMBERS{i});
END;
drop i;
RUN;

Re: Is there a function to get a SAS member name?

ArtC — Fri, 19 Nov 2010 22:34:51 GMT

The INDSNAME SET statement option might do the trick for you.
[pre]
data two;
set sashelp.shoes sashelp.class indsname=innames;
put innames=;
run;
[/pre]

Re: Is there a function to get a SAS member name?

advoss — Sat, 20 Nov 2010 02:58:21 GMT

Thanks, that's exactly what I need. Now I've just got to get SAS 9.2 installed on my workstation.

I appreciate your quick response.