About novinosrin

novinosrin · ‎05-17-2017

Using macro, i'd deem this as not efficient: %macro split_into_datasets; proc sql; select distinct CAMPAIGN_GROUP_CD into : list separated by ' ' from CMS_STG_AGENT; quit; %do i=1 %to %sysfunc(countw(&list)); %let name=%qscan(&list,&i); data cms_group&i; set CMS_STG_AGENT; where CAMPAIGN_GROUP_CD="&name"; run; %end; %mend split_into_datasets; %split_into_datasets

novinosrin · ‎05-17-2017

You don't need a macro, the same can be achieved by using Hashes--> Assuming your dataset is sorted by CAMPAIGN_GROUP_CD data _null_; if _n_=1 then do; if 0 then set CMS_STG_AGENT; dcl hash h(dataset:'CMS_STG_AGENT(obs=0)',multidata: 'y', ordered: 'y'); h.definekey('CAMPAIGN_GROUP_CD'); h.definedata('agent','capacity'); h.definedone(); end; set CMS_STG_AGENT ; by CAMPAIGN_GROUP_CD; if first.CAMPAIGN_GROUP_CD then do; h.clear(); n+1; end; rc=h.add(); if last.CAMPAIGN_GROUP_CD then h.output(dataset:'cms_group'||left(n)); run; Regards, Naveen Srinivasan

novinosrin · ‎05-17-2017

@Raffik Please mark @art297 's solution as accepted and answered. Thank you!

novinosrin · ‎05-16-2017

proc sort data=in; by id ; run; data out; set in; by id height notsorted; if last.height; run; Regards, Naveen Srinivasan Edited: I missed to read your question properly. Well, in any case when Xia keshan answers, one can blindly copy the genius. My apologies!

novinosrin · ‎05-16-2017

Do you mean ?: data ABNLABKEEP; set ABNLABKEEP; format LBTEST $LBTEST.; run;

novinosrin · ‎05-16-2017

data have; input Reporting_Date $ Account_ID Advance Latest_Advance $; datalines; Jan-05 1111 0 . Feb-05 1111 0 . Mar-05 1111 1 Mar-05 pr-05 1111 1 . May-05 1111 1 . Jun-05 1111 1 . Jul-05 1111 2 Jul-05 Aug-05 1111 2 . Sep-05 1111 2 . Oct-05 1111 2 . Nov-05 1111 3 Nov-05 Dec-05 1111 3 . Jan-06 1111 3 . ; data want; length temp $10; call missing(temp); do until(last.account_id); set have; by account_id; if not missing(Latest_Advance) then temp=Latest_Advance; else if missing(Latest_Advance) then Latest_Advance=temp; output; end; drop temp; run; Regards, Naveen Srinivasan

novinosrin · ‎05-15-2017

I think you would need another explicit OUTPUT statement in @Shmuel 's code. data want; set have; by DTE; output;/*modified here*/ if last.dte and MOB < 60 then do; call missing(balance_remaining); do mob=mob+1 to 60; output; end; end; run; Regards, Naveen Srinivasan

novinosrin · ‎05-15-2017

Thank you @art297 , @Ksharp for the very valuable insights and extending the knowledge for somebody like me to learn. I can't appreciate enough, not just this post, many of yours. I have shamelessly used your codes as a verbatim to many of my work. Thank you so much indeed. Regards, Naveen Srinivasan

novinosrin · ‎05-15-2017

I tested using your sample that you gave. It did fetch the sum for the id 08660123 And this is what i got: account_no totaltransaction ---------------------------- 08660123 3200

novinosrin · ‎05-15-2017

Asssuming some accounts may have transacted only for 2 months, for eg any account that may have opened only a couple of months ago: proc sql; select account_no,sum(transamt) as totaltransaction from account where intck('month',acc_open_date,trans_date)+1<=3 group by account_no; quit; Regards, Naveen Srinivasan

novinosrin · ‎05-15-2017

data want; merge tab1 tab2 tab3; run; Regards, Naveen Srinivasan

novinosrin · ‎05-15-2017

