About NagendraKumarK

NagendraKumarK · ‎12-20-2013

Hi Garag, Please check this data _null_; abc='09:01:12't; res=compress(put(abc,time8.),':'); put res=; run;

NagendraKumarK · ‎12-12-2013

NagendraKumarK · ‎12-11-2013

Hi Sanjay, Thanks for your replay. However, there is a limitation has been found that, subgroup option cannot be used when we have datatable in PROC TEMPLATE.

NagendraKumarK · ‎12-11-2013

What i need is in similar way in excel, we can club bar chart with datatable. The same structure we can do with proc template --> and layouts but sub group will not able to create. Can any one suggest me on this?

NagendraKumarK · ‎07-08-2013

data hi; input id$ val1 / id$ val2 / id$ val3; datalines; A 1 A 2 A 3 B 1 B 2 B 3 C 1 C 2 C 3 ; run;

NagendraKumarK · ‎01-17-2013

Hi bnarang, I am not sure, what is u r request. If your request is select list of accounts from A and which are in B table. Please check this below.. proc sql; create table res from (select A.acct from A,B where A.acct=B.acct); run;

NagendraKumarK · ‎01-16-2013

Hi, Can you try this below? proc sql noprint; create table new as (select distinct put(leg,3.) as leg,treattxt, count(distinct sid) as cnt from have group by leg,treattxt having phase='active' union all select '',"total", count(distinct sid) from have where phase='active' ); quit;

NagendraKumarK · ‎01-15-2013

DATA HELLO; INPUT CUSTOMERNUM PATIENTID GROUPEND; DATALINES; 1234 1001 1045 1234 1001 1046 1234 1001 1047 1235 1002 1048 1235 1002 1049 1235 1003 1134 1235 1003 1137 1235 1003 1138 1236 1003 1234 1236 1002 1345 ; RUN; PROC SQL; CREATE TABLE RES AS (SELECT DISTINCT CUSTOMERNUM,PATIENTID,GROUPEND FROM HELLO GROUP BY CUSTOMERNUM,PATIENTID HAVING GROUPEND=MAX(GROUPEND) ); RUN;

NagendraKumarK · ‎01-15-2013

proc sql; create table res as ( select dt from hello where input(substr(dt,length(dt)-1),2.) >10 ); run;

NagendraKumarK · ‎01-15-2013

proc sql; create table res as ( select x.id,x.breakfast,c.category from (select a.id, b.breakfast from a join b on a.id=b.id) x left join c on x.breakfast=c.breakfast ); run;

NagendraKumarK · ‎01-15-2013

proc sql; create table one as (select col1,col2,col3 from hello where col2 like '%Test%' ); create table two as (select col1,col2,col3 from hello where ((col2 like 'This is ex%') or (col2 like 'Why Test%')) ); run;

NagendraKumarK · ‎01-15-2013

data hello; infile datalines; input cid date yymmdd12.; format date ddmmyy10.; datalines; 1 2012-07-01 1 2010-08-01 1 2012-07-01 2 2010-10-01 2 2010-10-01 2 2011-06-01 2 2011-06-01 3 2012-07-05 3 2012-09-07 3 2012-05-09 ; run; proc sql; create table shello as ( select distinct cid, date,count(date) as cnt from hello group by cid,date having count(date)>1 ); run; proc print data=shello; run;

Online Status	Offline
Date Last Visited	‎10-06-2015 10:29 AM

Re: time HHMMSS format

Re: Is there any way we can combine Clustered Sub Group - Bar Graph an...

Re: Is there any way we can combine Clustered Sub Group - Bar Graph an...

Is there any way we can combine Clustered Sub Group - Bar Graph and Da...

Re: Input with unique ID

Re: Simulate Proc sql nested query in Datastep

Re: proc sql total

Re: Rewrite proc sql to more effeceint query?

Re: delete observations

Re: Proc SQL - inner join and left join in one step

Re: How to convert US height values in feet' inches" to numeric value?

Re: Searching within a variable in a dataset

Re: Rewrite proc sql to more effeceint query?

Re: time HHMMSS format

Re: Is there any way we can combine Clustered Sub Group - Bar Graph an...

Re: Is there any way we can combine Clustered Sub Group - Bar Graph an...

Is there any way we can combine Clustered Sub Group - Bar Graph and Da...

Re: Input with unique ID

Re: Simulate Proc sql nested query in Datastep

Re: proc sql total

Re: Rewrite proc sql to more effeceint query?

Re: delete observations

Re: Proc SQL - inner join and left join in one step

Re: Searching within a variable in a dataset

Re: Check for identical values.