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: 
octrout
‎04-20-2019
  • 6 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: sum two columns from two tables

by Calcite | Level 5 in SAS Programming
‎05-02-2017 11:27 PM
‎05-02-2017 11:27 PM
How do I subtract instead of sums ? Thanks !    /* Increment the sums and copy results back to NUM_A and NUM_B */ do I=1 to dim(sums); sums{i}+nums{I}; nums{I}=sums{I}; end;   ... View more

Re: sum two columns from two tables

by Calcite | Level 5 in SAS Programming
‎05-02-2017 04:23 PM
‎05-02-2017 04:23 PM
Hi, Can this be done in data step ? ... View more

Re: replacing value using array or macro

by Calcite | Level 5 in SAS Programming
‎04-10-2017 04:03 PM
‎04-10-2017 04:03 PM
Hi,    I have about 60 variables that need to replace with values from one variable. This would be an example data set need to replace c,d,e,f,g with values from B.  Thanks !  data have; input A $ B C $ D E F G ; datalines; CA 1 1 1 20 7 10 CA 2 B 1 2 5 18 CA 3 B 9 3 5 18 CA 4 B 8 3 3 7 CA 6 R 2 4 2 6 NV 1 B 1 4 1 9 NV 2 B 1 4 1 10 NV 3 B 1 5 7 18 NV 4 B 1 5 4 8 NV 5 B 1 5 4 7 NV 6 B 1 5 6 8 NV 1 R 4 5 7 9 NV 2 R 6 5 8 10 ; run;     ... View more

Re: replacing value using array or macro

by Calcite | Level 5 in SAS Programming
‎04-10-2017 02:49 PM
‎04-10-2017 02:49 PM
Thanks for the reply. What if i have many variables to replace values ? ... View more

replacing value using array or macro

by Calcite | Level 5 in SAS Programming
‎04-10-2017 02:28 PM
‎04-10-2017 02:28 PM
Hi, I would like to replace values in C and D with value from B. Can anyone help to create code using array or macro ? Thank you so much ! data have; input A $ B C $ D ; datalines; CA 1 1 1 CA 2 B 1 CA 3 B 9 CA 4 B 8 CA 6 R 2 NV 1 B 1 NV 2 B 1 NV 3 B 1 NV 4 B 1 NV 5 B 1 NV 6 B 1 NV 1 R 4 NV 2 R 6 ; run; ... View more

computing sum and average by every nth row

by Calcite | Level 5 in SAS Programming
‎04-10-2017 12:44 AM
‎04-10-2017 12:44 AM
Hi, I would like to compute sum ( bal_rev = R ) and average (bal_rev = B) by every 3 period for each state.  Could you please help ? Thanks !  data have; input State $ Period Bal_Rev $ AMOUNT; datalines; CA 1 B 1464.48 CA 2 B 1275.81 CA 3 B 943.28 CA 4 B 849.82 CA 5 B 752.29 CA 6 B 661.56 CA 1 R 4.86 CA 2 R 4.86 CA 3 R 4.3 CA 4 R 3.57 CA 5 R 3.19 CA 6 R 2.97 NV 1 B 1047.84 NV 2 B 1045.54 NV 3 B 1092.74 NV 4 B 1110.41 NV 5 B 1134.34 NV 6 B 1105.86 NV 1 R 4.91 NV 2 R 6.09 NV 3 R 6.8 NV 4 R 5.84 NV 5 R 7.22 NV 6 R 10.16 UT 1 B 9856.37 UT 2 B 9825.48 UT 3 B 9701.09 UT 4 B 9497.63 UT 5 B 9448.09 UT 6 B 9293.51 UT 1 R 13.09 UT 2 R 12.7 UT 3 R 11.35 UT 4 R 8.14 UT 5 R 16.72 UT 6 R 16.19 ; run; data want;; set have; if bal_rev ='B' then do; /* average value for every 3 period for each state */ end; if bal_rev = 'R' then do; /* sum value for every 3 period for each state */ end; run;   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎04-20-2019 12:07 AM
Quick links