Below is a simplified example of what I am trying to accomplish.  I have a data set that has a character variable called MOD with values "N", "0", "1", ... "9".  I am using a macro, stored in a separate file to condense the length of the program, to define a new variable called PRODUCT.  The PRODUCT value in the third record in the output data set should be "SCOOTER" based on ID = "0001" and MOD = "6".  However, I have something coded incorrectly because it is returning "BIKE".  I suspect that it is in the IN operator since I haven't used this functionality in a macro before but I suppose it could be anything.  Any help is appreciated.  Thanks in advance.     %MACRO PRODUCT(ID, MOD) / MINOPERATOR; %local M1; %if &MOD = N %then %let M1 = N; %else %if %EVAL(&MOD in 6 8 9) %then %let M1 = Y; %else %let M1 = N; if &ID = "0001" and "&M1" = "Y" then PRODUCT = "SCOOTER"; else if &ID = "0001" then PRODUCT = "BIKE"; else if &ID = "0002" then PRODUCT = "SKATEBOARD"; %MEND; data TEST1; infile datalines; input ID $ MOD $; length PRODUCT $ 10; %PRODUCT(ID, MOD) datalines; 0001 N 0001 0 0001 6 0002 8 ; run; ... View more

It seems proc import can retrieve data from Excel if the data is in a sheet by itself using the "sheet=" statement, known range i.e., "A1:C10", or named range using the "range=" statement.  What I don't see is an easy way to import the data if it is an Excel Table.  Something like a "table=" statement in the code below to accomplish this would be extremely helpful.  I apologize if this already exists, I couldn't find anything.  Thanks in advance for your attention to this matter.   proc import out= WANT datafile= "C:\ExcelFile.xlsm" dbms= EXCEL replace; TABLE= "TBL"; run; ... View more

It would be nice to have a way to set the order of the variables in the output data set based on the order of the variables listed in a KEEP= data set option.  I apologize if this already exists, I did a quick Google search and the only ways I see to achieve this is by using RETAIN, FORMAT, etc. before the SET statement, like in the below code.  It is not a huge lift to list the variables twice, it just seems redundant.  The second data step below demonstrates one way this could be done.   Thanks in advance for your attention to this matter. data WANT (keep= ID DATE ORDERNUM AMT); retain ID DATE ORDERNUM AMT; set HAVE; run; data WANT (keep= ID DATE ORDERNUM AMT / inorder); set HAVE; run; ... View more