Get Just the Actual Number

luvscandy27 — Thu, 29 Oct 2020 14:28:20 GMT

I think I have a simple question however, I can not find the answer. My question is, I have to numeric variables that I am subtracting and I want the difference between those two variables without getting the negative sign. This is my code:

data diff;
	input score score_1;
	datalines;  		
	2 7
	6 8
	5 3
	5 9
;      
run; 

proc sql; 
	select*, (score-score_1) as score_diff
	from diff; 
quit;  

The output is

score	score_1	score_diff
2	7	-5
6	8	-2
5	3	2
5	9	-4

But I would like for the score_diff variable to be just 5,2,2,4. Could someone assist me with this please?

Re: Get Just the Actual Number

PeterClemmensen — Thu, 29 Oct 2020 14:29:51 GMT

Do this

data diff;
	input score score_1;
	datalines;  		
	2 7
	6 8
	5 3
	5 9
;      
run; 

proc sql; 
	select*, abs(score-score_1) as score_diff
	from diff; 
quit;

topic Get Just the Actual Number in SAS Programming

Get Just the Actual Number

Re: Get Just the Actual Number