Altering data structures

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 120
Accepted Solution

Altering data structures

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


Accepted Solutions
Solution
‎09-08-2014 05:13 PM
Trusted Advisor
Posts: 1,203

Re: Altering data structures

data want;

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

if b then var2=var3;

drop var3;

run;

View solution in original post


All Replies
Solution
‎09-08-2014 05:13 PM
Trusted Advisor
Posts: 1,203

Re: Altering data structures

data want;

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

if b then var2=var3;

drop var3;

run;

Respected Advisor
Posts: 3,837

Re: Altering data structures

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:

InstrumentNamePriceToPublicCusipCouponDates
Bond99.104142912810QB705/15/2039
Bond103.154521912810PX1005/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.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 161 views
  • 1 like
  • 3 in conversation