Hi All, I made project in SAS EG 5.1, but today when i am opening this i am not able to open and error is displayed as: " Unable to delete Data Imported from EVERUEX STOCK DATA-COPY.xlsx, SHORTCUT, it is not in the project" Can you guide me , if i click OK in the error then project does not open. This is very important as i am sitting on client side and have to finish this. KR, Sanchit ... View more

Hi, i have 2 columns i.e. material no., week, quantity. Material no:                week                Quantity 10000000012119         _47_2015          10000 10000000012119          _48_2015          2000 10000000012119          _49_2015          3871 10000000012119          _50_2015          2568     10000000012119          _51_2015          2221 10000000012119          _52_2015          43132 10000000012140          _26_2015          2321 10000000012140          _27_2015          1234 10000000012140          _48_2015          2134 10000000012140          _50_2015          6728 10000000012140          _26_2016          25612 10000000012140          _27_2016          67229 Now i need to create a new column which will start from 1 for a small week and  add 7 to the corresponding week. For eg: As for week 26 it will put 1 and for week 27 it will put 7 and for week 28 it will keep 14...have to keep in mind the year also as for 2016 corresponding value will increase. As i am working in EG 5.1 through GUI basis , so would appreciate if you can help me making the formula in advance expression in the commuted column in query builder. ... View more

Hi, If i have 3 columns like material, quantity and week. Now I have to create a new column in which i do not require the data for which quantity is not available. How to to that? Kindly let me know . Also as i am not using coding so i would appreciate if you can help me in creating this in advance expression in the commutated columns of query builder. Thanks Sanchit ... View more