Hi, make sure the path is shared. []'s ... View more

Hi beto, The macro variable no compile/change  with ' change de data step with: data _null_; call symput('yesterday',put(today()-1, mmddyy10.)); run; change the proc sql with: proc sql; CREATE TABLE Part1 AS select * from connection to ODBC (SELECT Date, CodeNumber, Sum(Amount) AS ReplenAmount FROM tbVendors where DATE ="&yesterday" GROUP BY Date, cOdeNumber,Amount ORDER BY CodeNumber);   quit; The date is complicated used in the macro variable and using obdc connect is not SAS date variable, and macro variable has the format database odbc connect for success full insert. Re: How to use date/time field  with a minus 1 day ... View more

Beto. Verify exemple.... data teste; data_dia = '04nov2012 00:00:00'dt; run; proc sql; select datepart(data_dia) format=ddmmyy10., datepart(data_dia -1) format=ddmmyy10. from teste;quit; For data step exist intnx function... verify ... View more

dmorrell! Try change _infile_. verify sintaxe the _infile_ and prxchange() ok my english is tiny.... thank ... View more

Hi, nothreads options can help. Proc sql nothreads; : : quit; proc sort data=<datasetname> nothreads out=<outdasetname> by <key>; run; geraldo brasil. this is;;; ... View more

Geraldo, add  RECFM=F and LRECL=32767 ; thanks ... View more

My Example: data teste;    infile '/names.txt';    input @;    _infile_    = prxchange('s/\"//',-1,_infile_);    Contador    = countc(_infile_,',');    Text_Buffer = _infile_;    Pos_Inic    = 0;    Pos_Prox    = 0;    do I=0 to Contador;        Pos_Prox    = findc(Text_Buffer,',',Pos_Inic +1);     NAME        = substr(Text_Buffer, Pos_Inic + 1, Pos_Prox - 1);     Text_Buffer = substr(Text_Buffer, Pos_Prox + 1, length(Text_Buffer));     output;   end;   drop Contador Text_Buffer Pos_Inic Pos_Prox I; run; ... View more

This example for import without error. data TEST_IMPORT; infile '/sasworwk/SAS_workDADAEA/input.txt' dsd delimiter=',' firstobs=2; /* change '"' for nothing */ input @; _infile_ = prxchange('s/"//',-1,_infile); length        'Carrier ID'n 8.        'Phr NPI'n 8.        'Phr Network ID'n 8.        'Phr Zip'n 8.        'Drug Maintenance Code'n $1.        'PHA Pharmacy State'n $2.        'Gen Ind-Override'n $1.        'GPI Number'n 8.        'Customer Location'n $2.        'U & C Flag'n 8.        'Days Supply'n 8.        'Zero Balance Claims Flag'n 8.        'Extended AWP Cost'n 8.        'Claim Counter'n 8.        'Clt Ingred Cost Paid'n 8.        'Clt Dispensing Fee'n 8.        'Clt Due Amt'n 8.        'Phr Ingred Cost Paid'n 8.        'Phr Dispensing Fee'n 8.        'Phr Due Amt'n 8.; input        'Carrier ID'n        'Phr NPI'n        'Phr Network ID'n        'Phr Zip'n        'Drug Maintenance Code'n $        'PHA Pharmacy State'n $        'Gen Ind-Override'n $        'GPI Number'n        'Customer Location'n $        'U & C Flag'n        'Days Supply'n        'Zero Balance Claims Flag'n        'Extended AWP Cost'n        'Claim Counter'n        'Clt Ingred Cost Paid'n        'Clt Dispensing Fee'n        'Clt Due Amt'n        'Phr Ingred Cost Paid'n        'Phr Dispensing Fee'n        'Phr Due Amt'n; run; It´s ... View more