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 Mike Lewis 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. lulumohca

    Proc Transpose Data transpose question

    I couldn't get picture link to work, here is what the data looks like: PL5 PL6 Date seats gross percent seats gross percent 08-Dec-2011 0 $0.00 5 0 $0.00 6 09-Dec-2011 0 $0.00 5 0 $0.00 6 10-Dec-2011 0 $0.00 5 0 $0.00 6 11-Dec-2011 0 $0.00 5 0 $0.00 6 12-Dec-2011 0 $0.00 5 0 $0.00 6...
  2. lulumohca

    Proc Transpose Data transpose question

    Hi, I am having a lot of trouble using SAS to transpose the data from an excel file. I have attached the file with the input worksheet and what I wanted to get in the output. If someone can help me with this using SAS or Excel, that would be great. It is taking me a long time to do it manually...
  3. lulumohca

    SAS chaning char variables to date

    Hi everyone, was hoping someone can help me with this in SAS: I have data in SAS like this: Obs Date Item1 Item2 Item3 1 _00853 1 3 5 2 _00901 124 24 2324 3 _00902 24 12 232 ... ... ... x _00952...
  4. lulumohca

    SAS programming help needed, time alignment

    Here is a better explaination of what I am trying to do: data test ; Input Week $ J05 F05 M05 A05 ; Datalines; product1 12 0 0 2 product2 0 0 0 4 product3 0 7 0 5 product4 0 10 9 8 product5 0 50 20 0 Run; Results: data result ; Input Week $ fristm secondm thirdm fourthm ; Datalines...
  5. lulumohca

    SAS programming help needed, time alignment

    Hi, if someone can help me with this it would be greatly appreciated. I have a data that looks like: jan-05 feb05 ... mar09 (by month along the columns) a b c d ... The problem is say variable a first get data at feb05 so before that it would have all zeros, all the different variables...
  6. lulumohca

    SAS grouping code help

    Hi, I am still having trouble with this code, beacuase this part: if last.product then do; if sum(of type1-type3) = 3 then output dset3; else if sum(of type1-type3) = 2 then output dset2; else if sum(of type1-type3) = 1 then output dset1; end; run; Is only adding the...
  7. lulumohca

    SAS grouping code help

    Thanks for the help! Now I have data that is like: product type count a 1 3 a 2 3 a 3 3 b 1 2 b 2 2 c 2 2 c 3 2 d 3 1 What I would like is to group these so I know what...
  8. lulumohca

    SAS grouping code help

    Hi, I am having trouble writing a code for this, say I have the following data: product type a 1 a 2 a 3 b 1 c 1 c 2 d 3 e 1 e 2 e 3 I want to make 3 data sets, 1st one only has products which has all 3 type (1, 2, 3) so that dataset will...

Part and Inventory Search

Back
Top