cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
sasphd
‎11-08-2024
  • 259 Posts
  • 96 Likes Given
  • 3 Solutions
  • 3 Likes Received

Re: add a dummy

by Lapis Lazuli | Level 10 in SAS Procedures
‎02-12-2021 03:39 PM
‎02-12-2021 03:39 PM
thank you for the good question. I did not have that in this case I check for the difference between the transaction date to be more than 4 ... View more

Re: add a dummy

by Lapis Lazuli | Level 10 in SAS Procedures
‎02-12-2021 01:43 PM
‎02-12-2021 01:43 PM
yes I have multiple number. but I want the dummy D=1 only for the transaction date et three dates after then it will be D=0 like this table table want  number date transaction date D 1 20150911 . 0 1 20150912 . 0 1 20150913 20150913 1 1 20150914 . 1 1 20150915 . 1 1 20150916 . 1 1 20150917 . 0   ... View more

add a dummy

by Lapis Lazuli | Level 10 in SAS Procedures
‎02-12-2021 01:06 PM
‎02-12-2021 01:06 PM
I want to add a column of dummy if tranasaction date equal date then add D=1 for that date and the next three date table have  number date transaction date 1 20150911 . 1 20150912 . 1 20150913 20150913 1 20150914 . 1 20150915 . 1 20150916 . table want  number date transaction date D 1 20150911 . 0 1 20150912 . 0 1 20150913 20150913 1 1 20150914 . 1 1 20150915 . 1 1 20150916 . 1 ... View more

join table by id

by Lapis Lazuli | Level 10 in SAS Procedures
‎02-05-2021 01:56 PM
‎02-05-2021 01:56 PM
Hello,  I want to join table by id Table A id date            price 1  20170101    10 1 20170102      12 2  20180401     8 2   20180402    5   Table B id date            price 1  20170103    15 2  20180405     4   want A and B id date            price 1  20170101    10 1 20170102      12 1  20170103    15 2  20180401     8 2   20180402    5 2  20180405     4 ... View more

Re: compare two  file NAMES

by Lapis Lazuli | Level 10 in SAS Programming
‎11-18-2020 12:02 PM
‎11-18-2020 12:02 PM
this an example all companies secid Name_MS 0P0000K4GS Abengoa SA ADR 0P0000ETZM Abcourt Mines Inc Class B 0P000177DG Abdul Mohsen Al-Hokair Group for Tourism and Development Co   list of compagnies M_id M_name 21 Abengoa 24 ABN AMRO Bank 25 ABO Wind 26 Aboitiz Power Corp   the output that I want to have  M_id M_name secid Name_MS 21 Abengoa 0P0000K4GS Abengoa SA ADR ... View more

compare two  file NAMES

by Lapis Lazuli | Level 10 in SAS Programming
‎11-18-2020 11:36 AM
‎11-18-2020 11:36 AM
I have a requirement to compare two  file NAMES the first file contains all companies in the database and the other file contains the list of compagnies that I want to find.  I want the output give the list of compagnies find in the all campagnies file.  ... View more

select max value by id

by Lapis Lazuli | Level 10 in SAS Programming
‎11-04-2020 01:39 PM
‎11-04-2020 01:39 PM
Hello I want to select the rows having the maximum value of total score by secid.    I do this but do not works  proc sql; create table max as select distinct * from CRSP_data3 having TOTAL_SCORE=max(TOTAL_SCORE) order by secid; run;   secid Fund_name Inception_date CRSP_FUNDNO FUND_NAME_CRSP TOTAL_SCORE F000002KYY JHancock Disciplined Value R4 2009-05-22 46807 John Hancock Funds III: John Hancock Disciplined Value Fund; Class R3 Shares 50 F000002KYY JHancock Disciplined Value R4 2009-05-22 46808 John Hancock Funds III: John Hancock Disciplined Value Fund; Class R4 Shares 75 F000002KYY JHancock Disciplined Value R4 2009-05-22 46809 John Hancock Funds III: John Hancock Disciplined Value Fund; Class R5 Shares 50 F000002KYY JHancock Disciplined Value R4 2009-05-22 46811 John Hancock Funds III: International Core Fund; Class R4 Shares 25 F000002KYY JHancock Disciplined Value R4 2009-05-22 46815 John Hancock Investment Trust: John Hancock Fundamental Large Cap Core Fund; Class R4 Shares 25 F000002KYY JHancock Disciplined Value R4 2009-05-22 46815 John Hancock Investment Trust: John Hancock Large Cap Equity Fund; Class R4 Shares 25 F000002KYY JHancock Disciplined Value R4 2009-05-22 46821 John Hancock Funds III: US Core Fund; Class R4 Shares 25 F000002KYY JHancock Disciplined Value R4 2009-05-22 46823 John Hancock Capital Series: John Hancock Classic Value Fund; Class R3 Shares 25 F000002KYY JHancock Disciplined Value R4 2009-05-22 46824 John Hancock Capital Series: John Hancock Classic Value Fund; Class R4 Shares 50 F000002KYY JHancock Disciplined Value R4 2009-05-22 46825 John Hancock Capital Series: John Hancock Classic Value Fund; Class R5 Shares 25 ... View more

