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: 
MarkWik
‎02-14-2019
  • 114 Posts
  • 25 Likes Given
  • 0 Solutions
  • 7 Likes Received

Re: Finding the earliest date in PROC SQL

by Quartz | Level 8 in SAS Data Management
‎02-14-2019 11:43 AM
‎02-14-2019 11:43 AM
why the first 4 of responsedate are missing?   should those be filled with the next >datetime value of onlinedate   for example,   2527 1109 11JAN19:19:00:03 11JAN19:18:12:47 14JAN19:11:38:58 ... View more

Re: Adding descending sequence number

by Quartz | Level 8 in New SAS User
‎02-08-2019 12:04 PM
‎02-08-2019 12:04 PM
@novinosrin   If for anything or anything at all you draw/will draw admiration for is your incredible understanding that is noticeable in many of your responses. The speed at which you have progressed doesn't seem like somebody learned so much so quickly. Very nice!!! ... View more

Re: culmulative sum by group using Proc SQL

by Quartz | Level 8 in New SAS User
‎11-30-2018 01:11 PM
‎11-30-2018 01:11 PM
As a matter of fact, we the community including you can build up supportive arguments to challenge your boss/team/peers who may have assigned you such tasks with real legitimate reasons ... View more

Re: culmulative sum by group using Proc SQL

by Quartz | Level 8 in New SAS User
‎11-30-2018 01:09 PM
‎11-30-2018 01:09 PM
May we know what is that some reason that precludes the usage of datastep/other summary procs assuming you have a commercial or student SAS software version.      @sameer112217 wrote: For some reason I have to use PROC SQL to do cumulative sum for the number variables but I am unable to do it using Proc SQL       ... View more

Re: continuous enrollment with gap

by Quartz | Level 8 in SAS Programming
‎11-09-2018 04:55 PM
‎11-09-2018 04:55 PM
You want to keep one period per id reflecting only the first period  Then what is this?   3 01JAN2015 14FEB2015 3 15FEB2015 30APR2015 ... View more

Re: Performance measurement

by Quartz | Level 8 in SAS Data Management
‎09-28-2018 11:51 AM
‎09-28-2018 11:51 AM
Plus, I do not understand the relevance in the question. The sort procedure vs dd command. The purposes in itself doesn't quite make sense to achieve a supposedly same goal. And where's the question of performance?  Am I missing something ... View more

Re: How to create event month?

by Quartz | Level 8 in SAS Programming
‎09-15-2018 12:20 PM
‎09-15-2018 12:20 PM
Your input sample and the required output sample is not clear. You can post a better and clearer one, and of course explaining the logic along with it ... View more

Re: Deleting Variables with No Observations from Dataset with 4000+ Va...

by Quartz | Level 8 in New SAS User
‎09-12-2018 01:34 PM
‎09-12-2018 01:34 PM
@sabotaged Welcome to SAS forum. Would be nice to follow if you could state your objective/requirement before your code like My objective is to ............... The following code does it............ The problem I am encountering.... Any solutions plz.................... ... View more

Re: Assign sequential id by id and date

by Quartz | Level 8 in SAS Data Management
‎09-04-2018 01:50 PM
‎09-04-2018 01:50 PM
Hi @HB, @SuryaKiran 's solution is pretty much alike the document recommend by @ Reeza. And yes, I agree that is simple and easy to follow. However, even for fun(which is fine) your code is giving the wrong results. It may not help the cause of OP or others in my humble opinion ... View more

Re: SAS programming "golf": highest digit in a string of digits

by Quartz | Level 8 in SAS Programming
‎07-20-2018 04:52 PM
‎07-20-2018 04:52 PM
Everyone who contributed  to the thread has been fantastic and I wish I had the ability to code or let alone think at that level.   How long have you(to each one of you who contributed) been using SAS to be so competent? ... View more

Re: SAS programming "golf": highest digit in a string of digits

by Quartz | Level 8 in SAS Programming
‎07-20-2018 11:08 AM
‎07-20-2018 11:08 AM
@KachiM While your code looks nice and fancy, it actually deviates from the objective and scope of the discussion topic aka "golf" i.e the least code to results. Scope creep is not the objective IMHO ... View more

Re: Subgroup count required

by Quartz | Level 8 in SAS Programming
‎07-02-2018 12:39 PM
‎07-02-2018 12:39 PM
@Rahul_SAS You can make it easy for responders  by providing your sample data in the form of a datastep and your expected OUTPUT sample for the input sample. This would help the community test their code to see if they match your expected output before they post the code. Thanks! ... View more

Re: Creating a Variable That Shows the First Time an Observation Occur...

by Quartz | Level 8 in SAS Programming
‎06-10-2018 10:24 PM
‎06-10-2018 10:24 PM
where is FO in the wanted table. Can you please explain your logic with your wanted table.    Or perhaps, i'm not comprehending your English well ... View more

Re: construct my own data sets from two source data sets

by Quartz | Level 8 in SAS Programming
‎06-09-2018 03:16 PM
‎06-09-2018 03:16 PM
Can you explain the logic for one obs in want 1111 1111 2001 4   like how you derive this? ... View more

Re: sumif and a countif in sas

by Quartz | Level 8 in SAS Programming
‎05-31-2018 02:50 PM
‎05-31-2018 02:50 PM
Hi @Astounding and @PaigeMiller, if you have got a couple of mins to spare, would you mind a small explanation for the weight statement plz? like what it does and why use it.   The doc is rather confusing me ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎02-14-2019 12:13 PM
Likes given to
Likes from
Quick links