topic Facing problem in proc sql with compress use in SAS Procedures

Facing problem in proc sql with compress use

Chandan511 — Wed, 10 Jun 2020 04:38:17 GMT

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??

Re: Facing problem in proc sql with compress use

Kurt_Bremser — Wed, 10 Jun 2020 04:45:14 GMT

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.

Re: Facing problem in proc sql with compress use

Chandan511 — Wed, 10 Jun 2020 06:22:26 GMT

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

Re: Facing problem in proc sql with compress use

Kurt_Bremser — Wed, 10 Jun 2020 08:34:55 GMT

@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.

Re: Facing problem in proc sql with compress use

Ksharp — Wed, 10 Jun 2020 12:03:14 GMT

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