About rajd1

rajd1 · ‎10-01-2021

@Reeza : Yes, there might be < or > <= or >=

rajd1 · ‎10-01-2021

Hi all, I have a character variable that needs to be converted to numeric. The character <0.001 needs to be converted to 0.001 numeric value. Data Have: data have; input iD nums $; cards; 1 1.675 2 <0.001 3 3.578 4 <0.00001 ;

rajd1 · ‎12-23-2020

Thank you sir!

rajd1 · ‎12-23-2020

@novinosrin, I tried that and also changed the order by statement. Problem is that i still get both values in Prediff and Post diff 😞 😞

rajd1 · ‎12-23-2020

Hi @novinosrin, I edited the data accordingly, sorry the formatting was off. So basically for the Gname ER, the closest Date difference for pre and post is what i need. For example in the new data, for the ER Gname the closest date difference for prediff is 9.79 and the postdiff is 18.20. Using the previous code, it gives all the Date_difference by Generic name.

rajd1 · ‎12-23-2020

Hi @novinosrin, Thanks so much for this. I have another example where this code didn't work. I have edited my original message and added extra data. Thanks so much

rajd1 · ‎12-23-2020

Hello, MY dataset has date difference (ADMIN – REPORT) variable for specific Gname. I want to pick the closest dates between the admin date and report date. For example, for ID#1, GName = ER, generic name = Lap the date difference of +13.7 is closest so it goes under PostDiff. Similarly, date difference of -37.29 is closest on the negative side so this goes under prediff. Also, all unique Gnames by ID should be listed. Thanks a lot! Data Have: ID GName Report Admin Generic_name Date_Diff 1 ER 9/8/2016 6/21/2016 Ado -79.2919 1 ER 9/8/2016 5/31/2016 Ado -100.292 1 ER 9/8/2016 7/12/2016 Ado -58.2919 1 ER 9/8/2016 9/22/2016 Lap 13.70806 1 ER 9/8/2016 8/2/2016 Ado -37.2919 1 ER 9/8/2016 10/11/2016 Lap 32.70806 1 MY 9/8/2016 1 NF 9/8/2016 1 TP 9/8/2016 2 EG 3/14/2017 2 ER 3/14/2017 2 ER 9/8/2016 2 ES 9/8/2016 2 ES 3/14/2017 2 MY 3/14/2017 2 MY 9/8/2016 2 NF 3/14/2017 2 NF 9/8/2016 2 PT 3/14/2017 3 CC 9/11/2016 8/25/2015 Pal -383.8 3 CC 9/11/2016 11/9/2015 Pal -307.8 3 ES 9/11/2016 5/26/2015 Ful -474.8 3 ES 9/11/2016 7/26/2015 Ful -413.8 3 ES 9/11/2016 1/19/2015 Ful -601.8 3 ES 9/11/2016 6/23/2015 Ful -446.8 3 ES 9/11/2016 3/24/2015 Ful -537.8 3 ES 9/11/2016 4/28/2015 Ful -502.8 3 ES 9/11/2016 2/22/2015 Ful -567.8 3 FG1 9/11/2016 3 FG2 9/11/2016 3 FG3 9/11/2016 3 PI 9/11/2016 7/3/2017 Eve 294.1999 3 PI 9/11/2016 2/6/2017 Eve 147.1999 Data Want: ID Gname Report Generic_name Admin PreDiff PostDiff 1 ER 9/8/2016 Ado 8/2/2016 37 1 ER 9/8/2016 Lap 9/22/2016 14 1 MY 9/8/2016 1 NF 9/8/2016 1 TP 9/8/2016 2 ER 9/8/2016 2 ES 9/8/2016 2 MY 9/8/2016 2 NF 9/8/2016 2 EG 3/14/2017 2 ER 3/14/2017 2 ES 3/14/2017 2 MY 3/14/2017 2 NF 3/14/2017 2 PT 3/14/2017 3 CC 9/11/2016 Pal 11/9/2015 308 3 ES 9/11/2016 Ful 7/26/2015 414 3 FG1 9/11/2016 3 FG2 9/11/2016 3 FG3 9/11/2016 3 PI 9/11/2016 Eve 2/6/2017 147 Extra Data Have: ID Gname Report Admin Generic_name Date_Diff 25 ER 9/14/2016 9/19/2017 Lap 369.2088 25 ER 9/14/2016 9/4/2013 Tra -1106.79 25 ER 9/14/2016 5/27/2013 Tra -1206.79 25 ER 9/14/2016 8/16/2016 Tra -29.7912 25 ER 9/14/2016 2/19/2019 Lap 887.2088 25 ER 9/14/2016 8/7/2013 Tra -1134.79 25 ER 9/14/2016 3/26/2013 Tra -1268.79 25 ER 9/14/2016 11/7/2012 Tra -1407.79 25 ER 9/14/2016 5/8/2013 Tra -1225.79 25 ER 9/14/2016 10/27/2019 Ner 1137.209 25 ER 9/14/2016 4/17/2013 Tra -1246.79 25 ER 9/14/2016 2/18/2019 Lap 886.2088 25 ER 9/14/2016 8/12/2014 Ado -764.791 25 ER 9/14/2016 6/17/2013 Tra -1185.79 25 ER 9/14/2016 11/27/2017 Lap 438.2088 25 ER 9/14/2016 1/21/2019 Lap 858.2088 25 ER 9/14/2016 1/15/2013 Tra -1338.79 25 ER 9/14/2016 2/26/2013 Tra -1296.79 25 ER 9/14/2016 7/8/2013 Tra -1164.79 25 ER 9/14/2016 12/8/2013 Ado -1011.79 25 ER 9/14/2016 6/28/2016 Tra -78.7912 25 ER 9/14/2016 7/19/2016 Tra -57.7912 25 ER 9/14/2016 12/18/2012 Tra -1366.79 25 ER 9/14/2016 10/3/2016 Lap 18.20884 25 ER 9/14/2016 4/2/2019 Ner 929.2088 25 ER 9/14/2016 9/25/2012 Tra -1450.79 25 ER 9/14/2016 1/30/2017 Lap 137.2088 25 ER 9/14/2016 4/26/2016 Tra -141.791 25 ER 9/14/2016 4/17/2018 Lap 579.2088 25 ER 9/14/2016 5/21/2012 Tra -1577.79 25 ER 9/14/2016 9/25/2013 Tra -1085.79 25 ER 9/14/2016 7/2/2012 Tra -1535.79 25 ER 9/14/2016 8/30/2017 Lap 349.2088 25 ER 9/14/2016 4/5/2016 Tra -162.791 25 ER 9/14/2016 1/19/2016 Tra -239.791 25 ER 9/14/2016 4/3/2012 Tra -1625.79 25 ER 9/14/2016 12/1/2015 Tra -288.791 25 ER 9/14/2016 11/10/2015 Tra -309.791 25 ER 9/14/2016 9/5/2016 Lap -9.79116 25 ER 9/14/2016 3/16/2016 Tra -182.791 25 ER 9/14/2016 11/27/2012 Tra -1387.79 25 ER 9/14/2016 6/11/2012 Tra -1556.79 25 ER 9/14/2016 12/31/2013 Ado -988.791 25 ER 9/14/2016 5/20/2014 Ado -848.791 25 ER 9/14/2016 7/22/2014 Ado -785.791 25 ER 9/14/2016 2/5/2013 Tra -1317.79 25 ER 9/14/2016 8/13/2012 Tra -1493.79 25 ER 9/14/2016 9/5/2012 Tra -1470.79 25 ER 9/14/2016 12/22/2015 Tra -267.791 25 ER 9/14/2016 10/23/2013 Tra -1057.79 25 ER 9/14/2016 4/29/2014 Ado -869.791 25 ER 9/14/2016 4/30/2012 Tra -1598.79 25 ER 9/14/2016 2/18/2014 Ado -939.791 25 ER 9/14/2016 4/5/2014 Ado -893.791 25 ER 9/14/2016 5/17/2016 Tra -120.791 25 ER 9/14/2016 5/13/2018 Lap 605.2088 25 ER 9/14/2016 7/23/2012 Tra -1514.79 25 ER 9/14/2016 6/3/2019 Ner 991.2088 25 ER 9/14/2016 11/13/2013 Tra -1036.79 25 ER 9/14/2016 10/26/2016 Lap 41.20884 25 ER 9/14/2016 10/16/2012 Tra -1429.79 25 ER 9/14/2016 7/1/2014 Ado -806.791 25 ER 9/14/2016 1/21/2014 Ado -967.791 25 ER 9/14/2016 6/10/2014 Ado -827.791 25 ER 9/14/2016 2/24/2016 Tra -203.791 25 ER 9/14/2016 3/12/2014 Ado -917.791 25 F1 9/14/2016 25 F2 9/14/2016 25 F3 9/14/2016 Extra Data Want: ID Gname Report Generic_name Admin PreDiff PostDiff 25 ER 9/14/2016 Lap 9/5/2016 10 25 ER 9/14/2016 Lap 10/3/2016 18 25 F1 9/14/2016 25 F2 9/14/2016 25 F3 9/14/2016

