About shubhayog

shubhayog · ‎01-05-2017

I will also suggest the same thing, you can direct substract 10 seconds from your date, because your date is already saved in datetime format.

shubhayog · ‎05-18-2016

Try Using SAS Macros, Ex. Considering you have multiple sorting operations on multiple datasets, %macro srt(idsn=,odsn=,byvar=); proc sort data=&isdn out=&odsn; by=&byvar; run; %mend; %srt(idsn=have,odsn=want,byvar=var1);

shubhayog · ‎03-17-2016

One more way--------------------------, data test1; input ID VAR1 VAR2 VAR3; datalines; 1 1 1 1 1 2 2 2 1 3 3 3 1 4 4 4 2 1 1 1 2 2 2 2 2 3 3 3 2 4 4 4 3 1 1 1 3 2 2 2 3 3 3 3 3 4 4 4 4 1 1 1 4 2 2 2 4 3 3 3 4 4 4 4 ; run; proc sort data=test1 nodupkey dupout=test2; by ID; run; proc sort data=test2 nodupkey dupout=test3; by ID; run; proc sort data=test3 nodupkey dupout=test4; by ID; run; Thanks, Yogesh

shubhayog · ‎03-17-2016

Hi fengyuwuzu, Grretings of the day!!! I guess you can use FIRSTOBS= and OBS= options too. Regards, Yogesh

shubhayog · ‎04-15-2015

Hi, I guess you should convert the date variables to the appropriate format (Say Date9.) before merging the both datasets and then go for merging. Hope this will resolve your issue. Regards, Yogesh

shubhayog · ‎04-15-2015

Hi, Please try following code, Hope It will work as you expecting. data have1; set have; drop REVN_MO_DESC1 RSD_CU_CNT; run; proc sort data=have1 out=have2 nodup; by _all_; run; data have3; set have2; n+1; run; proc sort data=have out=have4; by SITE SA_ID CA_ID REVN_MO_DESC1; run; data have5; merge have4 have3; by SITE SA_ID CA_ID; run; data want; set have5; if first.n then FIRST=1; else FIRST=0; if last.n then LAST=1; else LAST=0; by n; drop n; run; Regards, Yogesh

shubhayog · ‎04-14-2015

Hi, You remove the quotes and try hopefully it will work for you. ex. t1.'Sum of Total Retail Price'n < (Salary / 0.5) Yogesh

shubhayog · ‎03-28-2015

Hi, I have updated your data as follows for checking multiple conditions, I hope the following code will help you, data have; input Pat_ID$ Service_Date mmddyy10. ID; format Service_Date mmddyy10.; datalines; A 1/2/2012 11 A 1/2/2012 12 A 2/21/2012 9 B 4/22/2012 11 B 4/25/2012 11 C 2/21/2012 11 C 3/14/2012 10 C 3/14/2012 11 C 3/14/2012 9 D 3/1/2012 9 D 3/5/2012 12 ; run; proc sort data=have out=want1 nouniquekey; by Pat_ID Service_Date; run; proc sort data=have; by Pat_ID Service_Date; run; data want2; set have; by Pat_ID Service_Date; if first.Service_Date and last.Service_Date; run;

shubhayog · ‎03-27-2015

Hi pp2014, I guess this will help you, data have; input id $ dt yymmdd10. status $; cards; 1 20141203 D 1 20141210 D 1 20141210 A 1 20141210 S 2 20150104 A 2 20150115 D 2 20150118 S 2 20150118 D 2 20150118 A 3 20150210 S 3 20150213 D 3 20150223 D 3 20150223 S ; run; data int1; set have; if status eq 'D' then temp1=1; if status eq 'S' then temp1=2; if status eq 'A' then temp1=3; run; proc sort data=int1; by id dt temp1; run; data int2; set int1; if last.id then temp2=1; by id; run; data want; format dt monyy7.; set int2; where temp2=1; drop temp1 temp2; run; Regards, Yogesh

shubhayog · ‎03-26-2015

Hi, Your code will not work I guess in case of dataset like data have; input month geo_id$; datalines; 1 A 1 B 1 C 2 A 2 D 2 E 3 A 3 C 3 D ; run; Yogesh

shubhayog · ‎03-07-2015

Hi, Thank you very much for help. Regards, Yogesh

shubhayog · ‎03-07-2015

Hi, How can we retain the cluster values, can you please explain with SAS Code? Sorry but I am new so please dont mind. Regards, Yogesh

shubhayog · ‎02-26-2015

Hi Tal, I would like to update the reply from Jagadishkatam, Please try with following Data have; input FNAME$ LNAME$ ID SCORE$; datalines; John smith. 100 a John smith. 100 b Tom. Fonda. 200 a Tom. Fonda. 300 b Mila. Fonda. 400 a Mila. smith. 500 a Zen Fonda. 600 b Tom. smith. 700 c ; run; proc sort data=have; by FNAME LNAME ID; run; data want; set have; by FNAME LNAME ID; if first.ID then ISEQ=1; else ISEQ+1; if first.LNAME then LSEQ=1; else LSEQ+1; run; data all (drop=ISEQ LSEQ); merge want have; by FNAME LNAME ID; if ISEQ eq LSEQ; run; Hope it will work for you, Please share if any abnormal observations. Thank you Jagadishkatam for hint Thanks and Regards, Yogesh

shubhayog · ‎02-25-2015

Hi Sailesh, Try to install with port other than 8080, I am not sure it will work but at list we can try. Best of luck!!! Yogesh

Online Status	Offline
Date Last Visited	‎01-05-2017 09:38 AM

Re: Timestamp Manipulation

Re: How do I run the same script for multiple input data sets?

Re: split file based on number of IDs

Re: split file based on number of IDs

Re: problem with dates

Re: Help on creating a first and last observation for a report due tom...

Re: Error whilst Filtering

Re: How to check if the first and last date of ids are the same?

Re: Help with getting Last Status Each month

Re: Creating cumulative counts over period of time

Re: How can we write text to an external text file and on output windo...

Re: Spliting a string into variable

Re: Spliting a string into variable

Re: Help on creating a first and last observation for a report due tom...

Re: Problem with missing date value

Re: How do I run the same script for multiple input data sets?

Re: Error whilst Filtering

Re: Help on creating a first and last observation for a report due tom...

Re: How to check if the first and last date of ids are the same?

Re: need help with this pls

Re: Timestamp Manipulation

Re: How do I run the same script for multiple input data sets?

Re: split file based on number of IDs

Re: split file based on number of IDs

Re: problem with dates

Re: Help on creating a first and last observation for a report due tom...

Re: Error whilst Filtering

Re: How to check if the first and last date of ids are the same?

Re: Help with getting Last Status Each month

Re: Creating cumulative counts over period of time

Re: Data Manipulation

Re: Data Manipulation

Re: need help with this pls

Re: While installing SAS VA on Linux, I have been facing a problem wit...