date group issue

statrick — Wed, 17 Feb 2010 17:27:45 GMT

I'm having an issue where my code is changing a date into a character. I found out that it's when I'm grouping by two dependant variables when rolling other information. Here is the code that gives me the character date:

proc sql;
create table work.store_sls_next as SELECT
DEPT_I,
CLASS_I,
ITEM_I,
STORE_I,
RETL_A,
SUM(TOT_SLS_A) AS TOT_SLS_A,
SUM(WKLY_SLS_Q) AS TOT_SLS_Q,
"&date"d as wk_end_date
FROM work.STORE_SLS
where dept_i in (&dept_list)
AND WKLY_SLS_Q <> 0
AND class_i in (&class_list)
AND item_i in (&item_list)
group by DEPT_I, CLASS_I, ITEM_I, STORE_I, RETL_A, COST_A;
quit;

Note that the "&date"d is reading in correctly as a date. The bold part is what seems to be causing the issue. When I exclude that section, the date comes through correctly. Any ideas why?

Re: date group issue

DanielSantos — Wed, 17 Feb 2010 17:46:30 GMT

Nothing wrong about your query, unless this part:
[pre]
AND WKLY_SLS_Q 0
[/pre]
Which I suspect should be:
[pre]
AND WKLY_SLS_Q eq 0
[/pre]
But it could be a typo.

Everything else should work has supposed.

I'm also assuming that, although you are not keeping COST_A, it does exists in work.STORE_SLS and is necessary to group the variables.

Cheers from Portugal.

Daniel Santos @ www.cgd.pt

topic Re: date group issue in SAS Procedures

date group issue

Re: date group issue