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: 
bbb_NG
‎04-25-2017
  • 99 Posts
  • 7 Likes Given
  • 0 Solutions
  • 5 Likes Received

Re: Efficiency problem on "data set" and proc sql?

by Fluorite | Level 6 in SAS Procedures
‎04-09-2012 09:34 PM
‎04-09-2012 09:34 PM
manojinpec , No error occurred, just lasting than several minutes, stimulating my patience. One thing to clear ,that no macro is involved. Thank you anyway for giving another thinking. dawn ... View more

Re: Efficiency problem on "data set" and proc sql?

by Fluorite | Level 6 in SAS Procedures
‎04-09-2012 05:21 AM
‎04-09-2012 05:21 AM
manojinpec , sorry it doesn't work, it has running for minutes,i have to stop it. ... View more

Re: Efficiency problem on "data set" and proc sql?

by Fluorite | Level 6 in SAS Procedures
‎04-09-2012 05:04 AM
‎04-09-2012 05:04 AM
Ksharp, Thanks for your comments. I've tried,now it's tolerable. when replacing if with where in solution1 the extraction time drops dramatically to 38.15 s and solution 2 is only 24.29 s ... View more

Efficiency problem on "data set" and proc sql?

by Fluorite | Level 6 in SAS Procedures
‎04-09-2012 04:47 AM
‎04-09-2012 04:47 AM
Solution 1: DATA wuTemp.CustTRBcur (keep='Version Date'n         'HUB Cust Id'n           'Last Month Average Balance'n     ) ; SET CNMAP.VIEW_MAPRH_M_CN_CUS_TRB ; if 'Version Date'n=&CurDate and 'Last Month Average Balance'n>=0; run; Solution 2: proc sql; create table wuTemp.CustTRBcur as select 'Version Date'n   ,  'HUB Cust Id'n   ,     'Last Month Average Balance'n  from CNMAP.VIEW_MAPRH_M_CN_CUS_TRB where 'Version Date'n=&CurDate and 'Last Month Average Balance'n>=0; quit; I wonder why solution 2 is much quicker than solution 1 on the condition that in database CNMAP, it will keep 24 latest months records. can anyone tells why? thanks Dawn ... View more

How to understand the following call symput in macro?

by Fluorite | Level 6 in SAS Programming
‎04-01-2012 01:38 AM
‎04-01-2012 01:38 AM
Linlin,thanks for your answers. ... View more

How to understand the following call symput in macro?

by Fluorite | Level 6 in SAS Programming
‎04-01-2012 12:17 AM
‎04-01-2012 12:17 AM
Tom, Thanks for your reply. ... View more

How to understand the following call symput in macro?

by Fluorite | Level 6 in SAS Programming
‎04-01-2012 12:16 AM
‎04-01-2012 12:16 AM
Linlin, thanks for your reply, can you go further as to tell why left and compress functions are used? thanks. ... View more

How to understand the following call symput in macro?

by Fluorite | Level 6 in SAS Programming
‎03-31-2012 11:51 PM
‎03-31-2012 11:51 PM
2 obs of data Temp_cats IV_Bin Count Percent 1 410 8.2 2 35 0.7 ... View more

How to understand the following call symput in macro?

by Fluorite | Level 6 in SAS Programming
‎03-31-2012 11:43 PM
‎03-31-2012 11:43 PM
Dear all,      I was learning macro from books, there some code as below in a macro,      Data _null_;    set Temp_Cats;         call symput ("C_" || left(_N_), compress(IV_Bin));                call symput ("n_" || left(_N_), left(count));         call symput ("M", left(_N_));         Run; I can not have a visual sightseeing as how the 3 call symput did, no matter in log /output window. Can anyone help to explain what the 3 call symput do? very thanks. ... View more

Difference between excel files extracted from SAS and MS Access

