I have the following code which I apply to the attached .csv file; my question/problem pertains to the variable Description found in the NCDebt2 dataset. Is there a way to eliminate the blanks found within (ie not leading and trailing blanks) the values of the Description variable? data WORK.NCDebt;      infile '/fmacdata/utility/fin/KBenchmarks/SAS Data/Debt.csv' dsd lrecl=40000 firstobs=3; informat InstrumentName $15.; informat PriceToPublic 10.8; informat Cusip $15.; informat CouponDates mmddyy10.; informat ValuationDate yymmdd.; informat AccruedDayCount $10.; informat FullPrice 10.8; informat InterestFrequency 5.; informat Notional 12.; informat MaturityDate mmddyy10.; informat ID $10.; informat FaceValues 8.; informat PaymentDayCount $10.; informat FlatPrice 10.8; informat Description $80.; informat Comments $30.; informat MarketCleanPrice 10.8; informat SettlementDate yymmdd.; informat Name $20.; informat Category $40.; informat PaymentDates mmddyy10.; informat AnnualCouponRates 6.4; informat OriginationDate mmddyy10.; informat FirstCpnDt mmddyy10.; informat Issuer $30.; informat CouponType $30.; format PriceToPublic FullPrice 10.8        CouponDates MaturityDate ValuationDate PaymentDates OriginationDate        SettlementDate FirstCpnDt yymmddn8.; input InstrumentName $ PriceToPublic Cusip $ CouponDates ValuationDate       AccruedDayCount $ FullPrice InterestFrequency Notional MaturityDate       ID $ FaceValues PaymentDayCount $ FlatPrice Description $ Comments $       MarketCleanPrice  SettlementDate Name $ Category $ PaymentDates        AnnualCouponRates OriginationDate FirstCpnDt Issuer $ CouponType $; ID=Cusip; Name=Cusip; Y=round(((MaturityDate-OriginationDate)/360),0.1); X=MaturityDate; if index(Issuer,'TREASURY') then do;    if CouponType='FIXED' then Category='TreasuryDebt.NonCallable.FixedRate';    else if CouponType ne 'FIXED' then Category='TreasuryDebt.NonCallable.ZeroCoupon'; end; else do;    if CouponType='FIXED' then Category='AgencyDebt.NonCallable.FixedRate';    else if CouponType ne 'FIXED' then Category='AgencyDebt.NonCallable.ZeroCoupon'; end; run; data NCDebt2;   retain InstrumentName PriceToPublic Cusip CouponDates ValuationDate          AccruedDayCount DiscountSource FullPrice UnderWriterDelivery          InterestFrequency Notional MaturityDate ID FaceValues          PaymentDayCount CouponAdjusting FlatPrice Description Comments          MarketCleanPrice BusinessDayAdjust CouponEntry SettlementDate Name Category          PaymentDates AnnualCouponRates UnderwriterDiscount DisableLegacyMeasures          OriginationDate OAS FirstCpnDt;          DiscountSource='OIS';          UnderWriterDelivery=-1;          CouponAdjusting='false';          BusinessDayAdjust='Following';          CouponEntry='Manual';   UnderwriterDiscount=0.0;          DisableLegacyMeasures='false';          OAS=0.0;          format UnderwriterDiscount 3.1;          set NCDebt;          Y=strip(Y);          AnnualCouponRates=strip(AnnualCouponRates);          Z=put(X,mmddyy10.);          if index(Issuer,'TREASURY') then            Description='USTreas  '||AnnualCouponRates||'% '||Y||' YR '||Z;          else if index(Issuer,'VALLEY') then            Description='TVA  '||AnnualCouponRates||'% '||Y||' YR '||Z;          else if index(Issuer,'FANNIE') then            Description='FNMA  '||AnnualCouponRates||'% '||Y||' YR '||Z;          AnnualCouponRates=AnnualCouponRates/100; run; ... View more

