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: 
sathya66
‎11-06-2023
  • 449 Posts
  • 145 Likes Given
  • 24 Solutions
  • 44 Likes Received

datetime format in sas ddmmyyhhmmss

by Barite | Level 11 in SAS Programming
‎10-03-2023 05:07 AM
‎10-03-2023 05:07 AM
Hi Al, I am able to get the datatime in the ddmmyyhhmmss  format  but 0 is missing at start  output :-3102023100202 but looking for :- 03102023100202   %let now=%sysfunc(datetime()); %let date_time = %sysfunc(inputn(%sysfunc(putn(%sysfunc(datepart(&now)),DDMMYYN8.)),8.))%sysfunc(timepart(&now),B8601TM6); %put &date_time.; Thanks, SS ... View more

lsf waiting jobs issue

by Barite | Level 11 in Administration and Deployment
‎07-28-2023 06:35 AM
‎07-28-2023 06:35 AM
Hi All, One of the flow is waiting state always so we have killed 657895 ,65457 and exited flow  659126 flow instances but the jobs inside the flow are still in waiting(see the screenshot)  state so I have deleted the flow instance files  (657895.dat,65457.dat and 659126.dat) from the server . location:- <pm>flow_instance_storage/finished or active even after deleting them . I can see them in the flow manager and new flow instance is not triggering again due to jobs in waiting state. do I need restart any daemons?  we tried to mark them as complete to trigger the new flow instance  but we are getting below ERROR . what do we have to do in this situation? when I grep for the lsf ( ps -ef |grep -i lsf) , no jobs/flow is in running state as they are in waiting state. how can we see the waiting jobs/flows and kill/delete/mark them as complete.  Thanks, SS           ... View more

Re: If and or conditions in SAS

by Barite | Level 11 in SAS Programming
‎06-01-2023 08:38 AM
‎06-01-2023 08:38 AM
My output is different. See my output below it is printing "doesn't exist" 28 %put &COL &COL2 &POST &POST2 &DEPOT &DEPOT2; 833.49 0.68 0 0 130 0.13 29 %macro test; 30 31 %if (&COL>1000 or &COL2>5 or &POST>0 or &POST2>0 or &depot>1000 or &depot2>1 ) %then %do; 32 %put "doesn't exist"; 33 %end; 34 %else %do; 35 proc print data=sashelp.class; 36 run; 37 %end; 38 %mend; 39 %test; "doesn't exist" ... View more

Re: If and or conditions in SAS

by Barite | Level 11 in SAS Programming
‎06-01-2023 08:10 AM
‎06-01-2023 08:10 AM
%put COl=&COL ; COl= 833.49 %put Col2=&COL2; Col2=0.68 %put POST=&POST ; POST=0 %put POST2=&POST2 ; POST2=0 %put DEPOT=&DEPOT ; DEPOT= 130 %put DEPOT2=&DEPOT2; DEPOT2=0.13 ... View more

Re: If and or conditions in SAS

by Barite | Level 11 in SAS Programming
‎06-01-2023 08:06 AM
‎06-01-2023 08:06 AM
Sorry yes, it is &depot2 ... View more

If and or conditions in SAS

by Barite | Level 11 in SAS Programming
‎06-01-2023 06:51 AM
‎06-01-2023 06:51 AM
I am trying to get the output if  if conditions are met then output something or print table but Conditions doesn't work. Even below condition is true or not true it always giving true output. Tried with different true or false conditions but it prints always true condition which is not right. Am I missing some logic. See the attached file for data. proc import datafile="/test/test.xls " out=test dbms=xls replace; run; proc sql noprint; select Despatches into :COL from test where inflight_type = 'Collect' ; quit; proc sql noprint; select a2_Sales into :COL2 from test where inflight_type = 'Collect' ; quit; proc sql noprint; select Despatches into :POST from test where inflight_type = 'Post'; quit; proc sql noprint; select a2_Sales into :POST2 from test where inflight_type = 'Post' ; quit; proc sql noprint; select Despatches into :DEPOT from test where inflight_type = 'Depot'; quit; proc sql noprint; select a2_Sales into :DEPOT2 from test where inflight_type = 'Depot' ; quit; %put &COL &COL2 &POST &POST2 &DEPOT &DEPOT2; %macro test; %if (&COL>1000 or &COL2>5 or &POST>0 or &POST2>0 or &depot>1000 or &depot2>1 ) %then %do; %put "doesn't exist"; %end; %else %do; proc print data=sashelp.class; run; %end; %mend; %test;    ... View more

