I have used ODS with tagsets to create an excel report.  Now I need to have the title reflect the logo of the company. Any ideas? ... View more

original code data p_date;      process_date = today();      begin_date = intnx ('day',process_date,-14);      format [rpcess_date begin_date yymmddp10.;      call symput("p_date",process_date);      call sysmput("begin_date", begin_date); Data test_numbers;      Infile "case.txt:      informat ;      input ; run; data data_add; set test_number; some code... run; proc sql;    create table detail_&var2 as     select *     from data_add_&var2; quit; This code works but now I need to change it to a macro with variables; macro all_records (var1, var2); data p_date;      process_date = today();      begin_date = intnx ('day',process_date,-&var1);      format [rpcess_date begin_date yymmddp10.;      call symput("p_date",process_date);      call sysmput("begin_date", begin_date); Data test_numbers;      Infile "&var2..txt:      informat ;      input ; run; data data_add_&var2; set test_number; some code... run; proc sql;    create table detail_&var2 as     select *     from data_add_&var2; quit; mend; %all_records (14, Ark); %all_records (14, Geo); %all_records (13, Ark); %all_records (13, Geo); The only item that correctly converted the var was for the infile.  Error messages are given for the rest.  Can anyone help> Thanks ... View more

I have txt files called 2011.06.01_case.txt 2011.06.02_case.txt 2011.06.03_case.txt 2011.06.04_case.txt 2011.06.05_case.txt ext. I need to read in all the txt file for the past 30 days and attached the date on the txt file to the data inside the file I started by createding a beginning case_date Proc sql; create table p_date as select datepart(today()) as process_date; quit; Data case_date; set p_date; case_date = intnx('day',process_date,-30); run; I am having trouble with the loop; do until &case_date = process_date; Data &case_date_tracking; Infile "site_mgt\&case_date_case.txt " Firstobs = 2 dsd missover; informat Case_number              &Case_date; input      Case_number               &Case_date; next &case_date; run; any help would be greatly appreciated ... View more

I need to calculate a process date from an add date. for each record I have a add_date to reflect the day it  was added I need to calculate a batch date which is 1 day after the add_date except on Weekends. Tuesday batches add_dates for Sunday and Monday my code below works except for the monday batch data test_dates; set trials; cal_date = datepart (add_date); batch_date=intnx('day',cal_date,1); format batch_date yymmddp10.; run; How do I get Sunday add_dates to have batch_dates = tuesday? ... View more

I have a list of cities that I want to put into an array from a data set: data test_array; set city; array a(*) city; do i = 1 to dim(a); put a(i) = city; end; run; proc print no obs data=test; run; code above does not work I would like the out put to look like this instead of ... Baltimore      Washington      Hanover ... View more

I have the code running successful in SQL.  but I am having trouble converting into SAS. SQL code cd_1 = case when datediff (d,a.add_date, b.cd_date) ,<= 1 then 1 else 0 end cd_2 = case when datediff (d,a.add_date, b.cd_date) ,<= 2 then 1 else 0 end sas code create table test as select a.add_date           ,b.cd_date           ,cd_1 = case when datediff (d, a.add_date, b.cd_date) <= 1 then 1 else 0 end           ,cd_2 = case when datediff (d, a.add_date, b.cd_date) <= 2 then 1 else 0 end from data_333 a left join test_data b on a.client = b.client and a.id = b.id; or is it a data step; data test; set data_333 test_data; cd_1 = case when datediff (d, a.add_date, b.cd_date) , <= 1 then 1 else 0 end cd_2 = case when datediff (d, a.add_date, b.cd_date) <= 2 then 1 else 0 end ... View more

Below is the code I am working with: I am trying to get hdate to be 5 days less than tdate.  or hdate to be 5 days before tdate. tdate = PUT(DATEPART(Process_Date), date9.); Format BDate hDate yymmddp10.; BDate = intnx('day',date(),-5); hdate = intnx('day',tdate,-5); however I get hdate and null. any advise ... View more