07-28-2016 06:59 PM - last edited on 07-28-2016 08:07 PM by Reeza
I am runing following code,
libname orionx XLSX "/home/aniketwagare0/test/ecprg193/lpar.xlsx"
libname outori "/home/aniketwagare0/test/output"
where Action Performed='111 Create an account' and Action Performed='109 Subscribe Email'
But i am getting following error,
07-28-2016 08:06 PM
Your condition will never be true.
If one portion is true the other will not be true.
Perhaps you mean OR instead of AND?
You can also use IN
where actionPerformed in ('match1' , 'match2', 'match3');
07-29-2016 03:39 AM
ERROR: Variable Action_Performed is not on file ORIONX.lpar1.
tells the whole story. You mistyped the variable name.
Before working with Excel files through SAS, one should make sure that the header lines in the sheets (which are used to create variable names) adhere to SAS naming standards.
I'd rather import the Excel data into SAS (preferably by saving to a proper file format like csv from Excel) and deal with issues there.