: No, I meant what I suggested, creating a copy of original (labeled desired) and using the modify statement using desired as the master. I never like to use the actual master when using modify as there is a chance that the file can become corrupted if the process gets interrupted. The result of my suggested code matches all of your desired results with the exception of Feb 28, 2015 for cusip 3136G0XX. I don't know if that was an error on your part or if there is something you want to do that I didn't see specified. ... View more

The quick and dirty way is easy to program: %put _user_; However, it may give you a little more information than you are looking for, and in a different order than you are hoping for. ... View more

The . for missing is a system option. Inside a dataset I wouldn't worry about it. For any report procedure or data export before the procedure use: options missing=' '; to have a single space instead of the period appear. Reset to default afterwards using option missing='.'; If you are really worried about the appearance within a data set then use the same option missing=' '; ... View more

Tom, I have completed my code which you can find in the discussion titled Proc Export - Issues with Exporting to .txt files. I hope that this gives you an idea of my final product and I also hope to stay in your good graces. ... View more

Tom, I can't thank you enough for your continued engagement. Below is the code that leads to the leads to the Data dataset mentioned above; in the code below the test2 dataset is the same as the Data dataset mentioned above. Are you saying that I should bring in ValuationDate and MaturityDate from the .csv file using an MMDDYY informat? Also, relating to your question on my other posting ("Not sure why this is not working"); this is best explained in the last data step below (data test3), which is a (cleaner) variation of the code I have in the other posting. I am trying to define arrays of different lengths depending on whether the InterestFrequency variable assumes a value of 2 or 12; InterestFrequency represents the frequency of the coupon payments on a bond, so if the bond pays interest semiannually (ie InterestFrequency=2) it will have different cashflows (represented by the array) from a bond that pays interest monthly (and hence, has a different array associated with it, whereby InterestFrequency=12). As you can see, my entire "data test3" datastep hinges on my being able to convert InterestFrequency, MaturityDate, and ValuationDate into numeric variables so that I can get the datastep to run. I hope this clarifies matters. data WORK.NCDebt;      infile '/fmacdata/utility/fin/KBenchmarks/SAS Data/NCDebt_1.csv' dsd lrecl=40000 firstobs=3; informat ValuationDate yymmdd.; informat MaturityDate mmddyy10.; informat InterestFrequency 5.; informat AccruedDayCount $10.; format ValuationDate date9.  MaturityDate date9.; input ValuationDate MaturityDate InterestFrequency AccruedDayCount $; run; proc transpose data=Ncdebt   out=Ncdebt2;   var ValuationDate MaturityDate InterestFrequency AccruedDayCount; 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=%sysevalf("&MaturityDate"d-"&ValuationDate"d); %put &Result; proc transpose data=Ncdebt3    out=test;    var var1 COL1;    id var1; run; data test2;   set test (firstobs=2);   keep MaturityDate ValuationDate InterestFrequency; run; data Test3;    set Test2;    if InterestFrequency='2' then do;     count1=(intck('semiyear',ValuationDate,MaturityDate)+1);     %let arrelements=count1;     array dt{&arrelements} dt1-dt&arrelements;    end;    else if InterestFrequency='12' then do;     count1=(intck('month',ValuationDate,MaturityDate)+1);     %let arrelements=count1;     array date{&arrelements} date1-date&arrelements;    end; run; ... View more

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

DATA WORK.Example1;     LENGTH         F1                 8 ;     FORMAT         F1               YYMMDD8. ;  /** CHANGE THE FORMAT AS YOU NEED TO DISPLAY OUTPUT */     INFORMAT         F1               YYMMDD10. ;     INFILE 'xxxxx/Example.csv'         LRECL=10         ENCODING="LATIN1"         TERMSTR=CRLF         DLM='7F'x         MISSOVER         DSD ;     INPUT         F1               : ?? MMDDYY10. ; RUN; ... View more

Thank you so much. I created a scenario to myself as per your explanation. Please adjust it your needs. What stat@sas provided works great in the situation. DATA HAVE; INPUT NAME $    AGE; DATALINES; TOM         10 JOHN        18 JILL        23 CHRIS       25 DON         31 ; RUN; DATA WANT; RETAIN NAME SEX AGE; SET HAVE; IF INDEX(NAME,'O') THEN   SEX='M'; ELSE SEX='F'; RUN; ... View more

Or, you could build a small import program, the below for instance assumes text for quoted values and numeric for not: /* test data CSV looks like this */ /* TOWN,POP,IN "London",123456,"UK" "Glasgow",34243,"UK" "Brussels",7876,"Belgium" */ data read_data;   length buffer $2000.;   infile "s:\temp\rob\test.csv" dsd missover lrecl=32767 dlm="¬";   input buffer $; run; data a/*_null_*/;   merge read_data (obs=1 in=head) read_data (obs=2 in=first_row firstobs=2 rename=(buffer=myrow));   i=1;   call execute('data want (drop=buffer);                   set read_data (firstobs=2);                   length ');   /* Assign lengths based on first row */   do while (scan(buffer,i,",") ne "");     call execute(" "||scan(buffer,i,","));     if index(scan(myrow,i,","),'"')>0 then call execute(' $20');     else call execute(' 8');     i=i+1;   end;   i=1;   call execute(';');   /* Split up the data */   do while (scan(buffer,i,",") ne "");     call execute(" "||scan(buffer,i,",")||'=scan(buffer,'||strip(put(i,best.))||',",");');     i=i+1;   end;   call execute('; run;'); run; ... View more

Huh?  I do not see any macro conditional logic there that would require %EVAL(). This line of code is just generating a simple SAS statement.    if randv < &n_def_runoff1/&n_def_runoff9 then quarter = 1; So if those two macro variables evaluate to 3 and 103 , respectively, then it is the same as if you wrote if randv < 3/103 then quarter = 1; SAS knows how to divide numeric constants. ... View more

You can specify more than one filename in the %INCLUDE statement. filename myprogs '\filepathmaindirectory\filepathsubdirectory\'; %inc myprogs(filename1 filename2 filename3) / source2; ... View more