07-10-2018
c4shiva
Calcite | Level 5
Member since
03-28-2018
- 13 Posts
- 0 Likes Given
- 0 Solutions
- 0 Likes Received
-
Latest posts by c4shiva
Subject Views Posted 1415 07-10-2018 01:08 AM 1419 07-10-2018 01:01 AM 1473 07-09-2018 08:17 AM 749 05-21-2018 05:26 AM 1529 05-21-2018 05:17 AM 1606 05-18-2018 03:23 AM 813 05-18-2018 02:58 AM 1280 05-09-2018 01:14 AM 1316 04-20-2018 01:28 AM 1387 04-19-2018 06:37 AM -
Activity Feed for c4shiva
- Posted Re: INTNX on SAS Programming. 07-10-2018 01:08 AM
- Posted Re: INTNX on SAS Programming. 07-10-2018 01:01 AM
- Posted INTNX on SAS Programming. 07-09-2018 08:17 AM
- Posted Re: Proc SQL on SAS Programming. 05-21-2018 05:26 AM
- Posted Re: Psuedo Code on SAS Programming. 05-21-2018 05:17 AM
- Posted Psuedo Code on SAS Programming. 05-18-2018 03:23 AM
- Posted Proc SQL on SAS Programming. 05-18-2018 02:58 AM
- Posted Re: SYSFUNC on SAS Programming. 05-09-2018 01:14 AM
- Posted Re: SYSFUNC on SAS Programming. 04-20-2018 01:28 AM
- Posted SYSFUNC on SAS Programming. 04-19-2018 06:37 AM
- Posted Re: PROC SQL on SAS Programming. 03-29-2018 01:24 AM
- Posted Re: PROC SQL on SAS Programming. 03-29-2018 01:23 AM
- Posted PROC SQL on SAS Programming. 03-28-2018 06:23 AM
07-10-2018
01:08 AM
Hi Can you pls tell me what the code actually do? or if you can put any dummy data and say the output for this? I dont have sas to execute. so only not able to share the log or error. ,count (case when (reg_id in ('03') and REPORT_date BETWEEN intnx('month', "&VISION_date"d, -2, 'end') AND intnx('month', "&VISION_date"d, -13, 'begin')) then 1 else . end) as cust_id
... View more
07-10-2018
01:01 AM
Hi The Actual code is below. I don't have sas to run the code and check for output. Am only having the sas code alone. Am reading this code in notepad and trying to get output and write the pseudo code. So only am not able to share the log or error message. ,count (case when (reg_id in ('03') and REPORT_date BETWEEN intnx('month', "&VISION_date"d, -2, 'end') AND intnx('month', "&VISION_date"d, -13, 'begin')) then 1 else . end) as cust_id REPORT_date =2009-04-30 VISION_date=2009-07-30 Or can pls tell me what the code actually do?
... View more
07-09-2018
08:17 AM
Hi All, Can pls tell me what will be the output for the below logic count (case when (reg_id in ('03') and 2009-04-30 BETWEEN intnx('month', "2009-07-30"d, -2, 'end') AND intnx('month', "2009-07-30"d, -13, 'begin')) then 1 else . end) as cust_id
... View more
05-21-2018
05:26 AM
Thank you so much ... now am clear... Am a fresher just started to learn SAS from google. Thanks again for your link.. very helpful.
... View more
05-18-2018
03:23 AM
Can any one knows how to convert below SAS to Pseudo code ? sum ((case when (mod_r in ('02') and CAL IN ('P') and fec_in <= intnx('month', "PAR_FEC"d, -1, 'end') and EST not in ('7' '07' ' 7' '7 ' '70') and temp>0) then temp*SAL_OBL else . end)) as con_temp.
... View more
05-18-2018
02:58 AM
Hi All, Can pls explain the below code. My doubt is 1. var.sec_terc --> is this a table or column name? 2.from DET_CT var --> What it is actually? If table, above one is column name is it? proc sql; create table CT_M. as select var.sec_terc ,max (case when (var.mod_r in ('01') and var.CAL IN ('P') and FEC_COR_R BETWEEN intnx('month', "&PAR_FEC_H"d, -2, 'end') AND intnx('month', "&PAR_FEC_H"d, -4, 'begin') and var.edad_m_r>=0) then min(12,var.edad_m_r) else . end) as C_150 from DET_CT var where var.CALIDAD IN ('P' 'C' 'S' 'A') and var.ESTADO_R not in ('7' '07' ' 7' '7 ' '70') group by var.sec_terc; quit;
... View more
05-09-2018
01:14 AM
Thanks a lot KurtBremser.... Your code was easy to understand and it is very useful for writing pseudo code. Thanks again. 🙂
... View more
04-20-2018
01:28 AM
Actually am not having SAS to execute the code. My work is to convert sas code to a tech spec document.So only not able to get the output. 😞
... View more
04-19-2018
06:37 AM
Hi Folks, Can anyone say what will be the output for the below code? %global PR_FA_H PR_F_A PR_F_I PR_F_S PR_T_C PR_TA_C PR_T_V PR_T_O PR_T_OT PR_TA ENTI DEFINE_ENT PR_SA; %macro autofecha; %let par1=%sysfunc(putn(%sysevalf("&sysdate"d-0),weekday.)); %put par1 = &par1; %if &par1 <= 6 %then %let par2= %sysfunc(putn(%sysevalf("&sysdate"d-(&par1 + 1)),date9.)); %else %let par2= %sysfunc(putn(%sysevalf("&sysdate"d-(1)),date9.)); %put par2=&par2; %let PR_FA_H=%sysfunc(putn(%sysfunc(intnx(month,"%sysfunc(putn("&par2"d,date9.))"d,-0, begin)),date9.)); %let PR_F_A=%sysfunc(putn(%sysfunc(intnx(month,"%sysfunc(putn("&par2"d,date9.))"d,-13, begin)),date9.)); %let PR_F_I=%sysfunc(putn(%sysfunc(intnx(month,"%sysfunc(putn("&par2"d,date9.))"d,-49, begin)),date9.)); %let PR_F_S=%sysfunc(putn(%sysfunc(intnx(month,"%sysfunc(putn("&par2"d,date9.))"d,-7, begin)),date9.)); %put PR_FA_H=&PR_FA_H; %put PR_F_A=&PR_F_A; %put PR_F_I=&PR_F_I; %put PR_F_S=&PR_F_S; %let PR_T_C = 1.2; %let PR_TA_C = 2.0; %let PR_T_V = 1.1; %let PR_T_O = 2.0; %let PR_T_OT = 2.0; %let PR_TA = 2.0; %let ENTI=9999999999; %let DEFINE_ENT= le; %let PR_SA=MCDO; %mend autofecha; %autofecha;
... View more
03-28-2018
06:23 AM
Can anyone pls explain what actually happen in the below sas script. I am unable to understan .AS in the script. PROC SQL; CREATE TABLE in.AAAA as SELECT Client AS IDNumber, CIDNumber AS au_IDNumber, . as Emp, BN871, BN562, BN123, BN346, . as MT111, . as MT112, . as MT113, . as MT114, D_host, AXZ_host, TJD_AG, FROM in.PME_SDC; QUIT;
... View more