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: 
Sanchit
‎08-08-2016
  • 9 Posts
  • 2 Likes Given
  • 0 Solutions
  • 0 Likes Received

Difference between row values

by Fluorite | Level 6 in SAS Studio
‎08-07-2016 04:06 PM
‎08-07-2016 04:06 PM
Hi there!   I have a dataset where I want to calculate the difference between row values in order - difference between 1st and 2nd row,  3rd and 4th row. 5th and 6th row ......   Configuration       Retail_price            Month 1                           300                          1 1                           270                          12 2                           500                          1 2                           470                          12 3                           350                          6 3                           300                          12  4                           250                          7 4                           200                          12    Basically I want difference in retail prices for each configuration at the beginning and end.   Thanks for the help! ... View more

Re: Finding minimum distance between a set of coordinates

by Fluorite | Level 6 in SAS Studio
‎07-31-2016 05:48 PM
‎07-31-2016 05:48 PM
Thanks a lot Reeza. It worked! 🙂 -Sanchit ... View more

Finding minimum distance between a set of coordinates

by Fluorite | Level 6 in SAS Studio
‎07-30-2016 04:54 PM
‎07-30-2016 04:54 PM
Hi, I have a dataset like this: Lat Long 51.39824 -0.09366 51.52927 -0.04583 51.54182 0.038004 51.41895 -0.30561 51.59302 -0.06998 51.60087 -0.19474 51.55101 -0.13727 51.50019 -0.07006 51.48329 -0.02586 I need to determine the minimum distance between these set of coordinates. I know about a function geodist() to determine distance between 2 coordinates, but not sure how to loop over through this set from the table.   Greatly appreciate your help. Thanks! ... View more

Linear Regression : Macro Basics

by Fluorite | Level 6 in SAS Programming
‎07-25-2016 02:24 PM
‎07-25-2016 02:24 PM
A macro to run a simple linear regression with dependent and independent variables as macro parameters.   Dataset: sashelp.cars Dependent variable =msrp; Independent variables = enginesize, cylinders, horsepower ... View more

Conditional Iteration : Macro

by Fluorite | Level 6 in SAS Programming
‎07-25-2016 02:20 PM
‎07-25-2016 02:20 PM
Identify words in a list supplied as macro parameter. If no word is found, display a message. ... View more

Re: SAS Macro | Iterative Processing

by Fluorite | Level 6 in SAS Studio
‎06-29-2016 06:35 AM
‎06-29-2016 06:35 AM
Many Thanks! ... View more

SAS Macro | Iterative Processing

by Fluorite | Level 6 in SAS Studio
‎06-29-2016 05:02 AM
‎06-29-2016 05:02 AM
Need help with the following problem statement:   A macro to create the following dataset var_1 var_2 ........var_9 var_10 1 4 ........81 100 1 8 ......729 1000   Thanks in Advance! ... View more

Re: Creating a SAS table from Excel file with data in sheet1 and Varia...

by Fluorite | Level 6 in SAS Procedures
‎06-07-2016 02:21 PM
‎06-07-2016 02:21 PM
Thanks for the help! 🙂 ... View more

Creating a SAS table from Excel file with data in sheet1 and Variable ...

by Fluorite | Level 6 in SAS Procedures
‎06-07-2016 08:52 AM
‎06-07-2016 08:52 AM
Hi SAS coders,   I'm a new learner of SAS, trying to create a SAS data set from excel file where data is in sheet 1 and Variable Labels are in sheet 2 in the following format:-   SHEET1:                                                           SHEET 2        Like this there are 20 columns and their variable labels. Is there a way I can create a data set without manually entering the Variable Labels using Label command? (Using SAS studio)     ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎08-08-2016 07:10 AM
Likes given to
View All
Quick links