proc sql query help plz

[frank1947]

Hi all, i have one variable, 'zcta'. it has 5 digit value and 4 digit value but i want to pull up information where 'zcta' has only 4 digit. How can i do that?  ---Thanks.

[PGStats · Accepted solution]

Seems too simple?  Add the clause

WHERE ABS(zcta) < 10000

to your query.

PG

[frank1947]

that was so logical, writing 10k 🙂     --- Thanks

[frank1947]

Hi PGSTATS, can i get hint on this-if you can please?

i have two variable in dataset named 'telno' and 'state', couple of state required zero '0' in front of 'telno' variable. if i wants to add zero '0' for couple of states only, how can i do that? 'telno' is a numeric variable...

Thanks.

[DBailey]

case when state in ('s1','s2','s3') then '0' end || telno as telno2

[PGStats]

telno is numeric, cannot be a || operand. Rather :

cats(case when state in ('s1','s2','s3') then '0' end, telno) as telnoChr

PG

[frank1947]

@ DBailey- can you please write proc sql step with it - i don't know but i am not just getting it right...

Thanks

[DBailey]

proc sql;

create table want as

select

     state,

     telno,

     cats(case when state in ('s1','s2','s3') then '0' end, telno) as telnoChr

from

     have;

quit;

[frank1947]

Thanks you so much DBailey and PGStats. It worked...

appreciate it!