Hi My code is as below : %macro pull_offer(); %let start_date = %sysfunc(mdy(1,1,2021)); %last_date = %sysfunc(mdy(1,5,2021));   %do date = &start_date to &end_date; %let target_day = &date; format target_day ddmmmyyyyn8.; %put target_day;   proc sql inobs = 10; create table contact as  select * from contact_master where mis_dt = &target_day; quit;   %let path = "temp/offer_data/test" || &target_day || ".csv"; %put path; proc export data = contact; outfile = &path; dbms = csv; run;   %end;   %mend pull_offer;   %pull_offer; Please help!!! ... View more

Hi,   data report_week_oct_dec_data; set report_04_01_2021(In = in1)      report_11_01_2021(In = in2)       report_18_01_2021(rename = (date = chardate))      report_25_01_2021(rename = (date = chardate))      report_28_12_2020(rename = (date = chardate)); if not missing (chardate) then date = input(chardate,yymmdd10.); if in1 or in2 then date = input(put(date,f8.),yymmdd10.); format date yymmdd10.; run; the datatype of date in the 1st two data sets it is best32. and in the last 3 datasets it char10.   After running this code, the date column is coming blank. As I have been running the code on VDI, I am not privilleged to copy/snip the log. However, I am writing the log for this part of code. Note : Invalid argument to function input at line 476 column 176. In1=1 In2=0 date=. ccsid = 1134567  chardate= _Error_ =1 _N_=20   Please help! ... View more

hi,   data report_week_oct_dec_data; set report_04_01_2021(In = in1) set report_11_01_2021(In = in2)  set report_18_01_2021(rename = (date = chardate)) set report_25_01_2021(rename = (date = chardate)) set report_28_12_2020(rename = (date = chardate)); if not missing (chardate) then date = input(chardate,yymmdd10.); if in1 or in2 then date = input(put(date,f8.),yymmdd10.); format date yymmdd10.; run;   After running this code, the date column is coming blank. Please help. ... View more

hi,   I have the following code :  data Observer_Oct_Jan; set Observer_Oct_Jan_New_org(rename = (Date = Chardate))        Observer(rename = (Date = Chardate));  if not missing(chardate) then date = input(chardate,yymmdd10.)); if(date > 01-10-2020 and date < 31-01-2021); run; I am getting the error : variable chardate has been defined as both numeric and character.   Please help!!   ... View more