topic Re: data step in SAS Programming

Error in Where clause in data step

aniketwagare0 — Fri, 29 Jul 2016 00:07:05 GMT

I am runing following code,

libname orionx XLSX "/home/aniketwagare0/test/ecprg193/lpar.xlsx"
libname outori "/home/aniketwagare0/test/output"

data outori.tetest
set orionx.lpar1
where Action Performed='111 Create an account' and Action Performed='109 Subscribe Email'
run

But i am getting following error,

57 data outori.tetest;

58 set orionx.lpar1;

59 where Action_Performed='111 Create an account' and Action_Performed='109 Subscribe Email'

ERROR: Variable Action_Performed is not on file ORIONX.lpar1.

60 run;

I have attached my xlsx file.

Re: data step

ballardw — Thu, 28 Jul 2016 23:10:01 GMT

Check your spelling. Make sure the variable you reference is the same. I will bet that there is no _ in the name of the variables (or a space either)

Re: data step

Reeza — Fri, 29 Jul 2016 00:06:28 GMT

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');

Re: Error in Where clause in data step

Kurt_Bremser — Fri, 29 Jul 2016 07:39:46 GMT

This

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.