topic Re: Compute new cm variable in SAS Programming

Compute 4 new variables

tmjeffer — Tue, 10 Apr 2018 16:58:05 GMT

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;

Re: Compute 4 new variables

Reeza — Tue, 10 Apr 2018 17:02:48 GMT

AveBP = DBP + 1/3SBP - DBP;

That's probably not what you want, and it's where SAS generated the error.

Second, review how you're converting height. Would you expect height in cm to be lareger than height in inches? Your conversion is likely backwards.

@tmjeffer wrote:

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;

Re: Compute 4 new variables

tmjeffer — Tue, 10 Apr 2018 20:56:37 GMT

I put parentheses around (SBP -DBP) First and couldn’t get it to read either.

Re: Compute 4 new variables

Reeza — Tue, 10 Apr 2018 21:28:04 GMT

Post your new code and log, and remember order of operations so make sure you have parenthesis where you need them.

@tmjeffer wrote:
I put parentheses around (SBP -DBP) First and couldn’t get it to read either.

Re: Compute 4 new variables

tmjeffer — Wed, 11 Apr 2018 13:08:45 GMT

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;

Re: Compute 4 new variables

Reeza — Wed, 11 Apr 2018 16:00:17 GMT

I'm assuming this works now?

Re: Compute 4 new variables

tmjeffer — Wed, 11 Apr 2018 16:35:37 GMT

Yes it does. Thanks for all your help!

Re: Compute new cm variable

heatherjae15 — Sun, 27 Oct 2019 00:22:02 GMT

Hello,

I need to convert inches to cm in some of my data, it is a mixed bag of inches and cms.

my variables

comor_9hgtunit_decode = says whether it is in inches or cm

comor_9hgtunit gives 1 for cm and 2 for inches

comor_9hgt = measurements in inches or cms

Here is how I approached it.

data demo2;
set mergedata;
If comor_9htunit then do;
height_cm = comor_9ht/2.54;
end;
else do;
height_cm =comor_9ht;
end;
run;

I am getting the error code WARNING: The data set WORK.DEMO2 may be incomplete. When this
step was stopped there were 0 observations and 3
variables.

Re: Compute new cm variable

ScottBass — Mon, 28 Oct 2019 06:50:25 GMT

If comor_9htunit then do;

Is this statement true, or false, when comor_9htunit=1?

Is this statement true, or false, when comor_9htunit=2?

Re: Compute new cm variable

Reeza — Mon, 28 Oct 2019 17:09:13 GMT

I posted a fairly detailed explanation of the issue in one of your other posts. Please DO NOT ask the same question in multiple places and this thread is a year + old.

Go check your other questions and posts and you'll find the correct answer and explanation.
https://communities.sas.com/t5/SAS-Programming/Create-new-variable-based-on-values-rules-in-other-columns/m-p/599594#M173103

Re: Compute 4 new variables

heatherjae15 — Mon, 28 Oct 2019 17:19:40 GMT

Thank you