Hi Friends, I want to sum the time. I am using the below query but not getting the accurate sum of Hours. Please see the attached CSV file. proc sql; create table z as select sum(time) as sum format=tod10. from totaltime; quit; Kindly help !
... View more
Hi guys , I am doing inner join using proc sql, please see the below code.
data am; input name$ age; datalines; am 89 am 78 am 45 na 23 ; run; data am1; input name$ marks; datalines; am 789 am 9081 na 2670 pa 89 sa 90 ka 09 ; run; proc sql; select * from am,am1 where am.name=am1.name; quit;
Question : Why age=78 is below the age=45 where as in data step age=78 is above. Request, kindly explain. SAS Output:
name age name marks
am
89
am
789
am
45
am
789
am
78
am
789
am
89
am
9081
am
45
am
9081
am
78
am
9081
na
23
na
2670
... View more
I was doing this but couldn't get through: data d(keep=username duration time); set a; time=substr(duration,1,1)||':'||substr(duration,4,2)||':'||compress(substr(duration,10,2),'','kd'); run;
... View more
Hi , Candidate Duration Arun 0hr 0min 44sec. Arun 0hr 0min 9sec. Arun 12hr 4min 10sec. Vishal 1hr 0min 24sec. Vishal 0hr 0min 35sec. Vishal 0hr 7min 29sec. Vishal 2hr 1min 9sec. A) I want to find the total sum of duration candidate wise. B) How to covert duration to Time format (eg: 1:04:10)
... View more
Hi, I mean to say If Nitin worked on 2 May 2014 Also Abhishek worked on 2 May 2014 then if i use nodupkep on days_worked then i will not get accurate results. Though proc sql is the best way to solve it , just wanted to know if it can be done using base sas. Thank you so much for your time.
... View more
This one is not working since there are sames dates the user have worked, so if i apply a nodupkey then the same dates get deleted. So i do not get the accurate result. The proc sql works , if its possible to do it by base sas then pl let me know. Thank you for your time Jagdish.
... View more
Hi Guys, I need to find out Total Number of days each user has worked, Kindly tell me how i can do it using BASE SAS & PROC SQL. Waiting for a response. Thank you 🙂
... View more