Re: compare two names to find a match

by Lapis Lazuli | Level 10 in SAS Programming
‎11-04-2020 10:15 AM
‎11-04-2020 10:15 AM
I have checked and there is no match in the sample I give. if there is no match I want that the output table that indicate no match will like this secid Fund_name Inception_date CRSP_FUNDNO FIRST_OFFER_DT FUND_NAME_CRSP F000000DL0         . F000000JLW         .     however this is an example where we find a match secid Fund_name Inception_date CRSP_FUNDNO FIRST_OFFER_DT FUND_NAME_CRSP         F000002KYY JHancock Disciplined Value R4 2009-05-22 46807 2009-05-22 John Hancock Funds III: John Hancock Disciplined Value Fund; Class R3 Shares F000002KYY JHancock Disciplined Value R4 2009-05-22 46808 2009-05-22 John Hancock Funds III: John Hancock Disciplined Value Fund; Class R4 Shares F000002KYY JHancock Disciplined Value R4 2009-05-22 46809 2009-05-22 John Hancock Funds III: John Hancock Disciplined Value Fund; Class R5 Shares F000002KYY JHancock Disciplined Value R4 2009-05-22 46810 2009-05-22 John Hancock Funds III: International Core Fund; Class R3 Shares   F000002KYY JHancock Disciplined Value R4 2009-05-22 46811 2009-05-22 John Hancock Funds III: International Core Fund; Class R4 Shares   F000002KYY JHancock Disciplined Value R4 2009-05-22 46812 2009-05-22 John Hancock Funds III: International Core Fund; Class R5 Shares   F000002KYY JHancock Disciplined Value R4 2009-05-22 46813 2009-05-22 John Hancock Investment Trust: John Hancock Fundamental Large Cap Core Fund; Class R1 Shares F000002KYY JHancock Disciplined Value R4 2009-05-22 46813 2009-05-22 John Hancock Investment Trust: John Hancock Large Cap Equity Fund; Class R1 Shares ... View more

compare two names to find a match

by Lapis Lazuli | Level 10 in SAS Programming
‎11-04-2020 09:47 AM
‎11-04-2020 09:47 AM
hello,  I had a file that contain two names column. I want to find the perfect match. I want then to compare the column Fund_name with the column Fund_name_CRSP to find the most similar name for each secid. comme match by secid.    secid Fund_name Inception_date CRSP_FUNDNO FIRST_OFFER_DT FUND_NAME_CRSP           F000000DL0 Macquarie IPO China Concentrated Core A1 2007-03-08 31345 2007-03-08 Vanguard International Equity Index Funds: Vanguard FTSE All-World ex US Index Fund; Investor Shares F000000DL0 Macquarie IPO China Concentrated Core A1 2007-03-08 49091 2007-03-08 Fidelity Rutland Square Trust II: Strategic Advisers Fidelity International Fund F000000DL0 Macquarie IPO China Concentrated Core A1 2007-03-08 49091 2007-03-08 Fidelity Rutland Square Trust II: Strategic Advisers International II Fund F000000DL0 Macquarie IPO China Concentrated Core A1 2007-03-08 49093 2007-03-08 Fidelity Rutland Square Trust II: Strategic Advisers US Opportunity II Fund F000000JLW WCM Hippocrates A USD 2005-11-25 16966 2005-11-25 Jennison Sector Funds, Inc: Jennison Health Sciences Fund; Class X Shares F000000JLW WCM Hippocrates A USD 2005-11-25 16966 2005-11-25 JennisonDryden Sector Funds: Jennison Health Sciences Fund; Class X Shares F000000JLW WCM Hippocrates A USD 2005-11-25 16966 2005-11-25 Prudential Sector Funds, Inc: Prudential Jennison Health Sciences Fund; Class X Shares F000000JLW WCM Hippocrates A USD 2005-11-25 16967 2005-11-25 Jennison Sector Funds, Inc: Jennison Health Sciences Fund; Class M Shares F000000JLW WCM Hippocrates A USD 2005-11-25 16967 2005-11-25 JennisonDryden Sector Funds: Jennison Health Sciences Fund; Class M Shares F000000JLW WCM Hippocrates A USD 2005-11-25 16967 2005-11-25 Prudential Sector Funds, Inc: Prudential Jennison Health Sciences Fund; Class M Shares F000000JLW WCM Hippocrates A USD 2005-11-25 16968 2005-11-25 Jennison Sector Funds, Inc: Jennison Health Sciences Fund; Class L Shares F000000JLW WCM Hippocrates A USD 2005-11-25 16968 2005-11-25 JennisonDryden Sector Funds: Jennison Health Sciences Fund; Class L Shares F000000JLW WCM Hippocrates A USD 2005-11-25 16968 2005-11-25 Prudential Sector Funds, Inc: Prudential Jennison Health Sciences Fund; Class L Shares F000000KTA Macquarie Asia New Stars A1 2007-12-05 36620 2007-12-05 Federated Equity Funds: Federated Kaufmann Large Cap Fund; Class A Shares F000000KTA Macquarie Asia New Stars A1 2007-12-05 36621 2007-12-05 Federated Equity Funds: Federated Kaufmann Large Cap Fund; Class C Shares F000000KTA Macquarie Asia New Stars A1 2007-12-05 36622 2007-12-05 Federated Equity Funds: Federated Kaufmann Large Cap Fund; Class K Shares F000000KTA Macquarie Asia New Stars A1 2007-12-05 36622 2007-12-05 Federated Equity Funds: Federated Kaufmann Large Cap Fund; Class R Shares F000000KTA Macquarie Asia New Stars A1 2007-12-05 36623 2007-12-05 Federated Equity Funds: Federated Kaufmann Large Cap Fund; Institutional Shares F000000KTA Macquarie Asia New Stars A1 2007-12-05 36938 2007-12-05 ING Funds Trust: ING Institutional Prime Money Market Fund; Class IS shares ... View more

