topic Re: Altering data structures in SAS Programming

Altering data structures

maroulator — Mon, 08 Sep 2014 21:00:32 GMT

I have the following data/dataset:

Var 1 Var2 Var3

InstrumentName Bond Bond

PriceToPublic 99.1041420 103.154521

Cusip 912810QB7 912810PX10

CouponDates 05/15/2039 05/15/2038

And I want to make it look like the data below; the new datastructure should be all contained in one dataset. Does anyone have any idea about how to accomplish this?

Var 1 Var2

InstrumentName Bond

PriceToPublic 99.1041420

Cusip 912810QB7

CouponDates 05/15/2039

Var 1 Var3

InstrumentName Bond

PriceToPublic 103.154521

Cusip 912810PX10

CouponDates 05/15/2038

Re: Altering data structures

stat_sas — Mon, 08 Sep 2014 21:13:08 GMT

data want;

set have(in=a) have(in=b);

if b then var2=var3;

drop var3;

run;

Re: Altering data structures

Patrick — Mon, 08 Sep 2014 21:56:48 GMT

I believe if you want to use your data in SAS also for calculations then things would be much easier for you if structuring your data as below:

InstrumentName	PriceToPublic	Cusip	CouponDates
Bond	99.104142	912810QB7	05/15/2039
Bond	103.154521	912810PX10	05/15/2038

Once you have your data in such a table structure you then can use Proc Report or the like to create reports in a structure as shown in your example target structure.