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!

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

Recent content by krispi

  1. krispi

    Excel 2007 - How to find last value or record in a row

    Wow - XLHelp that's impressive. Wish I knew how it works!
  2. krispi

    How come I never get same result from the same code?

    I think you'll need to post the code Cosmid - not saying I can solve your problem, but there are some brainy folks in here...!!!
  3. krispi

    Segmentation Violation In Task [FORMAT ]

    As a generic 'handy hint', the following code will reset a SAS session which has become corrupted and keeps erroring out: ;;;; * ( ( %* ' " ) ) */; %mend; run cancel; Cheers, Chris
  4. krispi

    Creating a report using SAS

    Not my query, but I'll give you a star for the neat solution! That's going to be useful to me in the future.
  5. krispi

    subtract values of day2 - day1

    Hi Bhanu. Not sure your dataset is structured too wonderfully, but this code will work providing your data is EXACTLY as you say - i.e. always having pairs of records where day is D-01 or D001 deprending on PRE- or POST- data data2; set data1; newvar=substr(hours,1,6); run; proc sort data =...
  6. krispi

    Excel: Selecting specific characters from data

    if the data's in cell A4: =LEFT(A4,3)&MID(A4,5,1) Cheers, Chris
  7. krispi

    Rolling Averages

    Intriguing question. I haven't tested this code, which I found here: http://www.science.gmu.edu/stat362/02f/sas12.htm but worth a try... %MACRO MovAve(ds,v,ln); %* This adds to the specified dataset, the moving average of the specified variable over a given length. The name of the...
  8. krispi

    how can the pop-up window be turned off automatically

    Hi If it's the SAS log that's filling up, the following link gives a few options to prevent the messages from appearing... http://support.sas.com/kb/5/888.html Cheers, Chris
  9. krispi

    Need help with sas printing procedure...

    Actually, thinking about it, a simpler way to get the same result would be to use proc sql, (no proc print required as sql output is automatically printed) - try this... proc sql; select variable1, variable2, etc from your_dataset where mod(monotonic(),100000)=0 ; quit;
  10. krispi

    Need help with sas printing procedure...

    Hi - I think you need to create an observation number on your source dataset before doing the proc print. Try a variation of this: data xx; set whatever; zz=_n_; run; proc print data=xx; where mod(zz,100000)=0; run;
  11. krispi

    Comparing variables in the same dataset

    Hi all - basics of the problem are as follows: I have a dataset with many records. Each contains 12 variables, representing the status of an account at the end of each month in a given year. Is there an easy way to compare these variables (without a lot of if - else statements). I need to...
  12. krispi

    Type Mismatch in Lookup Statement

    Doh! That'll be me trying to overcomplicate things (not for the first time...)[blush] Thanks Skip
  13. krispi

    Type Mismatch in Lookup Statement

    Thanks Skip.
  14. krispi

    Type Mismatch in Lookup Statement

    OK. The source dataset looks like this 1 10 50 2 10 10 3 20 60 4 10 10 5 20 10 6 10 70 7 10 40 8 30 30 9 20 10 12 10 10 It loops through fine until the value of IntLookUpValue hits 10, then the error is triggered at the statement If IsError(myVar =...
  15. krispi

    Type Mismatch in Lookup Statement

    Hi Skip thanks for the reply. However, I thought my code was already doing numbers 1 & 2 in your reply... Thanks again Chris
See more

Part and Inventory Search

Back
Top