Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. bbprakash

    subtract values of day2 - day1

    I haven't merged any datasets, this data is imported from another database where it is manually entered. This is actual data I need to work on. Kind regards, Bhanu
  2. bbprakash

    subtract values of day2 - day1

    Hi Guys, Thank you for your solutions but my question is bit weired now I want to make it clear. Under the colume Value:I want to subtract 1st row from 5th row, 2nd row from 6 th, 3rd from 7th, 4th from 8th. assume that there are no other columns (because hours are not always same). if you...
  3. bbprakash

    subtract values of day2 - day1

    S.No(num) day(char) hours char) value (num) 101 D-01 025:00 PRE 105 101 D-01 020:00 PRE 110 101 D-01 015:00 PRE 108 101 D-01 010:00 PRE 106 101 D-01 005:00 PRE 105 101...
  4. bbprakash

    use of substr for numerical values

    Thank you Mr. Chris. Could you please tell me the use of substr function for numerical values is it same as for charecters. Here is example data work.AreaCodes; Phonenumber=3125551212; Code='('!!substr(Phonenumber,1,3)!!')'; run; answer is ( 3).
  5. bbprakash

    how come length is 7 and answer is under 6

    Thank you Mr. Chris. Could you please tell me the use of substr function for numerical values is it same as for charecters. Here is example data work.AreaCodes; Phonenumber=3125551212; Code='('!!substr(Phonenumber,1,3)!!')'; run; answer is ( 3).
  6. bbprakash

    how come length is 7 and answer is under 6

    hai, I am a starter in SAS and while I was doing the following progrmme I found answer as 'length 7' and 'under 6'. I want explenation how it does. data fltaten; input jobcode $ salary name $; cards; FLAT1 70000 Bob FLAT2 60000 Joe FLAT3 30000 Ann ; run; data desc; set fltaten; if...

Part and Inventory Search

Back
Top