by Fluorite | Level 6 in Microsoft Integration with SAS
‎03-29-2012 11:34 PM
‎03-29-2012 11:34 PM
Dear All,      I have a work to export mobile phones in dataware house to excel files for SMS need.      Before sas, I use MS Access moudles to do it and it works.The upload platform for sending SMS recognize both text and numberic format for mobile phone.      Now I write a macro to export excel files with mobile phone using character format.   The upload platform refuse to recognize the sas-output format. I even try "'||'mobile phone'n ,don't work either. My alternative solution is add a step as export to ms access in SAS. Can any one here give a thought? Thanks. ... View more

Re: How to explain the Normality Tests using KS,etc?

by Fluorite | Level 6 in Statistical Procedures
‎03-26-2012 09:11 PM
‎03-26-2012 09:11 PM
PG,Thanks, it do helps. ... View more

Re: How to explain the Normality Tests using KS,etc?

by Fluorite | Level 6 in Statistical Procedures
‎03-26-2012 04:17 AM
‎03-26-2012 04:17 AM
Ksharp, Thank you very much. ... View more

How to explain the Normality Tests using KS,etc?

by Fluorite | Level 6 in Statistical Procedures
‎03-25-2012 11:05 PM
‎03-25-2012 11:05 PM
Dear All, Thanks for explain the follwoing table for me,whether this field check for normality with the answer to its normal distribution  yes/no? thanks. Further, what if the three tests have contradiction? Tests for Normality Test Statictice P Value Kolmogorov-Smirnov D 0.064727 Pr > D >0.15 Cramer-von Mises W-Sq 0.21097 Pr > W-Sq 0.2014 Anderson-Darling A-Sq 1.28515 Pr > A-Sq 0.1916 ... View more

How to use one word to replace a lot of same word to avoid clerical er...

by Fluorite | Level 6 in SAS Procedures
‎02-28-2012 08:46 PM
‎02-28-2012 08:46 PM
Art,Hima, First thank you for your help. Second ,I have to apologize.I have thought of the %let method, but instinctly thought it won't work. I should at least have a try, cause it is so easy to resolve if I had a try.. Thank you both for your patience to give a hand to a newbie especially on a so silly question. ... View more

How to use one word to replace a lot of same word to avoid clerical er...

