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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: