06-26-2018
zjanuske
Calcite | Level 5
Member since
01-23-2018
- 7 Posts
- 1 Likes Given
- 0 Solutions
- 0 Likes Received
-
Latest posts by zjanuske
Subject Views Posted 2707 06-18-2018 12:20 PM 2715 06-18-2018 12:14 PM 2731 06-18-2018 11:58 AM 3286 05-15-2018 04:17 AM 3026 01-23-2018 04:34 AM 3043 01-23-2018 04:20 AM 3052 01-23-2018 04:08 AM -
Activity Feed for zjanuske
- Posted Re: Expression using equals has components that are of different data types on SAS Programming. 06-18-2018 12:20 PM
- Posted Re: Expression using equals has components that are of different data types on SAS Programming. 06-18-2018 12:14 PM
- Posted Expression using equals has components that are of different data types on SAS Programming. 06-18-2018 11:58 AM
- Posted Forecasting was not performed... on SAS Forecasting and Econometrics. 05-15-2018 04:17 AM
- Posted Re: Counting values in sequence by group on SAS Programming. 01-23-2018 04:34 AM
- Liked Re: Counting values in sequence by group for PeterClemmensen. 01-23-2018 04:33 AM
- Posted Re: Counting values in sequence by group on SAS Programming. 01-23-2018 04:20 AM
- Posted Counting values in sequence by group on SAS Programming. 01-23-2018 04:08 AM
-
Posts I Liked
Subject Likes Author Latest Post 2
06-18-2018
12:20 PM
they;re both fine, the error is on those two lines i've highlighted in red
... View more
06-18-2018
12:14 PM
t.start specifications are exactly the same as Last Expiry Date (or r.sunday). I'm currently only trying to solve the dates issue, not worrying about campaign length yet.
... View more
06-18-2018
11:58 AM
Hi, I'm running a proc sql table, trying to compare dates in the WHERE statement. I keep getting this error: "Expression using equals (=) has components that are of different data types.". I have run proc contents to compare formats of both variables, and they look the same: The code I'm running: PROC SQL;
CREATE TABLE TRACKER_REDEMPTIONS AS SELECT t.*, r.redemptions FROM tracker_work4 T LEFT JOIN new_redemptionst r ON
((T.STORE=r.store) AND
(T.CAMPAIGN = r.campaign) AND
(T.start <= r.sunday) AND
(T.'Last Expiry Date'n >= r.sunday)) ;
RUN; I'm out of ideas for what could be wrong. Help!
... View more
05-15-2018
04:17 AM
Hi, I'm running this code: proc arima data=prints2; identify var=prints(364) scan; estimate p=5 q=4; forecast lead=60 out=forecastprints id=datenew interval=day; run; Which used to run fine, and today i'm getting an error. We add a new date each day we run it. The error says: ERROR: Forecasting was not performed because estimation was not done. Any ideas what could've gone wrong? Thanks
... View more
01-23-2018
04:20 AM
Yes, there is always 1 week between the dates, and each customer has the same number of weeks assigned to them. And correct - I want the longest sequence of 1s by cust_id,
... View more
01-23-2018
04:08 AM
I wanted to count number of visits in a row (each week) for each customer. The problem I'm having is, if I'm using if.first counters, i need to sort the data by the two variables - customer id and a flag whether they visited that week or not. However, I need to keep the data sorted by date and customer id, as I'm interested in sequential observations. For example: Week_end Cust_id Visit_flag 01JAN2017 01 0 08JAN2017 01 1 15JAN2017 01 1 22JAN2017 01 0 29JAN2017 01 1 05FEB2017 01 0 01JAN2017 02 0 08JAN2017 02 1 15JAN2017 02 1 22JAN2017 02 1 29JAN2017 02 1 05FEB2017 02 0 The output i want, is how many weeks in a row (max) a customer has visited: Cust_id max_seq_visits 01 2 02 4 Thanks in advance for any help.
... View more