by Fluorite | Level 6 in SAS Procedures
‎02-28-2012 04:25 AM
‎02-28-2012 04:25 AM
Ksharp, Thanks for your reply. but I'm more confused.thus I put the original code about 10%, I'm wondering whether your method can be applied in the following way? PROC SQL /*Generate vertical data, duplicated*/;    CREATE TABLE wutemp.CustDemoHistory AS /*Age*/  SELECT t1.branch_code,t1.'PFS Cust Segment Code'n, LoanCMP,OutstandingCMP,   t1.nationcmp,  version,t1.'New Cust Ind'n,    t1.OccupationCMP,t1.AGECMP  as cmp,                      (COUNT(t1.AgeCMP)) as  NoCount,trblevel,zoneCMP,agecmp       FROM wutemp.CUSTDEMOBASEHistory  AS t1       GROUP BY t1.branch_code, t1.'PFS Cust Segment Code'n, LoanCMP,OutstandingCMP,   t1.nationcmp,    version, t1.'New Cust Ind'n, t1.OccupationCMP,   trblevel,zoneCMP,agecmp /*Sex*/union SELECT t1.branch_code,t1.'PFS Cust Segment Code'n, LoanCMP,OutstandingCMP,   t1.nationcmp,version,          t1.'New Cust Ind'n,           t1.OccupationCMP,         T1.'Sex Code'n as CMP    ,            (COUNT(*))  AS NoCount,trblevel,zoneCMP,agecmp       FROM wutemp.CUSTDEMOBASEHistory  AS t1       GROUP BY t1.branch_code, t1.'PFS Cust Segment Code'n, LoanCMP,OutstandingCMP,   t1.nationcmp,    version, t1.'New Cust Ind'n, t1.OccupationCMP,  trblevel  ,  t1.'Sex Code'n,zoneCMP,agecmp /*TRBCount*/union SELECT t1.branch_code,t1.'PFS Cust Segment Code'n, LoanCMP,OutstandingCMP, t1.nationcmp,  version,          t1.'New Cust Ind'n,           t1.OccupationCMP,       trblevel as CMP    ,            (COUNT(*))  AS NoCount,trblevel,zoneCMP,agecmp       FROM wutemp.CUSTDEMOBASEHistory  AS t1       GROUP BY t1.branch_code, t1.'PFS Cust Segment Code'n, LoanCMP,OutstandingCMP,   t1.nationcmp,    version, t1.'New Cust Ind'n, t1.OccupationCMP,     trblevel,zoneCMP,agecmp /*Vintage*/union SELECT t1.branch_code,t1.'PFS Cust Segment Code'n, LoanCMP,OutstandingCMP, t1.nationcmp,  version,          t1.'New Cust Ind'n,           t1.OccupationCMP,         Vintage as CMP    ,            (COUNT(*))AS NoCount,trblevel,zoneCMP,agecmp       FROM wutemp.CUSTDEMOBASEHistory  AS t1       GROUP BY t1.branch_code, t1.'PFS Cust Segment Code'n, LoanCMP,OutstandingCMP,   t1.nationcmp,    version, t1.'New Cust Ind'n, t1.OccupationCMP,    trblevel ,  Vintage,zoneCMP,agecmp /*SATRBCount*/ union SELECT t1.branch_code,t1.'PFS Cust Segment Code'n, LoanCMP,OutstandingCMP,t1.nationcmp, version,          t1.'New Cust Ind'n,           t1.OccupationCMP,      T1.SAtrblevel as CMP    ,    (COUNT(*))  AS NoCount,trblevel,zoneCMP,agecmp       FROM wutemp.CUSTDEMOBASEHistory  AS t1       GROUP BY t1.branch_code, t1.'PFS Cust Segment Code'n, LoanCMP,OutstandingCMP,   t1.nationcmp,    version, t1.'New Cust Ind'n, t1.OccupationCMP, trblevel ,  SAtrblevel,zoneCMP,agecmp /*TRBSUM*/union SELECT t1.branch_code,t1.'PFS Cust Segment Code'n, LoanCMP,OutstandingCMP, t1.nationcmp,  version,          t1.'New Cust Ind'n,           t1.OccupationCMP,               (Case WHEN t1.TRBLevel ='TRB1:0_10K'  THEN 'TRB9_1:0_10K'  WHEN t1.TRBLevel='TRB2:10k_100K'  THEN 'TRB9_2:10k_100K' WHEN t1.TRBLevel ='TRB3:100k_300K' THEN 'TRB9_3:100k_300K' WHEN t1.TRBLevel ='TRB4:300k_1M' THEN 'TRB9_4:300k_1M' WHEN t1.TRBLevel='TRB5:1M_3M'  THEN 'TRB9_5:1M_3M' WHEN t1.TRBLevel= 'TRB6:3M_5M'  THEN  'TRB9_6:3M_5M' WHEN t1.TRBLevel= 'TRB7:Over5M'  THEN 'TRB9_7:Over5M' else  'TRB9_8:Nill' End ) as CMP    ,    (sum('Last Month Average Balance'n))  AS NoCount,trblevel,zonecmp,agecmp       FROM wutemp.CUSTDEMOBASEHistory  AS t1       GROUP BY t1.branch_code, t1.'PFS Cust Segment Code'n, LoanCMP,OutstandingCMP,   t1.nationcmp,    version, t1.'New Cust Ind'n, t1.OccupationCMP, trblevel ,  SAtrblevel,zoneCMP,agecmp ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎04-25-2017 10:23 PM
Likes given to
Likes from
Quick links