rajd1 · ‎07-10-2020

I have a couple of variables that have long text data in excel. When I import it with import statement it stops at 175 characters. I want to be able to get full text length. PROC IMPORT OUT= WORK.ge DATAFILE= "filepath/name" DBMS=xlsx REPLACE; SHEET="One"; GETNAMES=YES; RUN; Thank you

rajd1 · ‎07-07-2020

This is great! Just as a thought if there was a way not to use the threshold value in days...

rajd1 · ‎07-06-2020

This works but the missing order for ID#7 does not show in the output dataset.

rajd1 · ‎07-06-2020

Hi all, I am trying to merge dates by the closest day. I just need help tweaking the code a little bit. I tried to look around but could not find a way to accomplish what i need. Any help is appreciated! Here are the two datasets: data aa; input id order MMDDYY10.; format order MMDDYY10.; cards; 1 7/16/2016 1 10/2/2017 2 7/17/2016 3 7/18/2016 4 12/15/2018 4 1/19/2016 5 2/21/2017 5 5/19/2018 5 8/24/2018 6 10/2/2016 6 3/10/2018 7 5/9/2018 ; data bb; input id received MMDDYY10.; format received MMDDYY10.; cards; 1 07/26/2016 1 10/22/2017 2 8/1/2016 3 8/3/2016 3 8/3/2016 4 1/6/2019 5 9/8/2018 6 3/25/2018 7 5/10/2018 7 10/10/2019 ; Data want ID Order Received 1 7/16/2016 7/26/2016 1 10/2/2017 10/22/2017 2 7/17/2016 8/1/2016 3 7/18/2016 8/3/2016 4 12/15/2018 1/6/2019 4 1/19/2016 5 2/21/2017 5 5/19/2018 5 8/24/2018 9/8/2018 6 10/2/2016 6 3/10/2018 3/25/2018 7 5/9/2018 5/10/2018 7 10/10/2019 Here is my code: proc sql; create table want as select distinct a.*,b.received from aa a left join bb b on a.id=b.id and order<=received group by a.id,order; quit; I am missing the "having" keyword after "group by". Or would this be easier in data step?

