how can we filter on yyyymm in proc sql ?
how can we filter on yyyymm in proc sql ?
(OP)
Hi,
Wanted to filter on variable YrMth, that store value as yyyymm (datattype as number).
On using proc sql with condition as
WHERE YrMth = 201505, the result returns 0 rows.
How can we use filter that has value stored as yyyymm and return rows instead 0 row ?
Thanks,
DaiChi
Wanted to filter on variable YrMth, that store value as yyyymm (datattype as number).
On using proc sql with condition as
WHERE YrMth = 201505, the result returns 0 rows.
How can we use filter that has value stored as yyyymm and return rows instead 0 row ?
Thanks,
DaiChi
RE: how can we filter on yyyymm in proc sql ?
One way to do this in SAS code is as follows:
CODE
or
CODE
I hope this has helped you.
Klaz
I hope that this helps.
Klaz