Re: how to change date format

by Lapis Lazuli | Level 10 in SAS Programming
‎10-23-2020 03:54 PM
‎10-23-2020 03:54 PM
192701 is 1927jan (year/month) when I open excel I see 192701 and is a standard format in excel  ... View more

Re: how to change date format

by Lapis Lazuli | Level 10 in SAS Programming
‎10-23-2020 03:12 PM
‎10-23-2020 03:12 PM
i see this 06AUG2487 for the date 192701!!!!!!! ... View more

how to change date format

by Lapis Lazuli | Level 10 in SAS Programming
‎10-23-2020 03:05 PM
‎10-23-2020 03:05 PM
hello  I import sas file usinh this line  proc import datafile = 'C:\MaRecherche\IPO\data_full_sample\FF_factors.xlsx' DBMS = Excel OUT = Factors ; sheet="F-F_Research_Data_Factors";   when I get the data the variable date has a format best12. et informat 12. I want to change the format to YYMMDDN8. and informat 8.    I do it in this way  data JOINT; set JOINT; format date yymmddn8.; informat date 8.; run;     it does not work. it gives strange dates!!!! ... View more

Re: difference between date in rows by id

by Lapis Lazuli | Level 10 in SAS Programming
‎10-22-2020 11:23 AM
‎10-22-2020 11:23 AM
yes it is a typo thanks ... View more

difference between date in rows by id

by Lapis Lazuli | Level 10 in SAS Programming
‎10-22-2020 11:09 AM
‎10-22-2020 11:09 AM
Hello I want to make the difference between dates by id    data diff; set JOINT; days_between = intck('days',Ann_date,lag(Ann_date)); by number; run; this program give this  Number Ann_date days_between 21 2008-11-12   21 2011-03-29 -867 21 2015-01-21 -1394 21 2016-03-29 -433 24 2003-05-06 4711 24 2016-01-25 -4647 24 2016-05-10 -106 26 2014-08-11 638 46 2009-01-19 2030 53 2008-07-15 188 53 2009-07-27 -377 53 2010-06-11 -319 53 2010-07-16 -35 53 2015-01-15 -1644 53 2015-10-09 -267 I want    Number Ann_date days_between 21 2008-11-12   21 2011-03-29 -867 21 2015-01-21 -1394 21 2016-03-29 -433 24 2003-05-06   24 2016-01-25 -4647 24 2016-05-10 -106 26 2014-08-11   46 2009-01-19 2030 53 2008-07-15   53 2009-07-27 -377 53 2010-06-11 -319 53 2010-07-16 -35 53 2015-01-15 -1644 53 2015-10-09 -267 ... View more

Re: how to calculate a mean when moving by a number form a fixed date

by Lapis Lazuli | Level 10 in SAS Programming
‎10-21-2020 10:21 AM
‎10-21-2020 10:21 AM
Hi Reeza if I have a lot of date event not only 21july2020. How can I create a range?  ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎11-08-2024 11:07 PM
Likes given to
Likes from
View All
Quick links