# AnalyticBridge

A Data Science Central Community

Success
• Male
• United Kingdom

## Success's Discussions

Started Jan 17, 2014

I've two variables, one is time (hour, minute, second) format and the other is price. I'm interested in determing the max & min values at every 10 mins interval and compute the changes between…Continue

Tags: Mining, Data, SAS

# Success's Page

## Latest Activity

Success's discussion was featured

I've two variables, one is time (hour, minute, second) format and the other is price. I'm interested in determing the max & min values at every 10 mins interval and compute the changes between these two values.I've the macros that does time interval already but i need to create another variable (changes) to see how prices has changed between highest and lowest numbers at every 10 mins.Finally, I need to add another condition to know if the price has reverved by half within 2 hours after…See More
Jan 17, 2014
Success replied to Success's discussion How to use 'do loops' for ranges in SAS? in the group SAS Network
"Hi Ajay, Many thanks for your prompt response. I did tried to reply immediately but to no avail.   I have less expertise knowledge about macros but I quite understand the logic of your suggested code. However, it doesn't seem to work.…"
Jun 30, 2012
Ajay replied to Success's discussion How to use 'do loops' for ranges in SAS? in the group SAS Network
"Do you know how to write a macro? Something along these lines: %macro bin; data a;set a;if missing(totprice) then vband= .;else if totprice<= 0 then vband= 0;%do i = 1 %to 20000;else if totprice<= %eval(&i. * 5000) then vband=…"
Jun 29, 2012
Success added a discussion to the group SAS Network

### How to use 'do loops' for ranges in SAS?

Please may I kindly seek your input in solving a problem in SAS. I want this done asap, hope someone can response on time. Essentially, I want to group a variable in different ranges, with incremental value of 5000. So, the iteration, if done manually, will take about 20,000 entries and thus I am trying to adopt a clever way to automate this. I am sure either some do loops; array or iterative do- statement can do this. Here is an example: if 5000 <= totprice <= 10000 then vband=1;else if…See More
Jun 29, 2012
"  This is appreciated and acknowledged with thanks. I'm indeed grateful for your insight, advice & contributions. I really hope the transition works well for me on time. At the moment, my current responbilities evade me the…"
May 2, 2012
"Every situation is unique, but I would say the odds are in your favor.    Some things to consider in your govt time:  acquiring OR technical skills in different methods of data solicitation and model structuring, getting an MBA in…"
Apr 30, 2012
Success added a discussion to the group Operations Research

### Career Transition in OR from public to private sector? What are my chances?

Hi all. I will really appreciate if you can offer me sincere advice & share your experiences. I had master degree in Operations Research and am lucky to get a job as OR Analyst within Central Government. I am keen to know what my career prospects are especially if I am interested in switching to the private sector later on in my career. Apparently, the skills are transferable, however employers are often keen about industry experience. So, I am really pleading for your expert' opinions on…See More
Feb 29, 2012

## Profile Information

Field of Expertise:
Business Analytics, Predictive Modeling, Data Mining, Operations Research, Econometrics, Statistical Programming, Statistical Consulting
Years of Experience in Analytical Role:
5
Professional Status:
C-Level
Interests:
Finding a New Position, Networking
What is your Favorite Data Mining or Analytical Website?
http://www.sas.com
How did you find out about AnalyticBridge?
Online