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: 
Tbell1
‎05-03-2021
  • 4 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Column totally empty after merge

by Calcite | Level 5 in SAS Programming
‎05-03-2021 03:15 AM
‎05-03-2021 03:15 AM
NOTE: There were 6320 observations read from the data set BTS201505. NOTE: There were 220 observations read from the data set WTHRDATA. NOTE: The data set BTS201505WTHR has 6245 observations and 42 variables. NOTE: DATA statement used (Total process time): real time 5.99 seconds cpu time 2.86 seconds ... View more

Re: Column totally empty after merge

by Calcite | Level 5 in SAS Programming
‎05-03-2021 02:56 AM
‎05-03-2021 02:56 AM
I removed the if subset but there was no difference, i still got empty columns for the merged dataset ... View more

Re: Column totally empty after merge

by Calcite | Level 5 in SAS Programming
‎05-03-2021 02:54 AM
‎05-03-2021 02:54 AM
There were no errors in the log but the output of the merged data did not return any values for the columns in the second dataset ... View more

Column totally empty after merge

by Calcite | Level 5 in SAS Programming
‎05-03-2021 01:29 AM
‎05-03-2021 01:29 AM
I am trying to merge two dataset of unequal rows but after merging i got completely empty data. The first dataset has 50 columns and 6320 rows while the second dataset has 5 columns and 220 rows. was trying to merge by a common variable but I got empty data after my merge. This is my code, what am i missing?   data BTS201505WTHR (drop=div:); merge BTS201505 WTHRDATA(keep= FlightDate PRCP SNWD SNOW TMAX TMIN); by FlightDate ; if Origin='ORD'; run ; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎05-03-2021 07:32 AM
Quick links