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: 
rohitdante16
‎06-14-2020
  • 6 Posts
  • 0 Likes Given
  • 0 Solutions
  • 1 Likes Received

Re: Finding duplicates

by Super User in SAS Programming
‎12-20-2019 10:42 AM
‎12-20-2019 10:42 AM
@sks521 wrote: Hi folks,   I have a data set on emergency healthcare use by children so one id can have multiple admission dates to emergency wards. My problem is same id with same admission date more than once.   So, I want to find out duplicates based on two variables; 'id' and 'admissiondate' and create a data set without duplicates but before I create a data set without duplicates I need to know how many duplicate entries I have in the data set for verification purposes.   Thanks S This will create a data set that has the id and admiisiondate with a count of how many duplicates when there are duplicates.   proc freq data=have noprint; tables id*admissiondate /out=work.counts (drop=percent where=(count>1)) ; run; ... View more

Re: SAS sql efficiency

by Fluorite | Level 6 in SAS Procedures
‎12-20-2019 05:50 AM
‎12-20-2019 05:50 AM
In general i would say instead of using a single we could accomplish the same in following steps:   1. Take dump of Table A using proc sql into SAS dataset. 2. Do the same for Table B   Load the Table B onto a proc format and apply that to table A.   This should optimize the code.   Most often the slowness of a query would depends on the connection driver either ODBC/Oracle and so on.  So the throught process should ideally be to use a method to take a dump and use the other to optimize results, so i would say use the SQL code to pull the data and not join and use SAS formatting to join the data. if it helps create use proc ds2 for parallel record processing. ... View more

Re: How to use proc report to provide row based descriptions?

by Super User in SAS Procedures
‎04-24-2019 09:53 AM
‎04-24-2019 09:53 AM
I think this is what you want to do.  proc report data=have spanrows; column group col1 col2; define group / group ' '; run; If so you need to add the variable to the data BEFORE the proc report step. You could use a view if you want. data have; input col1 $ col2; datalines; a 1 b 2 c 3 ; run; data for_report / view=for_report ; set have; group='This is a test'; run; proc report data=for_report spanrows; column group col1 col2; define _all_ / display; define group / order ' '; run; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎06-14-2020 06:37 PM
Likes from
View All
Quick links