topic Re: SAS Forecast. Time ID variable sort problem in SAS Programming

SAS Forecast. Time ID variable sort problem

liguang01 — Thu, 24 Dec 2020 11:28:22 GMT

Hi Everyone!

I'm new on SAS Forecast. I want to calculate a model for a serie but I have a problem to put time ID variable.

There is some error and I don't know how I can correct it.

The current by group has ID= CT999-45 and next by group has ID = 99777-48. Error variable count not found. That is what it says on the message.

I tried to order my dataset before but It doesn't work. I tried with linguistic order on my dataset before I read it in SAS Forecast but still nothing.

sortseq=linguistic(numeric_collation=on);

Anyone could help?

Thanks!

Re: SAS Forecast. Time ID variable sort problem

Kurt_Bremser — Thu, 24 Dec 2020 11:56:33 GMT

Run a PROC SORT, where you use the same variable(s) in the BY statement as you use them in the Forecast procedure.

Re: SAS Forecast. Time ID variable sort problem

liguang01 — Thu, 24 Dec 2020 12:02:47 GMT

I tried to this one but It does not work. First of all I run proc sort and then save file. After that I opened SAS Forecast and put variables but I have still same problem