yes, sure but could you fix your input statement first.  If there are spaces in the c=variable name, re-write them as 'name with  space'n otherwise the vars do not match the data.    Also, what's the question? ... View more

You are using the macro variable incorrectly.  In fact you do't need it   %macro ownerrange; Length owner $100.; if ((ID='123' and date1 > '01APR2011'D) or (ID='456' and date1 > '05JUN2015'D) or (ID='789')) then owner='JOHN'; %mend; data orders; length ID $3 cost 8. date1 8. date2 8.; input ID cost date1 date2; informat date1 mmddyy10. date2 mmddyy10.; format date1 mmddyy10. date2 mmddyy10.; datalines; 123 50 01/01/2020 02/01/2019 123 60 01/01/2011 03/05/2020 456 10 04/01/2019 01/03/2020 ; run; data owner; set orders; %ownerrange ; run;   ... View more

This line is not valid outside data step %let EVENT_DATE=date1;   ... View more

Why don't you just read in the Excel file and transpose it to have the desired result.   libname dat XLSX '~/dat/mulrows.xlsx'; data imp; set dat.sheet1; if not missing(id) then do; x=id; retain x; end; if missing(id) then id=x; drop x; run; proc transpose data=imp out=want (drop=_:); by id; var order; run; proc print;run; However, if you do need the data lines, write the want dataset to a text file. ... View more

Apologies, your desired output makes no sense to me, I'd think you may wish to show which report value is related to a specific date.   Others have given you excellent answers, however, if you wish to just display your data, here is a suggestion: data have; input ID Date :mmddyy8. Report; cards; 1 3/12/16 20 1 4/13/16 30 1 5/16/16 40 2 6/15/16 50 ; proc report nowd out=want; columns ID (Date, Report); define id /group ; define date /across order=data; define report /analysis; format date date10.; run; In case you do need a dataset, check out the want dataset and rename the _Cn_ vars accordingly.   ... View more

This code replicates your desired output in the Excel file   data series; do i='01Jan2014'd to '31Dec2018'd by 7; year=year(i); month=month(i); week=week(i); output; end; run; proc print label data=series (obs=10); label i='Week end day'; format i mmddyy10.; run; ... View more

Is it possible you have an old version of SAS.  Find was introduced with version 9.  Try Index   data x; input Ptid Education $char10.; edu_f = FIND(Education,"MD")>0; edu_i = INDEX(Education,"MD")>0; Datalines ; 1. MD,DO 2. MD 3. PHD ; proc print;run; ... View more

The parent directory of the executing sas file.   But never mind, I have derived it from the macro variable &_SASPROGRAMFILE which does exist when a SAS code runs in EG.   Thanks for pointing me to the right direction. ... View more

Is there way to get the current path where the SAS program file is located on a SAS server without using a project .egp file?   Thanks ... View more

i am getting  its value as blank ''   %put &_CLIENTPROJECTPATH;  ... View more

what is the error message?   Can you try with an xlsx file format?   libname apple XLSX 'C:\Users\Documents\Sales.xlsx'; ... View more

libname apple excel 'C:\Users\Documents\Sales.xls'; ... View more