About novinosrin

novinosrin · ‎02-07-2022

data have; input var1 $6.; cards; xx xxx xxxxxx ; data want; set have; need=translate(right(var1),'0',' '); run;

novinosrin · ‎01-28-2022

data have; input ID Pract_Name $ Hospital_Name $ Date :date9.; format date date9.; cards; 1 XYZ ABC 24-Jun-18 1 XYZ ASD . 2 XYA TVX . 2 XYA TVX 25-Jun-17 2 XYA TRF . 3 WED DEC 25-Jun-19 ; proc sql; create table want as select * from have where cats(id,Pract_name,Hospital_name) not in (select cats(id,Pract_name,Hospital_name) from have where .< date < '01jan2018'd); quit;

novinosrin · ‎01-28-2022

data have; input ID Pract_Name $ Hospital_Name $ Date :date9.; format date date9.; cards; 1 XYZ ABC 24-Jun-18 1 XYZ ASD . 2 XYA TVX . 2 XYA TVX 25-Jun-17 2 XYA TRF . 3 WED DEC 25-Jun-19 ; proc sort data=have out=_have; by id Pract_name Hospital_name; run; /*Datastep*/ data want; do until(last.Hospital_name); set _have; by id Pract_name Hospital_name notsorted; if .< date < '01jan2018'd then _n_=0; end; do until(last.Hospital_name); set _have; by id Pract_name Hospital_name notsorted; if _n_ then output; end; run; /*OR*/ data want; merge _have _have(where=(.< _date < '01jan2018'd) keep= id Pract_name Hospital_name date rename=date=_date in=a); by id Pract_name Hospital_name; if not a; drop _date; run; /*OR*/ data want; if _n_=1 then do; dcl hash h(dataset:"have(where=(.< date < '01jan2018'd))"); h.definekey('id', 'Pract_name', 'Hospital_name'); h.definedone(); end; set have; if h.check() ne 0; run;

novinosrin · ‎01-28-2022

What is your data(sample) and the required output?

novinosrin · ‎01-28-2022

data have; input ID Pract_Name $ Hospital_Name $ Date :date9.; format date date9.; cards; 1 XYZ ABC 24-Jun-18 1 XYZ ASD . 2 XYA TVX . 2 XYA TVX 25-Jun-17 2 XYA TRF . 3 WED DEC 25-Jun-19 ; proc sql; create table want as select * from have group by id, Pract_name, Hospital_name having not max (.< date < '01jan2018'd); quit;

novinosrin · ‎01-28-2022

Hi @ybz12003 Perhaps enclose the &year in sheet within quotes? sheet= "&year" sheet=&year.;

novinosrin · ‎01-26-2022

data have; input var1 var2 $; cards; 1 A 1 A 1 A 0 X 1 A 1 A 2 B 2 B 0 X 2 B 2 B 3 C 3 C 3 C 0 X ; data want; set have; k=lag(var2); if var1=0 then var2=k; drop k; run;

novinosrin · ‎01-18-2022

Hi @Emma2021 @Reeza 's recommendation is spot on and very wise. Right, I am just posting for fun and to get my fingers back into some practice. I'd still suggest to go with Reeza's suggestion or use a DB specific SQL making use of the PARTIITON BY() option, enabling the use of min from each partition. Anyways, for fun- data have; input id day flag; cards; 1 1 . 1 1 2 2 4 2 2 4 . 2 5 . 3 3 2 3 3 . 3 3 8 ; proc sql; create table want as select a.id,a.day,coalesce(a.flag,b.flag) as flag from have a left join (select * from (select *,monotonic() as n from have) group by id, day having min(case when flag>. then n else . end)=n) b on a.id=b.id and a.day=b.day; quit;

novinosrin · ‎01-18-2022

