Time ID variable sort problem

[liguang01]

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!

[Tom]

'9' is definitely before 'C' in ASCII codes.  Looks like your data is not sorted by that variable.

[liguang01]

Yeah I got it! I had to change my data to remove C to number for now It works.

[ballardw]

The linguistic sort orders are for people. The procedures that use by group or other ordered processing expect the standard internal sort order unless specifically provided an option such as NOTSORTED.

Otherwise every time you use one of the procedures you would be require to provide the expected sort order key information, i.e. which language sort was used.

[liguang01]

There is no such option on my forecast studio. I had to replace "C" using gsub and then It worked! SAS forecast studio order data independent your data is sorted yet.