Search results for query: *

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

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...

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

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

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...

Fantastic!! Makes much more sense now. Must remeber to keep taking off my VB head when looking at SAS in future. Again, many thanks :o)

Thanks for the code kdt82. I am a little confused by the following bits of code though length x $15; input val @@; cards; 1 2 3 4 5 6 7; Any chance you could give me a brief prompt for each one? Thanks

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.......

As a newbie with SAS I can sort of see what that codes does but did manage to resolve the issue by placing another if statement just after the first one. Performs the different calculation if i=4 and seems to do the trick!! Thanks for your help though :o)

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...