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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.