Facing problem in proc sql with compress use

[Chandan511]

I am trying this below code but program is right but problem happen why compress use here

Proc sql
Select custid, age,gender,city
From table1
Where compress(gender)='0'
And city='cityname'
Quit;


Please describe me why compress use here??

[Kurt_Bremser]

Maxim 3: Know Your Data. You might have leading blanks in gender, which COMPRESS() will remove.

PS your code won't run anyway, the PROC SQL statement is missing the necessary semicolon.

[Chandan511]

So in Proc sql Compress() will work same as sas .??

[Kurt_Bremser]

---

@Chandan511 wrote:
So in Proc sql Compress() will work same as sas .??

---

Yes, if used in SAS SQL. If you use it in explicit pass-through, the syntax rules of the remote DBMS need to be observed.

[Ksharp · Accepted solution]

my reckoning is
compress() is equal strip() or left() .