I have been working with the following code which is applied to the attached NCDebt.csv dataset; I am only loading one record into SAS. The code does exactly what I need it to do up until the macro definition; the macro definition represents my initial (incomplete) attempt at what it is that I am trying to achieve. What I am trying to achieve is to make the array in the NCDebt3 dataset look exactly like the one in the attached "Desired Array.csv" file. Because of the specifications of my business problem, I need to "back-fill" the array in NCDebt3; this means that in order for me to get the array that I want (again see attached "Desired Array.csv" file), I need to start with the value in date60 and work my way down to date1. Any insight would be extremely appreciated. Many thanks in advance. data WORK.NCDebt;      infile '/FilePath/NCDebt.csv' dsd lrecl=40000 firstobs=3 obs=3; informat InstrumentName $15.; informat PriceToPublic 10.8; informat Cusip $15.; informat CouponDates mmddyy10.; informat ValuationDate yymmdd.; informat AccruedDayCount $10.; informat FullPrice 10.8; informat InterestFrequency 5.; informat Notional 12.; informat MaturityDate mmddyy10.; informat ID $10.; informat FaceValues 8.; informat PaymentDayCount $10.; informat FlatPrice 10.8; informat Description $30.; informat Comments $30.; informat MarketCleanPrice 10.8; informat SettlementDate yymmdd.; informat Name $20.; informat Category $40.; informat PaymentDates mmddyy10.; informat AnnualCouponRates 6.4; informat OriginationDate mmddyy10.; informat OAS 5.2; informat FirstCpnDt mmddyy10.; format PriceToPublic 10.8; format FullPrice 10.8; format CouponDates MaturityDate ValuationDate PaymentDates OriginationDate        SettlementDate FirstCpnDt date9.; input InstrumentName $ PriceToPublic Cusip $ CouponDates ValuationDate       AccruedDayCount $ FullPrice InterestFrequency Notional MaturityDate       ID $ FaceValues PaymentDayCount $ FlatPrice Description $ Comments $       MarketCleanPrice SettlementDate Name $ Category $ PaymentDates        AnnualCouponRates OriginationDate OAS FirstCpnDt; ID=Cusip; Name=Cusip; run; data NCDebt2;   retain InstrumentName PriceToPublic Cusip CouponDates ValuationDate          AccruedDayCount DiscountSource FullPrice UnderWriterDelivery          InterestFrequency Notional MaturityDate ID FaceValues          PaymentDayCount CouponAdjusting FlatPrice Description Comments          MarketCleanPrice BusinessDayAdjust CouponEntry SettlementDate Name Category          PaymentDates AnnualCouponRates UnderwriterDiscount DisableLegacyMeasures          OriginationDate OAS FirstCpnDt;          DiscountSource='OIS';          UnderWriterDelivery=-1;          CouponAdjusting='false';          BusinessDayAdjust='Following';          CouponEntry='Manual';   UnderwriterDiscount=0.0;          DisableLegacyMeasures='false';          format UnderwriterDiscount 3.1;          set NCDebt;   Result= MaturityDate-ValuationDate;   if InterestFrequency=2 then do;     arrelements=(intck('semiyear',FirstCpnDt,MaturityDate)+1);   end;   else if InterestFrequency=12 then do;     arrelements=(intck('month',FirstCpnDt,MaturityDate)+1);   end;   call symput('arrelements',arrelements);   drop Result arrelements; run; %put &arrelements; data NCDebt3;    set NCDebt2;    array date{&arrelements} date1-date%eval(&arrelements);    date%eval(&arrelements)=MaturityDate;    date1=FirstCpnDt;    format date1 date%eval(&arrelements) date9.; run; %macro Cashflows(); data NCDebt4;    set NCDebt3;    %do k=0 %to 2;      %do i=1 %to 3;        if month(date%eval(&arrelements))>6 then do;           %let month=%sysfunc(month(date%eval(&arrelements-&i)))-6;           %let year=%sysfunc(year(date%eval(&arrelements-&k)));           %put &month &year;        end;        else if month(date%eval(&arrelements))<6 then do;           %let month=%sysfunc(month(date%eval(&arrelements)))+6;           %let year=%sysfunc(year(date%eval(&arrelements-&i)))-1;           %put &month &year;        end;      %end;    %end; run; %mend Cashflows; %Cashflows; ... View more

I have the attached output also shown below. This already exists in SAS, so my objective is not to import the .csv file into SAS; the .csv file is just attached for your convenience. The variables are all text/character variables and I am trying to convert them into numeric using the code below, however all that I get are numeric blanks ie ( . ). Could someone please provide some insight? data WANT;    set Data;    M1=input(InterestFrequency,3.);    M2=input(MaturityDate,ddmmyy8.);    M3=input(FirstCpnDt,ddmmyy8.); run; ********************************************************** ********************************************************** SAS DATASET InterestFrequency     MaturityDate     FirstCpnDt           2                      15May2041      15Nov2011 ... View more

I have the following code, which I apply to the attached.csv file. My end goal is to calculate the number of days between the macro variables &MaturityDate and &ValuationDate. Unfortunately, I am not getting a reasonable result (see arrow below). Could someone please provide some insight? Thanks in advance. data WORK.NCDebt;      infile '/fmacdata/utility/fin/KBenchmarks/SAS Data/NCDebt_1.csv' dsd lrecl=40000 firstobs=2; informat ValuationDate yymmdd.; informat MaturityDate mmddyy10.; format MaturityDate yymmdd10. ValuationDate yymmdd10.; input ValuationDate $ MaturityDate $; run; proc transpose data=Ncdebt   out=Ncdebt2;   var ValuationDate MaturityDate; run; data Ncdebt3;   set Ncdebt2(rename=(_NAME_=Var1));   keep Var1 COL1; run; proc sql;   select COL1   into: ValuationDate   from Ncdebt3   where var1='ValuationDate'; quit; proc sql;   select COL1   into: MaturityDate   from Ncdebt3   where var1='MaturityDate'; quit; %let Result=%eval(&ValuationDate-&MaturityDate);   ------>THIS PART IS NOT GIVING ME THE CORRECT RESULTS %put &ValuationDate &MaturityDate &Result; ... View more

I have the following character variable. What is the best way to convert it to numeric? Var1 05/15/2039 05/15/2038 05/15/2021 05/15/2020 07/02/2015 01/20/2015 11/20/2014 09/16/2014 09/15/2016 ... View more

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 ... View more