Group by date using proc sql in SAS -

-

i want sum values same cost centre per each year in sas. tried group function in proc sql. 

proc sql      create table incident_data          select   cost_centre_dim.cost_centre_name,                  sum(count*amount) tot,                  occ_date format= year4.              incidents,                  incident_type,                  cost_centre_dim             incidents.incident_code = incident_type.incident_code         ,      incidents.cost_centre_id = cost_centre_dim.cost_centre_id         group cost_centre_dim.cost_centre_name,                  occ_date          order [cost centre dim].[cost centre name];  quit; run;

the output looks below:

2012  34.41  acci2  2012  34.23  acci2  2014  25.71  infr1  2014  27.82  infr1  2014  22.26  infr2  2014  20.97  infr2  2013  22.64  acci4  2013  19.29  acci4  2013  18.26  acci4  2014  35.82  acci4  2015  97.81  infr3  2015  44.04  infr3  2014  57.09  infr3

i want output show 1 line 1 type of incident per year add amount. sth this:

2012  68.64  acci2   2014  53.53  infr1   2014  43.23  infr2   ...

any advice appreciated

try converting occ_date text this: put(occ_date, year4) myocc_date

i think original code displaying date in format assigned still actual numerical value of occ_date. if change character in format want should grouping correctly.


Comments

Post a Comment

Popular posts from this blog

Java 3D LWJGL collision -

-
i making 3d java game lwjgl library, , wondering how add collision detection, player not go through models. i using obj models. here objloader class, loads models: package renderengine; import java.io.bufferedreader; import java.io.file; import java.io.filenotfoundexception; import java.io.filereader; import java.util.arraylist; import java.util.list; import models.rawmodel; import org.lwjgl.util.vector.vector2f; import org.lwjgl.util.vector.vector3f; public class objloader { public static rawmodel loadobjmodel(string filename, loader loader){ filereader fr = null; try { fr = new filereader(new file("res/"+filename+".obj")); } catch (filenotfoundexception e) { system.err.println("couldn't load file!"); e.printstacktrace(); } bufferedreader reader = new bufferedreader(fr); string line; list<vector3f> vertices = new arraylist<vector3f...
Read more

spring - SubProtocolWebSocketHandler - No handlers -

-
i have ugly error during deploying spring app on jboss. 18:11:16,025 error [org.apache.catalina.core.containerbase.[jboss.web].[default-host].[/consumer]] (msc service thread 1-7) exception sending context initialized event listener instance of class org.springframework.web.context.contextloaderlistener: org.springframework.context.applicationcontextexception: failed start bean 'subprotocolwebsockethandler'; nested exception java.lang.illegalargumentexception: no handlers @ org.springframework.context.support.defaultlifecycleprocessor.dostart(defaultlifecycleprocessor.java:176) [spring-context-4.1.3.release.jar:4.1.3.release] @ org.springframework.context.support.defaultlifecycleprocessor.access$200(defaultlifecycleprocessor.java:51) [spring-context-4.1.3.release.jar:4.1.3.release] @ org.springframework.context.support.defaultlifecycleprocessor$lifecyclegroup.start(defaultlifecycleprocessor.java:346) [spring-context-4.1.3.release.jar:4.1.3.release] @ org.s...
Read more

methods - python can't use function in submodule -

-
my folder structure this: pythonstuff/ program.py modulea/ __init__.py foo.py bar.py here's code bar.py : def hello(): print("hello, world!") here's code program.py : #!/usr/bin/env python3 modulea import bar bar.hello() i run $ python3 program.py somehow error: file "program.py", line 3, in <module> bar.hello() attributeerror: 'module' object has no attribute 'hello' edit: __init__.py file empty. edit2: after trying realized had bar.py in root directory contained hello() method. bar.py in modulea/ directory empty. add it import os __all__ = [] module in os.listdir(os.path.dirname(__file__)): if module != '__init__.py' , module[-3:] == '.py': __all__.append(module[:-3]) the init .py files required make python treat directories containing packages; done prevent directories common name, such string, unintentionally hiding v...
Read more