rajd1 · ‎07-01-2020

data have; input ID alpha $; cards; 1 a 1 b 1 c 2 a 2 c 3 a 3 b 4 a 4 a ; data want; do until(last.id); set have; by id; length want $100; want=catx(',',want,alpha); end; drop alpha; run; Just a minor addition: What if i had the same alpha for the same id. For example id#4 has a and a twice. I just want it to be displaced as 'a' instead of 'a,a'

rajd1 · ‎07-01-2020

Thanks a lot!

rajd1 · ‎07-01-2020

Thank you Sir

rajd1 · ‎07-01-2020

Hi, I am working with some textual data and i want to combine textual rows by ID. Data have: ID alpha 1 a 1 b 1 c 2 a 2 c 3 a 3 b 4 a Data Want: 1 a,b,c 2 a,c 3 a,b 4 a Thanks,

Online Status	Offline
Date Last Visited	‎10-02-2021 02:31 PM

Re: Covert char to numeric

Covert char to numeric

Re: assigning pre and post values

Re: assigning pre and post values

Re: assigning pre and post values

Re: assigning pre and post values

assigning pre and post values

Importing Long Text from Excel

Re: Date Merge

Re: Date Merge

Re: assigning pre and post values

Re: assigning pre and post values

Re: assigning pre and post values

Re: assigning pre and post values

Re: Date Merge

Re: Covert char to numeric

Covert char to numeric

Re: assigning pre and post values

Re: assigning pre and post values

Re: assigning pre and post values

Re: assigning pre and post values

assigning pre and post values

Importing Long Text from Excel

Re: Date Merge

Re: Date Merge

Date Merge

Re: Merging row text by ID

Re: Merging row text by ID

Re: Merging row text by ID

Merging row text by ID