From the course: SAS Essential Training: 1 Descriptive Analysis for Healthcare Research
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Tricks in Excel - SAS Tutorial
From the course: SAS Essential Training: 1 Descriptive Analysis for Healthcare Research
Tricks in Excel
- [Instructor] We are going to start this chapter by revisiting our completed categorical table one. This spreadsheet is familiar and is in your exercise files for this movie. It's named Categorical_Desc Tbl_v4_Complete. This is the same one we've been working with. What I want to show you in this movie is how to make those Excel formulas that display those yellow cells off to the right so nice. Let's click on cell C2 and look at the formula. See the formula right here? Let's go break this down. As you can see, I reproduced the exact formula on the slide. Just to remind you, I put how the cell is currently displayed in the upper right corner of the slide. As you can see the formula starts with an equals because all Excel formulas start that way. Next, you'll see that we refer to cell H2, which is from column H, the All n column and on the same row as C2. After that, you'll see an and sign, more formally called an ampersand. In Excel, the ampersand concatenates the values to which we…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.