data have; input id day flag; cards; 1 1 . 1 1 2 2 4 2 2 4 . 2 5 . 3 3 2 3 3 . 3 3 8 ; data want ; if _n_ = 1 then do ; dcl hash h (dataset:'have(where=(flag))' ) ; h.definekey ('id', 'day') ; h.definedata ('flag') ; h.definedone ( ) ; end ; set have ; if flag=. then _n_ = h.find( ) ; run ;

novinosrin · ‎01-18-2022

data have; input id day flag; cards; 1 1 . 1 1 2 2 4 2 2 4 . 2 5 . 3 3 2 3 3 . 3 3 8 ; data want ; do until (last.day) ; set have ; by id day ; if flag and _n=. then _n = flag ; end ; do until (last.day) ; set have ; by id day ; if flag=. then flag = _n ; output ; end ; drop _n ; run ;

novinosrin · ‎01-18-2022

data have; input id var_1 $ var_2 flag_1 flag_2; datalines; 1 ab 1 0 1 1 ab 1 0 1 1 ab 1 0 0 1 ab 1 0 0 1 ef 7 1 0 1 ef 7 0 0 1 ef 7 1 0 2 ef 3 1 1 2 xy 4 1 0 2 xy 4 1 0 2 xy 4 1 0 2 xy 5 0 1 2 xy 5 0 1 ; run; proc sql; create table want as select id, var_1, var_2, max(flag_1) as flag_1_new, max(flag_2) as flag_2_new from have group by id, var_1, var_2; quit;

novinosrin · ‎01-15-2022

data have; infile cards truncover; input ID Dispflag DRDiagnose; cards; 1 1 2 . 3 2 . 7 2 1 3 . 12 3 1 4 1 5 . 2 5 . 8 5 1 6 . 2 6 1 7 1 8 1 9 . 6 9 . 14 9 . 14 9 1 ; data want ; set have ; by id ; retain t ; if first.id then t = . ; if DRDiagnose then t = DRDiagnose ; if Dispflag and not DRDiagnose and t then DRDiagnose = t ; drop t ; run ;

novinosrin · ‎01-14-2022

data have; input Name $ ORDER;* NEW ORDER#; cards; ABC 1 1 ACC 2 1 ADC 3 1 AEC 4 2 AFC 5 2 AGC 6 2 AHC 7 3 AIC 8 3 AJC 9 3 ; data want; set have; if mod(order, 3) = 1 then new_order + 1; run;

novinosrin · ‎01-14-2022

A classic use-case for REMERGE and HAVING clause combine to subset- proc sql; create table want as select * from have group by var1, var2 having max(var3)=var3; quit;

novinosrin · ‎01-13-2022

Hi @DocMartin Keeping it simple- proc sql; create table want1 as select ptid , case when drg_type='A' and b.diagnosis>' ' then 'A' when drg_type='A' and c.diagnosis>' ' then 'M' when drg_type='M' and c.diagnosis>' ' then 'M' when drg_type='M' and b.diagnosis>' ' then 'A' else ' ' end as drg_type , code , case when drg_type='A' then coalesce(b.diagnosis,c.diagnosis) when drg_type='M' then coalesce(c.diagnosis,b.diagnosis) else ' ' end as diagnosis from main a left join apr b on a.code=b.aprdrg left join ms c on a.code=c.msdrg order by ptid; quit;

Online Status	Offline
Date Last Visited	2 weeks ago

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: How to patch "0"s ahead a string?!

Re: How to remove a group of observations based on certain date condit...

Re: How to remove a group of observations based on certain date condit...

Re: Proc SQL count distinct Question

Re: How to remove a group of observations based on certain date condit...

Re: Macro year could not be recognized?

Re: How do I vertically change value to the one above?

Re: RETAIN and impute

Re: RETAIN and impute

Re: RETAIN and impute

Re: How to create binary variables from multiple observations?

Re: Setting a variable to a lagging value based on a flag possible usi...

Re: How assign new order/id to every 5 rows based on order#

Re: How do I subset/keep multiple rows based on value of another row

Re: Matching a table with two possible look-up tables

SAS Global Forum 2018