02-15-2023
Ashok3395
Fluorite | Level 6
Member since
09-21-2018
- 9 Posts
- 10 Likes Given
- 0 Solutions
- 0 Likes Received
-
Latest posts by Ashok3395
Subject Views Posted 9633 02-27-2019 01:54 PM 975 02-15-2019 04:25 AM 6344 01-02-2019 08:42 AM 35421 12-26-2018 03:18 AM 35421 12-26-2018 03:17 AM 35464 12-24-2018 08:37 AM 35465 12-24-2018 08:36 AM 35522 12-14-2018 09:56 AM -
Activity Feed for Ashok3395
- Liked Re: Error while testing the scenerio in SAS ECM for noling. 10-11-2019 09:18 AM
- Liked Re: Convert date to character and group them by substr for ForrestYao. 02-28-2019 08:16 AM
- Posted Re: Convert date to character and group them by substr on SAS Programming. 02-27-2019 01:54 PM
- Tagged Error while testing the scenerio in SAS ECM on SAS Programming. 02-15-2019 06:35 AM
- Tagged Error while testing the scenerio in SAS ECM on SAS Programming. 02-15-2019 06:35 AM
- Tagged Error while testing the scenerio in SAS ECM on SAS Programming. 02-15-2019 06:35 AM
- Posted Error while testing the scenerio in SAS ECM on SAS Programming. 02-15-2019 04:25 AM
- Liked Re: Calculating percentile for Huge data. for Astounding. 01-04-2019 11:33 AM
- Liked Re: Calculating percentile for Huge data. for mkeintz. 01-04-2019 11:33 AM
- Liked Re: Calculating percentile for Huge data. for PGStats. 01-04-2019 11:32 AM
- Liked Re: Calculating percentile for Huge data. for FreelanceReinh. 01-04-2019 11:32 AM
- Posted Calculating percentile for Huge data. on SAS Procedures. 01-02-2019 08:42 AM
- Posted Re: How to Convert yyyymmdd(numeric) to DATE9 format? on New SAS User. 12-26-2018 03:18 AM
- Posted Re: How to Convert yyyymmdd(numeric) to DATE9 format? on New SAS User. 12-26-2018 03:17 AM
- Liked Re: How to Convert yyyymmdd(numeric) to DATE9 format? for Jagadishkatam. 12-26-2018 03:16 AM
- Liked Re: How to Convert yyyymmdd(numeric) to DATE9 format? for r_behata. 12-26-2018 03:15 AM
- Posted Re: How to Convert yyyymmdd(numeric) to DATE9 format? on New SAS User. 12-24-2018 08:37 AM
- Liked Re: How to Convert yyyymmdd(numeric) to DATE9 format? for r_behata. 12-24-2018 08:37 AM
- Liked Re: How to Convert yyyymmdd(numeric) to DATE9 format? for Jagadishkatam. 12-24-2018 08:37 AM
- Posted Re: How to Convert yyyymmdd(numeric) to DATE9 format? on New SAS User. 12-24-2018 08:36 AM
-
Posts I Liked
Subject Likes Author Latest Post 1 1 6 3 3
02-27-2019
01:54 PM
Hi , You try your query using the below example. data x;
dt = symget ('runasofdate');
rndt = cats("'",dt,"'");
call symput ('rndt',rndt);
mnth = substr(dt,1,6);
call symput('m_key',strip(mnth));
run;
Regards, Ashok Arunachalam
... View more
02-15-2019
04:25 AM
Im trying to test the AML scenerio(SAS10024) in SAS ECM but im geeting the below error. Could some one help me how do I resolve it. 2192 +
2193 +- p10078_pri_medium_desc
2194 +List denoting primary mediums
2195 +================================================================================
2196 +
2197 +================================================================================
2198 +Copyright (c) 2012-2013 by SAS Institute Inc., Cary, NC 27513 USA
2199 +- All rights reserved
2200 +==============================================================================*/
2201 +
2202 +%put in REG10078 before seg parms;
in REG10078 before seg parms
2203 +
2204 +/* macro call before referencing any macro parameter */
2205 +%psd_get_seg_parms(seg_scn_nm = "REG10078", seg_scn_seg = party_segment{n});
_
180WARNING: Apparent invocation of macro PSD_GET_SEG_PARMS not resolved.ERROR 180-322: Statement is not valid or it is used out of proper order.
... View more
01-02-2019
08:42 AM
Hi , I,m trying to calculate percentile (0,.25 ,.5 ,.75,1) for 30 million data. Have tried with Proc Mean/Univariant but I'm getting below errors . Proc Mean: Error WARNING: A shortage of memory has caused the quantile computations to terminate prematurely for QMETHOD=OS. Consider using QMETHOD=P2. NOTE: The affected statistics will be missing from the corresponding classification levels. WARNING: A shortage of memory has caused the quantile computations to terminate prematurely for QMETHOD=OS. Consider using QMETHOD=P2. Proc Univariant : ERROR: The SAS System stopped processing this step because of insufficient memory. WARNING: The data set SASPL2.ALL_PERCENTILE may be incomplete. When this step was stopped there were 0 observations and 31 variables. WARNING: Data set SASPL2.ALL_PERCENTILE was not replaced because this step was stopped. Kindly help if there is any other way to calculate the percentile. Regards, Ashok Arunachalam
... View more
12-26-2018
03:18 AM
Thank you ...its working
... View more
12-26-2018
03:17 AM
Thank you Jagadish.
... View more
12-24-2018
08:37 AM
Hi, Thanks for the update!!! below is my scenario, I'm having the table Trans_month(column) which is in date format (yymmn6.)--> ex :201810. And im trying to run the below code/logic to extract the data. %let runasofdate = 20181001; options mprint mlogic symbolgen; %put &runasofdate.; data x; dt = symget ('runasofdate'); rndt = cats("'",dt,"'"); call symput ('rndt',rndt); mnth = substr(dt,1,6); call symput('m_key',strip(mnth)); run; data _test; set PARTY_PROF; where tran_month=&m_key.; run; while running the above code im getting nil records ,even though im having the data in the main table. Regards, Ashok Arunachalam
... View more
12-24-2018
08:36 AM
Hi Jag, Thanks for the update!!! below is my scenario, I'm having the table Trans_month(column) which is in date format (yymmn6.)--> ex :201810. And im trying to run the below code/logic to extract the data. %let runasofdate = 20181001; options mprint mlogic symbolgen; %put &runasofdate.; data x; dt = symget ('runasofdate'); rndt = cats("'",dt,"'"); call symput ('rndt',rndt); mnth = substr(dt,1,6); call symput('m_key',strip(mnth)); run; data _test; set PARTY_PROF; where tran_month=&m_key.; run; while running the above code im getting nil records ,even though im having the data in the main table. Regards, Ashok Arunachalam
... View more
12-14-2018
09:56 AM
Hi, Kindly help me in converting YYYYMMDD (numeric) into date9. format or YYMMn6. Example : 20181201-> which is in numeric format. Regards, Ashok Arunachalam
... View more