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: 
Ashok3395
‎02-15-2023
  • 9 Posts
  • 10 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Convert date to character and group them by substr

by Fluorite | Level 6 in SAS Programming
‎02-27-2019 01:54 PM
‎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

Error while testing the scenerio in SAS ECM

by Fluorite | Level 6 in SAS Programming
‎02-15-2019 04:25 AM
‎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

Calculating percentile for Huge data.

by Fluorite | Level 6 in SAS Procedures
‎01-02-2019 08:42 AM
‎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

Re: How to Convert yyyymmdd(numeric) to DATE9 format?

by Fluorite | Level 6 in New SAS User
‎12-26-2018 03:18 AM
‎12-26-2018 03:18 AM
Thank you ...its working ... View more

Re: How to Convert yyyymmdd(numeric) to DATE9 format?

by Fluorite | Level 6 in New SAS User
‎12-26-2018 03:17 AM
‎12-26-2018 03:17 AM
Thank you Jagadish. ... View more

Re: How to Convert yyyymmdd(numeric) to DATE9 format?

by Fluorite | Level 6 in New SAS User
‎12-24-2018 08:37 AM
‎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

Re: How to Convert yyyymmdd(numeric) to DATE9 format?

by Fluorite | Level 6 in New SAS User
‎12-24-2018 08:36 AM
‎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

How to Convert yyyymmdd(numeric) to DATE9 format?

by Fluorite | Level 6 in New SAS User
‎12-14-2018 09:56 AM
‎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
Contact Me
Online Status
Offline
Date Last Visited
‎02-15-2023 07:25 AM
Group Hubs for Ashok3395
View All
Likes given to
Quick links