cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
tmjeffer
‎10-23-2019
  • 8 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Conditional Processing Sum

by Calcite | Level 5 in New SAS User
‎04-22-2019 01:49 PM
‎04-22-2019 01:49 PM
PaigeMiller, I do thank you for all of your help. There's really no need for the condescending tone when helping people. I'm manipulating variables in an existing data set (used a set statement). There's nothing else to see other than the PROC TABULATE.    PROC TABULATE DATA = C_METHOD MISSING; CLASS HOME DELIVERY CF_TOTAL ; TABLE(HOME ALL),DELIVERY CF_TOTAL ALL *N*F=COMMA10./RTS=30 PRINTMISS MISSTEXT = "0"; KEYLABEL ALL= "Total" N=' ' ; LABEL HOME = 'Cities' DELIVERY = 'Method of Delivery'; RUN; ... View more

Re: Conditional Processing Sum

by Calcite | Level 5 in New SAS User
‎04-22-2019 01:28 PM
‎04-22-2019 01:28 PM
I'm trying to create a variable, CF_Total, to sum Delivery 1 and Delivery 2 only. In the output, the CF_Total variable is split into two groups (0 and 1) and I'm not sure why that is happening either.  Please see attached. ... View more

Re: Conditional Processing Sum

by Calcite | Level 5 in New SAS User
‎04-22-2019 01:11 PM
‎04-22-2019 01:11 PM
CF_Total should only be the sum of Delivery 1 and 2.  ... View more

Conditional Processing Sum

by Calcite | Level 5 in New SAS User
‎04-22-2019 12:01 PM
‎04-22-2019 12:01 PM
I am trying to create a new variable CF_TOTAL that is equal to Delivery '1' + Delivery '2'. See sample code below:   IF CAR = '4' AND FOOD = '2' THEN DELIVERY = '1';  ELSE IF CAR = '4' AND FOOD = '1' THEN DELIVERY = '2';  ELSE IF CAR IN ('1','2','3') AND FOOD = '1' THEN DELIVERY = '3';  ELSE IF CAR IN ('1','2','3') AND FOOD = '2' THEN DELIVERY = '4';  ELSE IF CAR = '9' OR FOOD = '9' THEN DELIVERY = '5';  CF_TOTAL = SUM(DELIVERY IN ('1','2'));   The problem that I am running into is the CF_TOTAL variable is being split into two groups (0,1) in my table (using proc tabulate) - (0) sum of all other 'Delivery' ; (1) sum of 'Delivery' 1 and 2.  ... View more

Re: Compute 4 new variables

by Calcite | Level 5 in SAS Programming
‎04-11-2018 12:35 PM
‎04-11-2018 12:35 PM
Yes it does. Thanks for all your help! ... View more

Re: Compute 4 new variables

by Calcite | Level 5 in SAS Programming
‎04-11-2018 09:08 AM
‎04-11-2018 09:08 AM
Listing of Prob2   Obs ID Height Weight SBP DBP Wtkg HtCm AveBP HtPolynomial123 001 68 150 110 70 68.182 172.72 83.333 480896.0 002 73 240 150 90 109.091 185.42 110.000 594183.5 003 62 101 120 80 45.909 157.48 93.333 365180.0       /*2 Given the programs here, add the necessary statements to compute the four new variables. */ *a /Weight in kilograms (1kg = 2.2 pounds). Name this variable WtKg/; *b /Height in centimenters (1 inch = 2.54 cm). Name this variable HtCm. */ ; *c /Average blood pressure (call it AveBP)equal to the diastolic blood pressure plus one-third difference of the systolic blood pressure minus the diastolic blood pressure. */; *d /A variable (call it HtPolynomial) equal to 2 times the height squared plus 1.5 times the height cubed. */; DATA Prob2; INPUT ID $ Height /* in inches */ Weight /* in pounds */ SBP /* systolic B P */ DBP /* diastolic B P */; Wtkg = Weight/2.2; HtCm = Height*2.54; AveBP = DBP + 1/3 *(SBP - DBP); HtPolynomial = 2 * (Height)**2 + 1.5 * (Height)**3; DATALINES;   001 68 150 110 70 002 73 240 150 90 003 62 101 120 80 ; TITLE "Listing of Prob2"; PROC PRINT DATA = Prob2; Run;   　   ... View more

Re: Compute 4 new variables

by Calcite | Level 5 in SAS Programming
‎04-10-2018 04:56 PM
‎04-10-2018 04:56 PM
I put parentheses around (SBP -DBP) First and couldn’t get it to read either. ... View more

Compute 4 new variables

by Calcite | Level 5 in SAS Programming
‎04-10-2018 12:58 PM
‎04-10-2018 12:58 PM
I cannot figure out where I am going wrong in the problem below. I know it's something I'm overlooking.   /*2 Given the programs here, add the necessary statements to compute the four new variables. */ *a /Weight in kilograms (1kg = 2.2 pounds). Name this variable WtKg/; *b /Height in centimenters (1 inch = 2.54 cm). Name this variable HtCm. */ ; *c /Average blood pressure (call it AveBP)equal to the diastolic blood pressure plus one-third difference of the systolic blood pressure minus the diastolic blood pressure. */; *d /A variable (call it HtPolynomial) equal to 2 times the height squared plus 1.5 times the height cubed. */; DATA Prob2; INPUT ID $ Height /* in inches */ Weight /* in pounds */ SBP /* systolic B P */ DBP /* diastolic B P */; Wtkg = Weight/2.2; HtCm = Height/2.54; AveBP = DBP + 1/3SBP - DBP; HtPolynomial = 2 *Height**2 + 1.5 *Height**3; DATALINES;   001 68 150 110 70 002 73 240 150 90 003 62 101 120 80 ; TITLE "Listing of Prob2"; PROC PRINT DATA = Prob2; Run;   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-23-2019 12:10 PM
Quick links