SORT stme- could you please correct me

[Former Member]

I guess I can write coding BY prctr zglfielddesc ASCENDING...

Could you please suggest me, if this is wrong.

SORT grouping_table_out

BY prctr zglfielddesc ASCENDING

zgleffectivedate DESCENDING.

[RichHeilman]

This statement should work fine.

SORT grouping_table_out  BY prctr zglfielddesc ASCENDING
                                            zgleffectivedate DESCENDING.

Regards.

Rich Heilman

[Former Member]

There is nothing wrong writting like this.

[Former Member]

Yes Code is right.

SORT grouping_table_outl BY prctr  zglfielddescASCENDING
                                            zgleffectivedate DESCENDING.

It sorts first by prctr,then by zglfielddesc and last by zgleffectivedate

Regards

Aneesh.