BASEL Modelling, CCAR/DFAST stress testing, Credit Risk Decision Analytics, SAS Macros, SAS Proc, SAS SQL, SAS EG, Statistics, Base SAS Programming, SAS on Mainframe and UNIX ,SAS BI, ETL, Advance SAS programming and concepts,
Please let us know all the approaches that you have tried because the problem seems to be very basic and it does not require much of SAS expertise. Then only we can help you.
... View more
I am trying to find out the number of working days in month using INTCK but getting incorrect result?? I have used the below code, but it gives me correct result for one month but incorrect for other. data kbc; this_month_first_date=intnx('month',today(),0,'b'); next_month_first_date=intnx('month',today(),1,'b'); days=intck("weekday", this_month_first_date, next_month_first_date); format this_month_first_date next_month_first_date date9.; run; proc print data=kbc; run; I have one doubt also that intnx function I used above is also counting the days: this_month_first_date, next_month_first_date + days between them for total numbers days in month. What I have studied is that intnx function calculates the time interval b/w two date/time value but it also include that two date/time is in doubts
... View more
if dataset has 4 millions row then there will 128Mbyte data to cached and I don't know how well will SAS be able to tackle it with its cached memory.
... View more
Thank you for the reply. But the dataset is much bigger more 4 Millions observations and we have limited resource( Executing Capacity). So I am thinking to optimize in some way. If there is any possible way to reduce the execution time please let me know.
... View more
dataset k; input a b c d; datalines; 1 2 4 4 1 3 3 4 2 3 4 4 so on ; run; data k; set k; if( a=xyz and b=lmn and c=hjk and d=cde) then; flag1=x1; flag2=x2; flag3=x3; else; flag1=y1; flag2=y2; flag3=y3; run; I am worried about the execution time of the above. Could anybody help me optimizing the above problem. One solution I have is to index the four columns. Please provide some useful solution to optimize it in best possible manner. Thanks in advance.
... View more
Hi Guys, I would like to know if there is any book for practicing Base and Advance Practical problems. What I mean to say problems involves concepts of Base SAS and Proc SQL that helps us to build a clear understanding to solve real-time problems of banking and various domain.
... View more
data abc; input kk $30. ; datalines; MADISON WI 53714-1006 SUN PRAIRIE WI 53590-2585 MADISON WI 53716-2125 ; run; data sub; set abc; Address_Line_2 = scan(kk,1); state= scan(kk,2); zip= substr(compress(kk, , 'kd'),1,5);/* to extract the numeric part */ run;
... View more
%macro rept(dat,a,dsn); proc chart data=&dsn; title "Chart for &dat"; where(date="&dat"); vbar &a; run; %mend rept; data _null_; set dates; call execute('%rept('||date||','||'var1,reptdata)'); /* here is use of pipe that I need to know */ run;
... View more
