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: 
Sirisha1520
‎04-16-2022
  • 8 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Sas step run time

by Calcite | Level 5 in SAS Programming
‎04-14-2022 12:11 PM
‎04-14-2022 12:11 PM
Its a mainframe job using Ps file having few char and date columns around 15 variables with record length 80. ... View more

Sas step run time

by Calcite | Level 5 in SAS Programming
‎04-14-2022 08:20 AM
‎04-14-2022 08:20 AM
Hi all, I have a sas code and it reads input file with 4crores records, takes around 66.07 cpu seconds. Is there any way to reduce run time for reading large input files? Thanks, Sirisha ... View more

Re: Sas query to get highest 3 rows for date

by Calcite | Level 5 in SAS Programming
‎09-16-2021 04:18 AM
‎09-16-2021 04:18 AM
Yessss ... View more

Re: Sas query to get highest 3 rows for date

by Calcite | Level 5 in SAS Programming
‎09-15-2021 11:37 PM
‎09-15-2021 11:37 PM
I was trying to explain this. Policy Date Plan 01 20210101 B 01 20210101 A 01 20210201 C 01 20210301 C O/p expected: 01 20210101 B 01 20210201 C 01 20210301 C ... View more

Re: Sas query to get highest 3 rows for date

by Calcite | Level 5 in SAS Programming
‎09-15-2021 11:34 PM
‎09-15-2021 11:34 PM
Policy Date Plan 01 20210101 B 01 20210101 A 01 20210201 C 01 20210301 C O/p expected: 01 20210101 B 01 20210201 C 01 20210301 C ... View more

Re: Sas query to get highest 3 rows for date

by Calcite | Level 5 in SAS Programming
‎09-15-2021 04:37 PM
‎09-15-2021 04:37 PM
I tried rank but that was giving 1.2, 2.5 , 4.5… so again causing duplicates as i have multple rows for policy with same effective date. Also i have sorted the file for descending order in date due to which taking count less than 3. I need first 3 records for policy with different date. Example below: 0120210101 B 0120210101 A 0120210201 C 0120210301 C O/p expected: 0120210101 B 0120210201 C 0120210301 C ... View more

Sas query to get highest 3 rows for date

by Calcite | Level 5 in SAS Programming
‎09-15-2021 02:36 PM
‎09-15-2021 02:36 PM
I have a requirement to get highest 3 rows for respective policy and effective date. Key is policy and effective date. am trying using group by clause having count(*) <=3, but its avoiding rows having more than 3 in input file. Please suggest how to write query ... View more

Re: How to combine year and month columns into one column

by Calcite | Level 5 in SAS Programming
‎07-21-2021 09:42 AM
‎07-21-2021 09:42 AM
I have current date taking from DATE() and want to conert it to MMYYYY format. How do I combine these two? I tried substr and string but thats not working as expected? ID Year Month Date (this is what I want) 001 2021 07 072021 Thanks in advance! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎04-16-2022 02:11 AM
Quick links