How to create a timeseries database

[LNA2021]

Hi,

I'm trying to create a time-series database to use PROC ARIMA to evaluate the impact of the intervention on my data.

The problem is that I don't know how to create a point of change to examine the before and after intervention impact. I use the below syntax but it's not working, I get an error.

Could you please help with that?

Data Project;
Set Project_new (keep=BirthDate Outcome);
Trend =sum (Intck ("quarter", 2018-03-31, BirthDate, ”c”),
N_PreIntervention);
Intervention =max (0, Trend > N_PreIntervention );
TrendPre =max (0, Trend *(Not (Intervention)));
TrendPst =max (0, Trend * Intervention));

Run;

PROC SUMMARY data=Project_new (where = (0<= Trend<=47)) nway;

Var outcome;

Class Trend;

Id Intervention TrendPre TrendPst;

Output out=Quarterly_timeseries mean (outcome)= outcome  std (outcome)= Std_outcome;

Run;

[Kurt_Bremser]

Whenever you have problems with code, the log is essential (see Maxim 2). So please post your complete log by copy/pasting it into a box opened with this button:

[LNA2021]

[Kurt_Bremser]

Please do NOT post pictures. Just copy/paste the log text into a code box, that's all.

The first ERROR message is very clear; fix that issue, and you may have fixed all.

[ballardw]

If you error involves this line:

Trend =sum (Intck ("quarter", 2018-03-31, BirthDate, ”c”),

and something about a value is not a date or valid that would be because if you want to specify a specific date in code the appearance is 'ddMONyy'd or 'ddMONyyyy'd, such as '31MAR2018'd. The quotes plus the d tell SAS that you intend to use a date value. ONLY  this format works for date literals because there just too many different arrangements that dates might appear as. SAS has chosen to recognize one so that it is consistent across preferences.