Re: unable to open a particular job in SAS DI Studio

by Barite | Level 11 in SAS Data Management
‎05-11-2023 04:58 AM
‎05-11-2023 04:58 AM
Hi,  We resolved this by creating the same job with different name. Your metadata might be corrupted and also  memory settings didn't help us. try below options 1. Delete your job and try importing that job  from development 2. Create same job with different name(you would need to change all the jobname across other ENVs ).  ... View more

Proc S3 using I am role- example

by Barite | Level 11 in SAS Programming
‎05-02-2023 10:58 AM
‎05-02-2023 10:58 AM
Hi All,   I am trying to list the files in S3 by using I am role I am getting syntax error as SAS is not recognising  role name as an option. https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/proc/n1volodm4xnj3xn1s99poiemcha2.htm above docs says  Support for this option was added in SAS 9.4M7 proc s3 rolename="s3AccessRole" ; If I use config and creds then it is working. but I need to use I am role only . can you suggest if there is a way we can use I am role in SAS 9.4 M6 proc s3 awsconfig="config_path" awscredentials="creds_path" ; list "bucket_path" ; run; ... View more

Re: SAS Emi -framework ERROR

by Barite | Level 11 in Administration and Deployment
‎04-24-2023 12:18 PM
2 Likes
‎04-24-2023 12:18 PM
2 Likes
Thank you. I have used -dv options in the initialization script and seen that SAS EVM agent is not started properly . I have restarted it and worked fine now. ... View more

SAS Emi -framework ERROR

by Barite | Level 11 in Administration and Deployment
‎04-24-2023 06:52 AM
‎04-24-2023 06:52 AM
Hi All, Emi-framework is failing. See below No configured Stored Process Server found but when we validated from SMC  stored process is validated successfully and also same from the weblink.       ... View more

Reconfigure the WebDAV URL for the applications via code

by Barite | Level 11 in Administration and Deployment
‎04-05-2023 07:04 AM
‎04-05-2023 07:04 AM
Hi All, To reconfigure the WebDAV URL for the applications, we perform the following steps in SAS Management Console: https://documentation.sas.com/doc/en/bicdc/9.4/bimtag/n1uh9f02c7lsnzn1cu57z20h95m8.htm 1. Select Environment Management ->Foundation Services Manager. 2. Select the application and then select Core ->Information Service. 3. Right‐click Information Service and select Properties. 4. In the Information Service Properties dialog box, click the Service Configuration tab and then click Configuration. 5. In the Information Service Configuration dialog box, click the Repositories tab. 6. Select WebDAV and then click Edit.   is there a way we  can do it via code? ... View more

Re: SAS 9.4 Grid manager for platform --cluster info

