About georgel

georgel · ‎01-03-2021

Impressive! Thanks a million Keintz

georgel · ‎01-03-2021

Hi Keintz I have corrected my initial post to be the average 3.65 Thanks

georgel · ‎01-03-2021

Hi novinosrin, 1. Yes . 2. (4.7+2.6)/2=3.65 I made a mistake in my initial table. Many thanks in advance Regards George

georgel · ‎01-03-2021

Hi to all , Wish you Happy New Year 2021! I would like to replace missing values with average and the rest that have missing till the end to leave them as are. data have; input cusip_id $8. Name $6. date_issue :ddmmyy10. type $5. Ret dollar8.1; format date_issue ddmmyy10. ; datalines; 10343452 Zilas 01/04/2016 main 3.2 10343452 Zilas 02/04/2014 main 4.5 10343452 Zilas 03/04/2012 main 6.6 10343452 Zilas 04/04/2011 main . 10343452 Zilas 05/04/2017 main 7.7 10343452 Zilas 06/04/2017 main . 10343452 Zilas 07/04/2017 main . 10343452 Zilas 08/04/2017 main . 10343453 Astra 01/04/2016 main 6.2 10343453 Astra 02/04/2014 main 5.5 10343453 Astra 03/04/2012 main 2.6 10343453 Astra 04/04/2011 main . 10343453 Astra 05/04/2011 main . 10343453 Astra 06/04/2017 main 4.7 10343453 Astra 07/04/2017 main . 10343453 Astra 08/04/2017 main 8 10343453 Astra 09/04/2017 main . 10343453 Astra 10/04/2017 main . 10343453 Astra 11/04/2017 main . 10343453 Astra 12/04/2017 main . 10343453 Astra 13/04/2017 main . ; run; data want; input cusip_id $8. Name $6. date_issue :ddmmyy10. type $5. Ret dollar8.1; format date_issue ddmmyy10. ; datalines; 10343452 Zilas 01/04/2016 main 3.2 10343452 Zilas 02/04/2014 main 4.5 10343452 Zilas 03/04/2012 main 6.6 10343452 Zilas 04/04/2011 main 7.15 10343452 Zilas 05/04/2017 main 7.7 10343452 Zilas 06/04/2017 main . 10343452 Zilas 07/04/2017 main . 10343452 Zilas 08/04/2017 main . 10343453 Astra 01/04/2016 main 6.2 10343453 Astra 02/04/2014 main 5.5 10343453 Astra 03/04/2012 main 2.6 10343453 Astra 04/04/2011 main 3.65 10343453 Astra 05/04/2011 main 3.65 10343453 Astra 06/04/2017 main 4.7 10343453 Astra 07/04/2017 main 6.35 10343453 Astra 08/04/2017 main 8 10343453 Astra 09/04/2017 main . 10343453 Astra 10/04/2017 main . 10343453 Astra 11/04/2017 main . 10343453 Astra 12/04/2017 main . 10343453 Astra 13/04/2017 main . ; run; Many thanks in advance

georgel · ‎01-03-2021

Hi please try this :I just made some nesting for fiinding the "/" data tocorrect; input date_to_amend $30. ; datalines; 1/25/2017 4:49:01 PM 12/1/2017 12:07:00 PM ; run; data corrected ; set tocorrect; format sasdate DATE9.; format month 8.; format day 8.; format year 8.; month=substr(date_to_amend,1, find(date_to_amend,"/")-1); day=substr(substr(date_to_amend, find(date_to_amend,"/")+1,length(date_to_amend)),1, find(substr(date_to_amend, find(date_to_amend,"/")+1,length(date_to_amend)),"/")-1); year = substr(substr(date_to_amend,1, find(date_to_amend," ")-1),length(substr(date_to_amend,1, find(date_to_amend," ")-1))-3,4); sasdate=mdy(month,day,year); run;

georgel · ‎12-28-2020

/*Graphs and info of 2way Models*/ proc sgplot data=predpN_mm_bt; title "Predicted vs Actual Graph of 2way Model"; scatter x=pred_btpN_mm y=pN; lineparm x=0 y=0 slope=1 / legendlabel="1:1 line"; /** intercept, slope **/ yaxis values=(0.4 to 1.4 by 0.2) label="Measured pN (%)"; xaxis values=(0.4 to 1.4 by 0.2) label="Predicted pN Ground Reference (%)"; run; Just remove the grids. That 's all!!!!!!

