HI,  My current programming job will be ending.  The company is closing down. I may be doing some freelance work, but I've always had a work computer, so I'm not sure what I should look for in a new computer.  Any suggestions? thanks, Diane ... View more

Hi, I took the SAS 9.4 Base Certification practice exam.  Below are the steps for question 13. This project will use data set cert.input36. At any time, you may save your program as program36 in cert\programs. Write a SAS program that will clean the data in cert.input36 as follows: Step 1: create a temporary data set, cleandata36. In this data set, convert all group values to upper case. Then keep only observations with group equal to 'A' or 'B'. Step 2: Determine the MEDIAN value for the Kilograms variable for each group (A,B) in the cleandata36 data set. Round MEDIAN to the nearest whole number. Step 3: create results.output36 from cleandata36 Ensure that all values for variable Kilograms are between 40 and 200, inclusively. If the value is missing or out of range, replace the value with the MEDIAN Kilograms value for the respective group (A,B) calculated in step 2. How many observations are in results.output36? The original dataset had 5000 observations. My answer was   4897 observations. The practice exam has 4992 observations for the answer. I can't figure out why there is a 95 observation difference.   I did answer the second question regarding the median correctly. Thanks for your help.     I used the following code: data cleandata36; set cert.input36; group = upcase(group); where group in ('A' 'B'); run; proc means data=cleandata36 median maxdec=0; class group; var kilograms; run; data results.output36; set cleandata36; if Group = 'A' and kilograms lt 40 or kilograms gt 200 then kilograms = 79; if Group = 'B' and kilograms lt 40 or kilograms gt 200 then kilograms = 89; run; proc means data=results.output36 maxdec= 2 min max mean median n; class group; var kilograms; run; The answer code is: data work.cleandata36;   set cert.input36; group=upcase(group); if group in ('A','B'); run; proc means data=work.cleandata36 median;   class group;   var kilograms; run; data results.output36;   set cleandata36;   if Kilograms < 40 or Kilograms > 200 then do;     if group='A' then kilograms=79;     else kilograms=89;   end; run; proc contents data=results.output36;     ... View more

Hi, I'm using SAS Enterprise Guide version 8.3. Below is t I have two data sets. One list is of teams. There are over 300 teams.  One dataset list the teams and the dollar amount they raised over the past 19 months. The other spreadsheet lists the same teams and the number of members they had each of those 19 months.  I was able to combine the two datasets into one so it has the following columns: Team ID Team Name Month 1 amount raised (The variable is name is 202101.  This stands for the year and month YYYYMM  ) Month 2 amount raised (and on for 19 months) (The variable names are  202102 -202210 ) Number of members month 1  (The variable name is Jan2021) number of members month 2 (The variable name is Feb2021)0 and on for 19 months.   I would like to calculate how much as raised each month on a per member basis for each team. This variable would be per member per month (pmpm) So I would be adding another 19 columns.   I started out with the following, but I then I wasn't sure what to do or even if an array is the best way to calculate the per member per month over the 19 months (Jan 2021 through August 2022) data Amt_Raised_A; set  Amt_raised_B; array pmpm_array pmpm1 - pmpm19; do i=1 to 19; pmpm =   Any suggestions?  Thanks so much, Diane                 ... View more