by Barite | Level 11 in Administration and Deployment
‎03-28-2023 05:14 AM
‎03-28-2023 05:14 AM
server.log. 2023-03-28 09:51:27,939 INFO (Catalina-utility-1) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/PlatformWebServices]] No Spring WebApplicationInitializer types detected on classpath 2023-03-28 09:51:28,612 ERROR (Catalina-utility-1) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/PlatformWebServices]] Exception sending context initialized event to listener instance of class [com.platform.pws.listener.StartupListener] java.lang.UnsatisfiedLinkError: /data/Lev1/Web/WebAppServer/SASServer14_1/sas_webapps/platform.web.services.war/WEB-INF/lib/lsf10.1/linux-x86_64/liblsfservice.so: libsec_ego_default.so: cannot open shared object file: No such file or directory at java.lang.ClassLoader$NativeLibrary.load(Native Method) ~[?:1.8.0_252] at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1934) ~[?:1.8.0_252] at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1817) ~[?:1.8.0_252] at java.lang.Runtime.load0(Runtime.java:810) ~[?:1.8.0_252] at java.lang.System.load(System.java:1088) ~[?:1.8.0_252] at com.platform.gui.pac.batchservice.LSFService.<clinit>(LSFService.java:103) ~[classes/:?] at com.platform.gui.pac.batchservice.LSFServiceProxy.<init>(LSFServiceProxy.java:16) ~[classes/:?] at com.platform.gui.pac.batchservice.LSFServiceProxy.getInstance(LSFServiceProxy.java:27) ~[classes/:?] at com.platform.pws.util.NonShareHelper.<init>(NonShareHelper.java:94) ~[classes/:?] at com.platform.pws.util.NonShareHelper.getInstance(NonShareHelper.java:227) ~[classes/:?] at com.platform.pws.listener.StartupListener.contextInitialized(StartupListener.java:87) ~[classes/:?] at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4768) [catalina.jar:9.0.55] at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5230) [catalina.jar:9.0.55] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) [catalina.jar:9.0.55] at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:726) [catalina.jar:9.0.55] at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:698) [catalina.jar:9.0.55] at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:696) [catalina.jar:9.0.55] at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:690) [catalina.jar:9.0.55] at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1889) [catalina.jar:9.0.55] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_252] at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_252] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) [?:1.8.0_252] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) [?:1.8.0_252] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_252] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_252] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:9.0.55] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_252] 2023-03-28 09:51:28,616 INFO (Catalina-utility-1) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/PlatformWebServices]] Initializing Spring root WebApplicationContext 2023-03-28 09:51:30,706 ERROR (Catalina-utility-1) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/PlatformWebServices]] Exception sending context initialized event to listener instance of class [org.springframework.web.context.ContextLoaderListener] org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'synchronizeTask' defined in ServletContext resource [/WEB-INF/classes/spring-security-pac.xml]: Invocation of init method failed; nested exception is java.lang.NoClassDefFoundError: Could not initialize class com.platform.gui.pac.batchservice.LSFService at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1619) ~[spring-beans-4.3.26.RELEASE.jar:4.3.26.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:553) ~[spring-beans-4.3.26.RELEASE.jar:4.3.26.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:481) ~[spring-beans-4.3.26.RELEASE.jar:4.3.26.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:312) ~[spring-beans-4.3.26.RELEASE.jar:4.3.26.RELEASE] ... View more

Re: SAS 9.4 Grid manager for platform --cluster info

by Barite | Level 11 in Administration and Deployment
‎03-27-2023 11:24 AM
‎03-27-2023 11:24 AM
LSF environment profile has sourced in PWS web apps server (checked my response file ) ... View more

Re: SAS 9.4 Grid manager for platform --cluster info

by Barite | Level 11 in Administration and Deployment
‎03-27-2023 10:49 AM
‎03-27-2023 10:49 AM
yes, I can, see the results below lsid IBM Spectrum LSF Standard 10.X.X.X, Oct 16 2019 Copyright International Business Machines Corp. 1992, 2016. US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp. My cluster name is sas_cluster My master name is hostname Cluster in ISV mode : SAS ... View more

Re: SAS 9.4 Grid manager for platform --cluster info

by Barite | Level 11 in Administration and Deployment
‎03-27-2023 10:00 AM
‎03-27-2023 10:00 AM
Mid-tier is configured as LSF client but when configuring Mid-tier , I haven't started lsf services . Is it an issue? or we must start the lsf services on mid-tier before configuring mid-tier? I just started lsf services (ex:lim) but I can't see the cluster,hosts ,jobs,etc info on the web page. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎11-06-2023 01:01 PM
Likes given to
Quick links