09-08-2014 05:00 PM
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
Var 1 Var3
09-08-2014 05:56 PM
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:
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.
Need further help from the community? Please ask a new question.