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
data want;
set have(in=a) have(in=b);
if b then var2=var3;
drop var3;
run;
data want;
set have(in=a) have(in=b);
if b then var2=var3;
drop var3;
run;
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.