topic where in condition of proc export in SAS Procedures

where in condition of proc export

azertyuiop — Fri, 01 Dec 2017 12:11:25 GMT

Hello , good morning,

I want place a condition "where " in a proc export like this :

proc export data=work.refec9 (where=(acteur="toto") (statut<>"tata")) outfile="\\serveur\\dossier\sousdossier\truc.xlsx" dbms=XLSX replace ;
sheet="a_traiter";
run;

I have tried to follow the law which are here with unsuccess : http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a001000998.htm

Can you give me your opinion

Thanks for the help

[KB] fixed the link

Re: where in condition of proc export

Kurt_Bremser — Fri, 01 Dec 2017 12:10:22 GMT

A where condition needs to be a syntactically valid boolean expression.

(acteur="toto") (statut<>"tata")

clearly is not.

(acteur="toto" and statut<>"tata")

(acteur="toto" or statut<>"tata")

are.

You just have to keep reading on in the documentation:

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000131192.htm

Re: where in condition of proc export

RW9 — Fri, 01 Dec 2017 12:10:32 GMT

This:

(where=(acteur="toto") (statut<>"tata"))

Is not a valid where clause. Where clause take the form:

where <condition> [logical operator <condition>];

So:

(where=(acteur="toto" and statut<>"tata"))

Would work.

You are trying to do a where clause like its options - e.g. keep or drop or where.

Re: where in condition of proc export

azertyuiop — Fri, 01 Dec 2017 13:35:25 GMT

Excellent for your link , I keep this in my paper note .

Re: where in condition of proc export

azertyuiop — Fri, 01 Dec 2017 13:36:56 GMT

I have tried this code :

proc export data=work.ma_table (where=(champ1<>"XXXX" and champ2="YYYY" )) outfile="\\serveur\\dossier\sous dossier\\fichier.xlsx" dbms=XLSX replace ; sheet="nomfeuille2"; run;

It's ok in my side , there is a result in out 😄