REPORTING

[nandanosho]

HI All,

I have a dataset like

STATE_CDOE	L1_NAME	L2_NAME	L3_NAME
RJ	AJMER	PATNA

Now I want to Export this dataset in Excel like below.

Header 1	Header 2
STATE_CODE	RJ
L1_NAME	AJMER
L2_NAME	PATNA
L3_NAME

Can any one of you help me on this .

Thanks In advance.

[Scott_Mitchell]

You could do it with the TRANSPOSE Procedure:

PROC TRANSPOSE DATA=HAVE OUT=WANT (RENAME =(_NAME_  = 'HEADER 1'N COL1 = 'HEADER 2'N));

VAR STATE_CODE--L3_NAME;

RUN;

You could do it with a do loop as follows.

DATA WANT;

  SET HAVE;

  ARRAY C_VARS STATE_CODE--L3_NAME;

  DO I = 1 TO HBOUND(C_VARS);

  'HEADER 1'N = VNAME(C_VARS{I});

  'HEADER 2'N = C_VARS{I};

  OUTPUT;

  END;

  KEEP 'HEADER 1'N 'HEADER 2'N;

RUN;

[nandanosho]

Thnaks a lot.

Its working

[TomKari]

You can also use the DATA | TRANSPOSE task if you want to use the EG point and click functionality.

Tom