sas data manipulation

  1. M

    Performing multiple t-tests on different variables between the same two groups

    Hey everyone I would like to perform multiple t test on different variables ( let's say A B C D E ) in two different groups ( 1 2 ) and test if the means, variance, kurtosis is significantly different between A1 and A2, B1 and B2 etc. How do you think I should go about this in R or SAS ...
  2. V

    Selecting Specific Entries

    Dear SAS Users, Hello SAS Users...I have two columns an sample of which is shown below.... ID NUMBER 35 1015 35 1015 35 1015 36 2014 36 2014 41 5689 41 5689 42 5689 56...
  3. I

    SAS help regarding putting observation Together. Please help

    Here is the raw data: name var1 var2 var3 startdate enddate jack x y z 01jan2012 01jan2012 jack x y z 02jan2012 02jan2012 jack x y z 03jan2012 03jan2012 jack x y z 04jan2012 04jan2012 jack x y...
  4. M

    Infile for non-standard data

    I have a messy file (does not line up in columns), where some of the columns are tab delimitated and some are comma. My problem with the data set is reading the files with variable lengths 12 Stephen Cole, 33, Columbia, MO 5 Dave Anderson, 25*, Concord, OH The first...
  5. M

    Base SAS Programing: Calculating KPIs Over Different Time Ranges

    Hi all. I am trying to calculate values for KPIs over certain time ranges – Response Rate, Conversion Rate and Yield. I need to use SAS to do this. This is the desired output I’m looking for: MTD/YTD Dates Tactic Response Rate Conversion Rate Yield Rate Last 3 Month Performance...
  6. S

    how to combine rows of paired data into one row

    Hi, I have data that is structured like the following: location team score away ny 100 home la 80 away chi 95 home det 85 But I would like to transform the pairs of data to be structured like this: away_team...