Text files often brings headache for data analysts, are there any more convenient way for text files process? I prepare a case on how esProc deal with it, including import various text files; process big text files; visit text files of hdfs; as well as general operations, such as, file moving, deleting and checking whether a file exists. The following will illustrate these functions through examples. …

When I was growing up, a big treat on a summer afternoon was to get a Dairy Queen ice cream cone dipped in chocolate. Dairy Queen advertised their treats as scrumpdillyicious, which they were to a seven year old!  If you are not aware, SAS ships some shared prompts that you can use with your stored process … and you guessed it … I think they are scrumpdillyicious!

Locating the Shared Prompts

SAS…

SAS Business Intelligence applications use global macro variables to store information about the environment as well as prompt values entered by a user. When developing a Stored Process it is often helpful to review the values of these macro variables. A simple %PUT statement, %PUT _GLOBAL_ ; , will write a listing of the values of all global macro variables to the log, but the formatting leaves a lot to be desired. This post describes a simple utility macro,…

Here’s some usability tricks that I have learned with my SAS Stored Processes to make them more robust and harder to break.  Really the out-of-the box prompts provide a lot of functionality that really helps. That’s right – let’s build a better mousetrap!…

For statistical process control, a number of single charts that jointly monitor both process mean and variability recently have been developed. For quality control-related hypothesis testing, however, there has been little analogous development of joint mean-variance tests: only one two-sample statistic that is not computationally intensive has been designed specifically for the one-sided test of Ho: Mean2<=Mean1 and StDev2<=StDev1 vs. Ha: Mean2>Mean1 OR StDev2>StDev1 (see…

How to navigate confidently through the global financial crisis? Where to start? Is there any alternative to personnel lay-offs and cutting free coffee and soda at the office? By executing a proper inventory management strategy you can release cash and significantly improve solvency and stability of your business. A hot topical issue these days, isn’t it?…

Is there a sense to fight for 1% forecast accuracy increase? Is the play of improving the forecasting process worth the candle? We are convinced, it is, regardless of the numerous bypass techniques to compensate for the forecast error. It is important indeed to take the first step in business process correctly. Here is what in our opinion most businesses should start and continue with.…