This code represents a call symput macro that formats the last day of the previous month.  I include the output symbolgen data _null_;   call symput('m',put(&pbd_date,yymmdd10.));   run; %put &m; SYMBOLGEN:  Macro variable M resolves to 2014-09-30 10648  %put &m; 2014-09-30 Now I want to use &m to define the previous month and the last 2 months consecutively.  The data _null_ accomplished that with no issue However if you look at the information in red, when I use the put statements I get March and April 1965 not 2014.  I am scratching my head here.  For those who have worked with date variables any suggestions data _NULL_; call symput ( 'curr_month1', cat("'"||put(intnx('month',&m.,-1,'e'),yymmdd10.)||"'")); call symput ( 'prev_month1', cat("'"||put(intnx('month',&m.,-2,'e'),yymmdd10.)||"'")); run; %put &curr_month1 &prev_month1; 10611  call symput ( 'curr_month1', cat("'"||put(intnx('month',&m.,-1,'e'),yymmdd10.)||"'")); SYMBOLGEN:  Macro variable M resolves to 2014-09-30 10612  call symput ( 'prev_month1', cat("'"||put(intnx('month',&m.,-2,'e'),yymmdd10.)||"'")); SYMBOLGEN:  Macro variable M resolves to 2014-09-30 10613  run; NOTE: DATA statement used (Total process time):       real time           0.00 seconds       cpu time            0.00 seconds       SYMBOLGEN:  Macro variable CURR_MONTH1 resolves to '1965-04-30' SYMBOLGEN:  Macro variable PREV_MONTH1 resolves to '1965-03-31' 10614  %put &curr_month1 &prev_month1; '1965-04-30' '1965-03-31' ... View more

IF CO_VA_DFLT_RSN_CD = 'DOB' THEN REASON_FOR_DEFAULT = '001';          ELSE IF CO_VA_DFLT_RSN_CD =  ' '  THEN REASON_FOR_DEFAULT = ' ';          ELSE IF CO_VA_DFLT_RSN_CD = 'ILB' THEN REASON_FOR_DEFAULT = '002';          ELSE IF CO_VA_DFLT_RSN_CD = 'ILF' THEN REASON_FOR_DEFAULT = '003'; This is a snippet of the output statement REASON_FOR_DEFAULT End As REASON_FOR_DEFAULT format $3.,/*which means this is supposed maintain the leading zero*/ This file runs and saves as a .csv file.  I have been reading alot on how leading zeroes are ommitted from csv files when opening in csv or excel.  Is there a way that sas can freeze the leading zero format on the sas side to maintain the leading zero.  The above example is part of the code So for example reason_for_default = 002 comes over as 2. This is the output to csv statement %Let route = %str(/D5/dors09/dors/sascode/reporting/); %Let outputfile = %str(test_&new_dt_key..csv); %Let pth = &route&outputfile; %Put Output File &pth; ... View more

data appeals1; set appeals; age_585=intck('day',lm_set_up_dt,_585); run; In this code I am getting the number of days between lm_set_up_dt and _585(which is a date) I believe the ‘day’ function does not consider holidays and weekends it just provides a straight day difference. Is there a way to have ‘day’ account for this by assigning the closest business day.(ie if one of the dates falls on Sunday can ‘day’ increment to Monday (ie if _585 falls on Sunday 9/21/14 the code would allow _585 to increment to Monday 9/22/14 for calculation purposes.  In our company we do have a previous business day variable called &pbday.  I may need to learn how ‘day’ is read by sas ... View more

I am attempting to perform a proc export on 4 datasets  Sas is generating an syntax error based on the outfile.  I am not sure what is wrong wit the syntax here. Macro Export (Dataset,Sheetname); proc export data=&Dataset.              outfile=&Outfile.             dbms=EXCELCS replace;                 sheet=&Sheetname.;             server='XX22544'; run; %Mend; %Export (Summary_Yr_Total,"Yr_Total"); %Export (Summary_Yr_Risk_Port,"Yr_Risk_Port"); %Export (Summary_Inv_DQ,"Inv_DQ"); %Export (Actives_Curr_Yr_Pl_5_Yrs,"Loan List"); SYMBOLGEN:  Macro variable DATASET resolves to Summary_Yr_Total NOTE 137-205: Line generated by the invoked macro "EXPORT". 3741     proc export data=&Dataset.              outfile=&Outfile.             dbms=EXCELCS replace;    sheet=&Sheetname.;             server='GA016A744'; run;                                                          -                                                          22 ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string.  ... View more

data test; set test1; run; Here is sample data ln           com_cd            comm_dt 000           ccf                     6/16/2014 001          ccb                     6/5/2012 003         fbb                      10/13/14 proc transpose data=test out=test3   (drop = _name_ _label_); by ln; id comm_cd; var comm_dt; run; Lets say one of the comm_cd (say ccb) does not populate and is a null value, this will cause errors in other parts of the program if I were to reference that comm_cd ... View more

proc sql; create table step as select ln,step_cd,compl_dt from table1 where ste_cd in ('333','M22','444'); quit; Sample Results ln         step_cd          compl_dt 11        333                8/11/2013 11       M22                12/15/2012 12     444                   9/15/2013 data s333; set table1; by ln; if step_cd ='333'; s333_dt=compl_dt; run; data M22; set table1; by ln; if step_cd ='M22'; M22_dt=compl_dt; run; data s444; set table1; by ln; if step_cd ='444'; s444_dt=compl_dt; run; This creates separate dataset for each step cd.  A ln can appear in multiple datasets based on the ln Is there a way to automate the pull using a do loop or an array?  Note that if a step_cd begins with a number I place a character "s" in front.  I just listed 3 step_cd in this example.  In reality I have about 20 step cd.  I am trying to avoid repeating the routine shown in the example ... View more