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: *

  • Users: mikeymay
  • Content: Threads
  • Order by date
  1. mikeymay

    Using renamed variable labels in PDF output

    have used the 'Label' commmand in a datastep to rename some variable names. I then want to output this dataset to a PDF file but the PDF retains the old label names. I have also triend using the 'Label' command in the Proc Print in the ODS code, but again this doesn't seem to work..... Thanks
  2. mikeymay

    Substr problem

    I am trying to use the following code where Region1 is a string variable RegLen = length(Region1); if substr(Region1,RegLen-7,8) = "Division" then Region2 = cat(Region1," Support"); For some reason this won't work and the error occures at 'RegLen-7' in the substr function. when I replace...
  3. mikeymay

    Trim data by x characters

    I have a dataset that holds a variable with a prefix code prior to the description. I want to trim the variable by the number of characters the prefix code has but the prefix code can be 4, 5, 6, 7 or 8 characters long. Is there a way of trimming the data using a procedure? Thanks
  4. mikeymay

    Exponential calculation

    am trying to perform the following Excel function in a SAS data step =0.3751*(31640/5/60)^-0.4988 Result = 1,162.12 But SAS doesn't like the following part of the calculation when I try to duplpicate '^-0.4988' Any ideas of how I can duplicate the calculation? Thanks
  5. mikeymay

    Same variable name in 2 programs

    I have 2 programs that have pretty much the same sets of code in each one, but each one uses to different tables/datasets to perform the same calculations. There is a point in each set of programs where they need to pull a resulting variable from a table/dataset from the other program, but...
  6. mikeymay

    Is there similar SAS code???

    Is there similar code that performs the 'Select Case' function as per VB (Visual Basic)? In VB this is useful to use instead of multiple nested 'If' statements. Have a need for a similar thing now in SAS.......
  7. mikeymay

    Calculation within a loop

    I have a procedure that loops through 2 sets of arrays and creates another by performing a calculation - data New_Reg_Meas_Vol_Workload (drop=T_ACL--SL_WTG_BB SL_WTG_VOL--SL_FWO_VOL); merge lookup.Unit_Times_Transpose(in=UnitTimes) New_Reg_Meas_Vol(in=MeasVols); by Jurisdiction; if UnitTimes and...

Part and Inventory Search

Back
Top