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: 
Bananas
‎10-17-2021
  • 7 Posts
  • 2 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: How to add add up several categories

by Fluorite | Level 6 in New SAS User
‎10-17-2021 05:38 PM
‎10-17-2021 05:38 PM
Hi Paige, thank you. Sorry to be a bother, I'm just having a hard time actually seeing the totals of the rows individually. The code you gave me did work as the log said. I will figure out how to see it in the output. Thanks for your help again.  ... View more

Re: How to add add up several categories

by Fluorite | Level 6 in New SAS User
‎10-17-2021 04:12 PM
‎10-17-2021 04:12 PM
Hi, I appreciate anyone who is taking the time to help me. I'm trying to learn online.   That's just the name of my data table. I had to multiply each variable by a certain number so it was: DATA transform; set lab.food; chips= chips2 *4; sandwiches= sandwiches2 *4; fruit= fruit2 *9; run;   Then i used the below code to show the new table. proc print data=work.transform; run; That's where I got work.transform from. ... View more

Re: How to add add up several categories

by Fluorite | Level 6 in New SAS User
‎10-17-2021 03:21 PM
‎10-17-2021 03:21 PM
Hi,  would I still use the code below to see the new table. When i do this, it gives me the totals of the columns, not the rows.   proc print data= work.transform; sum candy chips fruit sandwiches; run; ... View more

How to add add up several categories

by Fluorite | Level 6 in New SAS User
‎10-17-2021 02:31 PM
‎10-17-2021 02:31 PM
I'm new to sas. I'm trying to do most of it myself but I'm having a little trouble. I want to total up four categories but for each individual value.  This was my code for totaling columns. I don't know how to total rows and I have like 5000 rows. Is it something similar to this?   proc print data=lab.data; sum candy; run;   What I have: Candy Chips Fruit Sandwiches 101.1 128 70 6 107.9 146 88 5 116.5 138 46 5 110.1 132 72 5 80.4 100 70 5 92.9 116 58 4 86.6 110 70 5   What I want: Candy Chips Fruit Sandwiches Total of everything eaten 101.1 128 70 6 305.1 107.9 146 88 5   116.5 138 46 5   110.1 132 72 5   80.4 100 70 5   92.9 116 58 4   86.6 110 70 5   ... View more

Re: How do I multiply a variable by a number.

by Fluorite | Level 6 in New SAS User
‎10-17-2021 11:22 AM
‎10-17-2021 11:22 AM
Hi Cynthia,    the proc print worked. Thank you. It says 4 because I was trying the same step on different categories.  One of the categories, I have to multiply by 4. Thank you again for your help. ... View more

Re: How do I multiply a variable by a number.

by Fluorite | Level 6 in New SAS User
‎10-17-2021 10:58 AM
‎10-17-2021 10:58 AM
This is what the log says. there is no output. Nothing happens.   NOTE: There were 8327 observations read from the data set LAB.NUTRITION. NOTE: The data set WORK.TRANSFORM has 8327 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.03 seconds   ... View more

How do I multiply a variable by a number.

by Fluorite | Level 6 in New SAS User
‎10-17-2021 10:35 AM
‎10-17-2021 10:35 AM
I have a data set with about 5000 values. I have 5 categories. Say one of the categories is weight. I need to multiply every value in the weight column by 8. How would I put in the syntax for that?   I tried: data transform; set lab.values; weight2= weight*4; run; But nothing happens. can anyone help me please? ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-17-2021 12:52 PM
Likes given to
View All
Quick links