topic Re: REPORTING in SAS Enterprise Guide

REPORTING

nandanosho — Wed, 04 Jun 2014 04:45:23 GMT

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.

Can any one of you help me on this .

Thanks In advance.

Scott_Mitchell — Wed, 04 Jun 2014 05:33:34 GMT

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 — Wed, 04 Jun 2014 09:46:38 GMT

Thnaks a lot.

Its working

TomKari — Wed, 04 Jun 2014 12:09:40 GMT

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

Tom