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: 
doofst
‎10-05-2018
  • 2 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: how do I sort a data set by 2 specific criterias in 2 seperate var...

by Calcite | Level 5 in New SAS User
‎10-03-2018 10:05 PM
‎10-03-2018 10:05 PM
The original excel file is formatted with the dates as follows: 2017-04-15 1:30 2017-04-15 2:50   Once I imported them into a sas data set they look like this: 15APR17:00:01:00   Now I used what you suggested and for all three the error message i'm receiving is the following: 831 where start_position=6008 and variable_2=:'30APR17'; ERROR: WHERE clause operator requires compatible variables. 832 run;     ... View more

how do I sort a data set by 2 specific criterias in 2 seperate variabl...

by Calcite | Level 5 in New SAS User
‎10-03-2018 09:16 PM
‎10-03-2018 09:16 PM
I have created a sas data named tables.Q3 from an excel file containing hundreds of thousands of observations. I would like to now extract specific observations that satisfy one condition in 1 variable and another condition in the other and print those data sets. I first sorted the data set by one variable using:   PROC SORT DATA=tables.Q3 OUT=tables.Q4; BY start_position; RUN; this produced a sas data set that sorted the start_code (which is a numeric) variable.   I want to now print from the dataset tables.Q4 a table that will only include those observations that satisfy start_position=5000 and variable 2 (which is a datetime variable in the form of DDMMMYYY HH:MM:SS) as one specific date (i.e 20OCT17).     Thanks in advance for the help.       ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-05-2018 12:39 PM
Quick links