Another easy solution: data have; input ID_I ID_F ID_M; cards; 11 21 31 12 22 32 13 23 33 14 11 12 15 11 13 16 11 12 17 14 12 18 14 15 19 14 16 ; run; data want; if _N_ = 1 then do; if 0 then set have; declare hash myhash(dataset:'have(keep=ID_F)',multidata:'YES'); myhash.defineKey('ID_F'); myhash.defineDone( ); declare hash myhash2(dataset:'have(keep=ID_M)',multidata:'YES'); myhash2.defineKey('ID_M'); myhash2.defineDone( ); end; set have; if myhash.check(key:ID_I)=0 then Sex=2; else if myhash2.check(key:ID_I)=0 then Sex=1; else Sex=0; run; Regards, Naveen Srinivasan

novinosrin · ‎05-12-2017

And another NOT so smart method, but just for fun; data want; if _N_ = 1 then do; length _flag_min _flag_max 8; declare hash myhash(multidata:'YES' ); myhash.defineKey('group'); myhash.defineData('group','_flag_min','_flag_max'); myhash.defineDone( ); call missing(_flag_min, _flag_max); end; do n=1 by 1 until(last.group); set have end=last; by group; if first.group then _flag=0; if count>=1 then _flag+1; else _flag=0; if _flag=1 then _flag_min=n; else if _flag=4 then do; _flag_max=n; myhash.add(); end; else if _flag>4 then do; _flag_max=n; myhash.add(); end; end; do n=1 by 1 until(last.group); set have end=last; by group; result='FAIL'; rc = myhash.find(); if (rc = 0) then do; if _flag_min<=n<=_flag_max then result='PASS'; rc = myhash.find_next(); do while(rc = 0); if _flag_min<=n<=_flag_max then result='PASS'; rc = myhash.find_next(); end; end; output; end; drop n _: rc; run;

novinosrin · ‎05-10-2017

Add a $ to your array statement: array vars{30} $30 match1-match30; edited: Sorry ignore mine, Reeza is right, i didn;t look at your program properly

novinosrin · ‎05-10-2017

@ballardw I agree with you Sir. First of all, i am too lazy to open attachments no matter how excited i am when there is a prospect for coding. Second of all, If i try to open any external attachment from my corporate environment, it's pretty certain i may have to face severe consequences. So it's best for anybody to post in the form of HAVE and WANT not necessarily as a datastep but atleast as clear and smaller lines with a few bullet points explaining the convert logic and requirement.

Online Status	Offline
Date Last Visited	‎12-24-2025 04:47 PM

Re: How to "Split Data" (By Group Processing)

Re: How to count until there is a change in a variable

Re: Can I use Like and In function in a where statement together?

Re: Importing data from multiple excel files with multiple sheets

Re: Convert all XLS files in directory to CSV using SAS

Re: Will Python or R replace SAS in clinical domain in coming future ?

Re: My SAS Certification Log

Re: My SAS Certification Log

Re: PROC CONTENTS type format

Re: Production code floods LOG with Warning notes

Re: How to "Split Data" (By Group Processing)

Re: Meet Kurt Bremser: Yoda for New SAS Users

Re: Thoughts on building experience as professional SAS programmer & f...

Re: ERROR: Array subscript out of range at line xxx column xx

Logistic Regression in SAS Viya — PROC LOGSELECT or regression.logisti...

Re: Using proc sql to create min and max

Re: Simple concatenation of string variables using CATS / CATX

Re: Selecting records with latest date

Re: Numeric to character conversion notes in sas log

Re: Remove Comma from Macro number

Re: Split tables

Re: Split tables

Re: Missing variables

Re: Creating new data periods from yearly snapshot

Re: Change value in a dataset

Re: Retaining Date value until change

Re: Pad out dataset with new rows

Re: Create a new variable from three other variables

Re: First 3months transaction amount

Re: First 3months transaction amount

Re: Join three table

Re: Create a new variable from three other variables

Re: mark consecutive years' value with different result

Re: Arraying variables that have character and numeric codes

Re: Arrays - Nested do loops to compare two rows

SAS Global Forum 2018