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

import data from excel with a correct date type

by Lapis Lazuli | Level 10 in SAS Procedures
‎01-17-2022 12:53 PM
‎01-17-2022 12:53 PM
Hello  I want to import data from excel. the date type in the first row are date excel format, but SAS import it as text format. this is my program  proc import datafile = 'C:\MaRecherche\Bank Fraud Announcement/MS_price_data_200firm.xlsx' DBMS = xlsx OUT = _6_Morningstar_Data; this is the output sas for the following date in the first row    1 janvier 1999 2 janvier 1999 3 janvier 1999 4 janvier 1999 5 janvier 1999 6 janvier 1999 thanks a lot ... View more

Re: difference between date

by Lapis Lazuli | Level 10 in SAS Procedures
‎01-13-2022 03:34 PM
‎01-13-2022 03:34 PM
hello,  it seems not working. this is a sample of my data data penality; input Number $ penalty_date; format Penalty_Date yymmdd10.; datalines; 1 20061221 1 20180507 2 20140710 2 20171002 ; data diff; set penality; by Number; days_between = dif(penalty_date); if first.Number then call missing(days_between); run; this is the output   ... View more

difference between date

by Lapis Lazuli | Level 10 in SAS Procedures
‎01-13-2022 11:45 AM
‎01-13-2022 11:45 AM
This code has worked for me in the past, but not today. Can you please help suggesting what I'm doing wrong?  I have this error in the log NOTE: Invalid argument to function INTCK('days',21311,20061221) at line 498 column 16.   data diff; set penality; by Number; days_between = intck('days',Penalty_Date,lag(Penalty_Date)); if first.Number then call missing(days_between); run; ... View more

Re: proc sql where not equal

by Lapis Lazuli | Level 10 in SAS Procedures
‎01-10-2022 03:03 PM
‎01-10-2022 03:03 PM
there is no error in the log but the input table did not change ... View more

proc sql where not equal

by Lapis Lazuli | Level 10 in SAS Procedures
‎01-10-2022 02:58 PM
‎01-10-2022 02:58 PM
hello  not= does not work in my program. what is the error? thanks roc sql; create table stat_data as select * from Penality where specific_Industry_of_Parent not = 'mortgage lending' or specific_Industry_of_Parent not = "commodity trading; mining" or specific_Industry_of_Parent not= 'banking' or specific_Industry_of_Parent not = "insurance" or specific_Industry_of_Parent not = "financial services" or specific_Industry_of_Parent not = "banking & securities" or specific_Industry_of_Parent not = "investment advisory services"; run; ... View more

Re: PSMATCH Procedure

by Lapis Lazuli | Level 10 in SAS Programming
‎12-20-2021 02:12 PM
‎12-20-2021 02:12 PM
thanks for the response.  I wonder if there is a method in proc psmatch that give the optimal matching of control group? ... View more

Re: PSMATCH Procedure

by Lapis Lazuli | Level 10 in SAS Programming
‎12-20-2021 11:25 AM
‎12-20-2021 11:25 AM
thanks for your help the outExt give the matched Id. when I make a proc sort by _MatchID I find the same table as Output 96.4.14: Output Data Set with Matching Numbers however I find that the program match each observation for  the treatment group  with only one observation in  the control group    but I want to match each observation for  the treatment group  with multiple observations in the control group if the PMS score allow.  can you help me to have the good procedure for that ?   ... View more

Re: PSMATCH Procedure

by Lapis Lazuli | Level 10 in SAS Programming
‎12-20-2021 10:59 AM
‎12-20-2021 10:59 AM
yes this is all my variable by not all the data. this is a screenshot of proc contents        ... View more

Re: PSMATCH Procedure

by Lapis Lazuli | Level 10 in SAS Programming
‎12-20-2021 10:39 AM
‎12-20-2021 10:39 AM
so why I did not find the same thing using my data and program ?     proc psmatch data=man.pms_data region=treated;    class IPO ;    psmodel IPO(Treated='yes')= age Net_asset_share_class Expenses Turnover manger_tenure_average count_name flux;    match distance=lps method=greedy(k=1)  caliper=0.5;    assess lps var=( age Net_asset_share_class Expenses Turnover manger_tenure_average count_name flux)           / stddev=pooled(allobs=no) stdbinvar=no              weight=none;    output out(obs=match)=OutEx4 matchid=_MatchID; run;   this is my OUTEX4   ... View more

PSMATCH Procedure

by Lapis Lazuli | Level 10 in SAS Programming
‎12-20-2021 09:56 AM
‎12-20-2021 09:56 AM
Hello,  I want to condunct PSMATCH to have the matched sets of id which correspond to the treatment group.  I want your help to understand Example 96.4 Greedy Nearest Neighbor Matching https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.3/statug/statug_psmatch_examples04.htm  column match_id is supposed to give the id of matched group so  why I did not see sudentID in this column??? ... View more

count name of company

by Lapis Lazuli | Level 10 in SAS Programming
‎12-17-2021 10:22 AM
‎12-17-2021 10:22 AM
hello      data have; input secid $ NAME $ management_company $; datalines; 1 Afund Sales 1 Afund xyz 2 Bfund Mary Acctng 2 bfund Sales ;   want  Sales  2 xyz     1 Mary Acctng 1    but I obtain this  this is the program that I use  proc sql; create table want as select distinct management_company, count(management_company) as count_name from have; quit; ... View more

