About SASAna

SASAna · ‎09-08-2017

Hi Novinsrin, i have edited the original message to add test data , along with expected custom value

SASAna · ‎09-08-2017

Hi SAS USers, I needed some help in populating the custom field by the claim_id with sum(net amt pay), currently with the below logic i am getting 0.00 in the field. Example data and expected custom calculation - clm_id status paid_amt custom 1 Q 100.00 0 1 A 0 300.00 1 Q 200.00 0 1 Q 0 0 proc sort data = Output1; by clm_id; run; data Output2; set Output1; by clm_id; if status = 'A' then Custom = put(sum(net_amt_pay), 8.2); else Custom = ''; run; Thanks, Ana

SASAna · ‎08-29-2017

Thanks for the tips Alan. Thanks, Ana

SASAna · ‎08-24-2017

Hi SAS Users, I wanted some guidance on using equivalant tool of SAS HPA for SAS stored process related UI (front end) projects. SAS HPA is not working very good for us to implement our UI projects ( which is using SAS stored process, JSP & HTML) Any thoughts on this ? Thanks, Ana

SASAna · ‎08-10-2017

thanks for the suggestion. I will use codebox going fwd. Thanks, Ana

SASAna · ‎08-10-2017

I broke the code to 3 segments - proc sql noprint; create table test as select clm_id from CLMS group by clm_id having sum(net_amt_pay) < 100; quit; proc sql noprint; create table test1 as select * from CLMS where clm_id not in (select distinct clm_id from test); quit; data finale; set test1; IF (trim(PROC_CD) in (&PROCS)) THEN DO; FLAG = 'A'; END; ELSE DO; FLAG ='B '; END; run;

SASAna · ‎08-09-2017

Hi SAs Users, Needed help in validating the below code ( group by claim and sum the dollar field & check for procedures by claim line level and flag them) proc sort data = test; by CLM_ID ; run; data test1; set test by clm_id; IF sum(net_amt_pay) >= 100 THEN DO; IF trim(PROC_CD) in (&PROCS) ) THEN DO; FLAG = 'A'; END; ELSE DO; FLAG ='B'; END; END; ELSE FLAG ='B '; run; Example - expected result of Flag would be like this - clm_id net_amt_pay proc flag 1 10 1234 A 1 50 B 1 40 B Thanks, Ana 1

SASAna · ‎07-12-2017

Requirment is to get the current week's work assignments by using the modified_date field. modified_date is datetime field. So i have used datepart function. data current_week; set previous_dataset; where datepart(modified_date) le today() - 7 ; run; Thanks, Ana

SASAna · ‎07-12-2017

Hi SAS Users, I wanted some help in finding the current week logic like below. Logic - get the current week from the Modiefied date and compare it with the current week. where week(datepart(modified_date)) eq week(today()) data current_week; set previous_dataset; ----------> it has a field 'modified_date' - a date field. where week(datepart(modified_date)) eq week(today()); run; Thanks, Ana

SASAna · ‎05-26-2017

Thanks for the links and tips , it is really helpful 🙂

SASAna · ‎05-26-2017

Thanks Kiran for the detailed steps. It worked very well and improved the processing time.

SASAna · ‎05-23-2017

Hi SAS users, I tried this below as per your suggestion of adding option and creating the test table in ORacle DB. But i am getting error. Can u please correct my mistake? I needed to create a empty table - so there is no "from". Error - right paranthesis is missing. code - options dbidirectexec sastraceloc=saslog; proc sql; connect to oracle (user=&myid orapw=&mypwd path="&mydb"); execute( create table test.post_test as select (job_id char(10), sale_id char(20), reason char(2000), run_id char(20), run_date char(20) ) ); disconnect from oracle; quit;

SASAna · ‎05-23-2017

Yes please. I am interested to know that 🙂 Thanks, Ana

SASAna · ‎05-23-2017

Hi SAS Users, Wanted some help in the tuning the below query, which is taking 2 hours to update the Oracle table after Oracle -SAS merge. SAS datset has 1800 records. Oracle table is pretty big, but indexed on merging variables. after merging it is updating 4000 records. libname test oracle user=&myid password=&mypwd path="&mydb" schema=test; proc sql noprint; update test.&Oracle_table as a set test_id = (select test_id from sas_dataset as b where a.&rec_id = b.&rec_id and a.run_id = b.run_id and a.run_date = b. run_date) where exists (select * from sas_dataset as b where a.&rec_id = b.&rec_id and a.run_id = b.run_id and a.run_date = b. run_date) ; quit; libname test clear; Thanks, Ana

SASAna · ‎05-16-2017

Hi Paige, Below is the example and rest of the code would be - dates are being passed to a macro variables nqt_fos & nqt_los. %LET nqt_fos = date1 ; ( Ex : 12/5/2014 12:00:00AM) %LET nqt_los = date2 ; (Ex: 15/6/2014 12:00:00AM) PROC SQL is called like the above code to change them into charcter YYMMDD10. format. Thanks, Ana

Online Status	Offline
Date Last Visited	‎06-30-2021 01:11 AM

Re: SCD type2 in SAS

SCD type2 in SAS

Re: Proc transpose

Re: Proc transpose

Proc transpose

Re: proc gee - Nesting continuous variable

proc gee - Nesting continuous variable

Re: min Date conversions to character date

min Date conversions to character date

Re: adding weeks to the max of the date and comparing it with datetime...

Re: SCD type2 in SAS

Re: Proc transpose

Re: adding weeks to the max of the date and comparing it with datetime...

Re: adding weeks to the max of the date and comparing it with datetime...

Re: scan in the proc sql

Re: scan in the proc sql

Excel reading and converting to macro variable error

Re: Converting character date to " DATETIME20."

Re: group by in Dataset

group by in Dataset

Re: SAS HPA equivalant UI tool

SAS HPA equivalant UI tool

Re: by variable grouping

Re: by variable grouping

by variable grouping

Re: how to find current week in SAS

how to find current week in SAS

Re: SAS Dataset to Oracle table merge

Re: SAS Dataset to Oracle table merge

Re: SAS Dataset to Oracle table merge

Re: SAS Dataset to Oracle table merge

SAS Dataset to Oracle table merge

Re: PUTC function to convert macro variable DATE field YYMMDD10. forma...