VLOOKUP in MS Excel H ello and welcome back to Learn Java. It's been very long since I wrote my last post. This post will give you a short and simple tutorial on using VLOOKUP in MS Excel. Verticle Lookup or VLOOKUP is a function in MS Excel that helps a user look for a specific value in a column based on another particular value in the first column. A simple example: Your boss asks you to find the price of a food item based on its name. Syntax: VLOOKUP(the value you want to look up, where you want to look for it(array/column/table), the column number the value is in, return an approximate or exact match) Let's try to understand it more clearly: Here's a little data set containing a table of my favourite food items. Step 1: Select a specific cell/text value you would like to search for in the given table/data set. Here, we are looking for the price of Pizza, so we use cell value "Pizza" which is also cell reference A3. We are making sure to use a cell value/re
Hello and welcome back to Learn Java! It's been a pretty long time since my last post. This post will give you a short and simple tutorial on how to use a PRINT statement in SAS. PRINT is a procedure in SAS(previously known as Statistical Analysis System). PRINT procedure is used to display the contents of the data sets in a readable tabular form with well organized rows and column. In SAS, rows are also known as variables, and columns are also referred to as observations. Let's see how to use PRINT in SAS: Step #1. Open your data set in SAS Studio. Step#2. Open your data set. Step #3. Open a new SAS Program. Step #4. Write the following code in your SAS Studio: data MaleFemale; infile '<path of your data set file>'; input Gender $ Age Height Weight; run; proc PRINT data=MaleFemale; run; Step #5. Click Run button. Step #6. Under RESULTS tab, you will see your data set in a well readable tabular form. I hope you found this post useful and interesting. For more u