topic Re: SAS 'where' expression to only select numeric variable MAR2019 in SAS Programming

SAS 'where' expression to only select numeric variable MAR2019

jeremy4 — Tue, 30 Apr 2019 14:59:01 GMT

Hi,

I am looking to create a table that only pulls the result MAR2019 from the MTH_END variable. MTH_END is a numeric variable (shown by the screenshot below) and I have already successfully done a left join to connect two datasets - all of my proc sql code has worked without this extra condition that I want to include but I am not sure how to complete the line below (highlighted in red), given that MAR2019 is a mixture of components. Can someone please help with completing the line below ('a.cards_2019 is the dataset that I have already successfully referenced after doing the left join)? Thanks.

where a.cards_2019= ????????????? ;

Re: SAS 'where' expression to only select numeric variable MAR2019

Jagadishkatam — Tue, 30 Apr 2019 15:02:38 GMT

please try

where a.cards_2019= 21609;

Re: SAS 'where' expression to only select numeric variable MAR2019

PeterClemmensen — Tue, 30 Apr 2019 15:05:53 GMT

If you want month-end values only:

where a.cards_2019='31mar2019'd;

if you want the entire month

where '01mar2019'd <= a.cards_2019 <= '31mar2019'd;

Keep in mind that the MONYY7. Format will display 01mar2019 the same as 31mar2019: MAR2019

Let me know is it makes sense 🙂

Re: SAS 'where' expression to only select numeric variable MAR2019

jeremy4 — Tue, 30 Apr 2019 15:44:08 GMT

Thanks for your help!

Re: SAS 'where' expression to only select numeric variable MAR2019

novinosrin — Tue, 30 Apr 2019 16:18:26 GMT

Hi @jeremy4 Sorry for the late entry, for what it's worth

the expression also can be written as

where put(a.cards_2019,monyy7.)='MAR2019';