BookmarkSubscribeRSS Feed
Saikiran_Mamidi
Obsidian | Level 7

Data have;

input id;

cards;

-1

-2

-3

10

20

30

;

run;

 

sum of nagative values in positive varible

sum of positive values in  negative variable

like below

positive      negative

60                  -6

 

3 REPLIES 3
PaigeMiller
Diamond | Level 26
Data have;
input id;
if id<0 then negative+id;
else if id>0 then positive+id;
cards;
-1
-2
-3
10
20
30
;
run;

You have negative ID numbers?

--
Paige Miller
yabwon
Amethyst | Level 16

Just for fun 🙂

Data have;
input id;
negative + (id<0)*id;
positive + (id>0)*id;
cards;
-1
-2
-2
10
20
30
;
run;

Bart

_______________
Polish SAS Users Group: www.polsug.com and communities.sas.com/polsug

"SAS Packages: the way to share" at SGF2020 Proceedings (the latest version), GitHub Repository, and YouTube Video.
Hands-on-Workshop: "Share your code with SAS Packages"
"My First SAS Package: A How-To" at SGF2021 Proceedings

SAS Ballot Ideas: one: SPF in SAS, two, and three
SAS Documentation



Ksharp
Super User

Just for fun.

 

Data have;
input id;
cards;
-1
-2
-3
10
20
30
;
proc sql;
select (select sum(id) from have where id>0) as positive,
       (select sum(id) from have where id<0) as negative
from have(obs=1);
quit;
How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 3081 views
  • 2 likes
  • 4 in conversation