georgel · ‎12-28-2020

Absolutely Clever Way using proc freq done by a sharp person! Only a few lines! Thanks a million Ksharp! I have tested it. Great. You know CREATIVITY= CLEVERNESS

georgel · ‎12-27-2020

Bart Many thanks for the solution. I have tested it. It works perfectly.

georgel · ‎12-27-2020

Tom thank you so much for the simplification

georgel · ‎12-27-2020

ABSOLUTELY PERFECT! THANKS A MILLION singhsahab

georgel · ‎12-27-2020

Hi I am trying to split the data set into many here is the data have : data have; input cusip_id Name $10. date_issue :ddmmyy10. type $10.; format date_issue ddmmyy10.; datalines; 10343452 Zingas 01/04/2016 bench 10343489 Stephanie 01/04/2014 main 10343445 Olivia 01/04/2012 main 10343456 Amstel 01/04/2011 bench 10343457 KEO 01/04/2017 main ; run; My solution: data data_main; set have; If type="main"; run; data data_bech; set have; If type="bench"; run; This is in fact an awkard/cumbersome solution. I would like to utilize a more efficient algorithm for advanced SAS programming to avoid repetition of code. e.g. using proc sql distinct to set the values in a macro variable Please I am looking forward from your prompt reply

georgel · ‎12-26-2020

Dear Kurt Many thanks for this solution and for your quick response. I really appreciated your help Regards George

georgel · ‎12-26-2020

This is exactly what I wanted. Great Many thanks Regards George

georgel · ‎12-26-2020

Hi all Best wishes to all of you for 2021 I am trying to find a simple solution for the the data I have data have; input cusip_id Name $10. date_issue :ddmmyy10. datadate :ddmmyy10. ; format date_issue ddmmyy10.; format datadate ddmmyy10.; datalines; 10343452 Henry PLC 01/04/2014 31/12/2012 10343452 Henry PLC 01/04/2014 31/12/2013 10343452 Henry PLC 01/04/2014 31/12/2014 10343452 Henry PLC 01/04/2014 31/12/2015 10343452 Henry PLC 01/04/2014 31/12/2016 ; run; /*WHAT I WANT*/ data want ; input cusip_id Name $10. date_issue :ddmmyy10. datadate :ddmmyy10. ; format date_issue ddmmyy10.; format datadate ddmmyy10.; datalines; 10343452 Henry PLC 01/04/2014 31/12/2013 ; run; My solution: data have; set have; If dat_issue>=datadate; run; proc sort data=want out=want; by cusip descending datadate ; run; proc sort data=want out=want nodupkeys; by cusip ; run; Is there a way to be efficient and have this in a single step. Can this be done in proc sql when I join the cusip and issue_date with the dataset of compustat (that includes all the fiscal years i.ie datadate)? Many thanks in advance Regards George

georgel · ‎12-14-2020

Bart Many thanks for your prompt reply I will try the alternatives George

Online Status	Offline
Date Last Visited	‎10-31-2023 06:15 AM

Re: proc optmodel save output in a dataset

proc optmodel save output in a dataset

Re: Iterative Excel Solver in SAS changing variable

Iterative Excel Solver in SAS changing variable

Re: Transfer macro variable to a query after rsubmit statement

Re: Transfer macro variable to a query after rsubmit statement

Transfer macro variable to a query after rsubmit statement

Re: Macro errors

Re: Macro errors

Macro errors

Re: proc optmodel save output in a dataset

Re: Transfer macro variable to a query after rsubmit statement

Re: Transfer macro variable to a query after rsubmit statement

Re: returns=B

Re: Using prefix before a variable in proc transpose

Re: Replacing Missing values with average

Re: Replacing Missing values with average

Re: Replacing Missing values with average

Replacing Missing values with average

Re: How to convert characters that are not in a proper date format int...

Re: Remove gridlines in Proc SGPLOT

Re: How to split one dataset too many based on the values (categorical...

Re: How to split one dataset too many based on the values (categorical...

Re: How to split one dataset too many based on the values (categorical...

Re: How to split one dataset too many based on the values (categorical...

How to split one dataset too many based on the values (categorical) on...

Re: Find the latest date before a specific date

Re: Find the latest date before a specific date

Find the latest date before a specific date

Re: ERROR: Unrecognized option, !. when sumbitting my password