count observation of variable by id

by Lapis Lazuli | Level 10 in SAS Procedures
‎12-14-2021 10:51 AM
‎12-14-2021 10:51 AM
Hello  I want to calculate the number of observations of TIC by CRSP_FUNDNO HAVE CRSP_FUNDNO      TIC 1                               BIC 1                                 * 1                                 * 1                               BIC 1                                LII 1                               THG 2                                 BIC 2                                   BIC 2                                    . 2                                     . WANT CRSP_FUNDNO      TIC        N 1                                BIC        2 1                                 LII          1 1                                 THG        1 2                                BIC         2 ... View more

Re: change format

by Lapis Lazuli | Level 10 in SAS Procedures
‎12-13-2021 01:43 PM
‎12-13-2021 01:43 PM
I think that my problem of date format come when I import data from excel  date become like text  can you help me to import correcty date form excel  proc import datafile = 'C:\MaRecherche\Value added infrastructure MFs\database\_0_Fundname_Morningstar.xlsx' DBMS = XLSX OUT = mret_morningstar ; sheet="mret_morningstar"; run; have secid  01-01-1984 01-02-1984  1             0.2               0.6 1              0.4               0.96 ... View more

Re: change format

by Lapis Lazuli | Level 10 in SAS Procedures
‎12-13-2021 01:30 PM
‎12-13-2021 01:30 PM
    I import data from excel so the data is year and month only. for example 201001 is 2010 january  ... View more

Re: change format

by Lapis Lazuli | Level 10 in SAS Procedures
‎12-13-2021 01:22 PM
‎12-13-2021 01:22 PM
data _mret_morningstar8; set _mret_morningstar; format date $40.; date2=input(date, YYMMDD8.);   run;   this is a screen of sas        this is error in the log 1207 1208 data _mret_morningstar8; 1209 set _mret_morningstar; 1210 1211 format date $40.; 1212 1213 date2=input(date, YYMMDD8.); 1214 1215 1216 1217 run; NOTE: Invalid argument to function INPUT at line 1213 column 7. secid=F000000EU6 DATE=198606 mret=0.6 date2=. _ERROR_=1 _N_=1 NOTE: Invalid argument to function INPUT at line 1213 column 7. secid=F000000EU6 DATE=198607 mret=0.6 date2=. _ERROR_=1 _N_=2 NOTE: Invalid argument to function INPUT at line 1213 column 7. secid=F000000EU6 DATE=198608 mret=2.27 date2=. _ERROR_=1 _N_=3 NOTE: Invalid argument to function INPUT at line 1213 column 7. secid=F000000EU6 DATE=198609 mret=1.23 date2=. _ERROR_=1 _N_=4 NOTE: Invalid argument to function INPUT at line 1213 column 7. secid=F000000EU6 DATE=198610 mret=3.16 date2=. _ERROR_=1 _N_=5 NOTE: Invalid argument to function INPUT at line 1213 column 7. secid=F000000EU6 DATE=198611 mret=0.46 date2=. _ERROR_=1 _N_=6 NOTE: Invalid argument to function INPUT at line 1213 column 7. secid=F000000EU6 DATE=198612 mret=2.96 date2=. _ERROR_=1 _N_=7 NOTE: Invalid argument to function INPUT at line 1213 column 7. secid=F000000EU6 DATE=198701 mret=2.52 date2=. _ERROR_=1 _N_=8 NOTE: Invalid argument to function INPUT at line 1213 column 7. secid=F000000EU6 DATE=198702 mret=2.63 date2=. _ERROR_=1 _N_=9 NOTE: Invalid argument to function INPUT at line 1213 column 7. secid=F000000EU6 DATE=198703 mret=5.81 date2=. _ERROR_=1 _N_=10 NOTE: Invalid argument to function INPUT at line 1213 column 7. secid=F000000EU6 DATE=198704 mret=6.3 date2=. _ERROR_=1 _N_=11 NOTE: Invalid argument to function INPUT at line 1213 column 7. secid=F000000EU6 DATE=198705 mret=5.77 date2=. _ERROR_=1 _N_=12 NOTE: Invalid argument to function INPUT at line 1213 column 7. secid=F000000EU6 DATE=198706 mret=11.45 date2=. _ERROR_=1 _N_=13 NOTE: Invalid argument to function INPUT at line 1213 column 7. secid=F000000EU6 DATE=198707 mret=7 date2=. _ERROR_=1 _N_=14 NOTE: Invalid argument to function INPUT at line 1213 column 7. secid=F000000EU6 DATE=198708 mret=0.73 date2=. _ERROR_=1 _N_=15 NOTE: Invalid argument to function INPUT at line 1213 column 7. secid=F000000EU6 DATE=198709 mret=0.85 date2=. _ERROR_=1 _N_=16 NOTE: Invalid argument to function INPUT at line 1213 column 7. secid=F000000EU6 DATE=198710 mret=-17.46 date2=. _ERROR_=1 _N_=17 ... 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