Altering data structures

[maroulator]

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

[stat_sas · Accepted solution]

data want;

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

if b then var2=var3;

drop var3;

run;

[Patrick]

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.