About dlazer1

dlazer1 · ‎05-27-2019

Hi, I am working with data and want to make sure I have it coded correctly. I have a company ID and partner ID and date. I want to see when the partner ID changes for each company ID. How would I do that? Thank you!

dlazer1 · ‎07-22-2018

I expect 7000 matches so 14,000 total observations ---- 7000 from my sample and 7000 from the control. Regardless, it doesnt make sense to have less than half.

dlazer1 · ‎07-22-2018

Hi, I am trying to do a 1 to 1 match. I did it the following way. The results were 2721 matches which I am confused about since my control observations are over 400,000 and trying to get one match for each of my 7,000 observations in my sample. Can anyone help me figure it out. Ultimately there should be 7,000 matches so there is a total of 14,000 individual observations. my data has gvkey (company identifier), fyear (fiscal year), sic (industry), TA (total assets) proc sql; create table want as select s.*, c.gvkey as match_firm, c.AT as match_assets, c.fyear as match_year from sample1 as s inner join control1 as c on s.sic=c.sic where c.gvkey ne s.gvkey group by s.gvkey having abs(s.AT-c.AT) = min(abs(s.AT-c.AT)); select * from want; quit;

dlazer1 · ‎04-10-2018

Hi, My data looks like this. I need to figure out how to delete an observation when it contains specific numbers in the variable RES_ACC_RES_FKEY_LIST. Currently in my code I have if RES_ACC_RES_FKEY_LIST='55' then delete; but that does not seem to delete any observations. Thank you for your help!

dlazer1 · ‎03-21-2018

dlazer1 · ‎03-21-2018

This did not output what I'm looking for. Here is an example and the indicator is how I need it coded. Basically if any year, an auditor_fkey for any company_fkey is there, then there needs to be an indicator.

dlazer1 · ‎03-21-2018

I am trying to code if a auditor_fkey=222 then companyIND=1. For example if CompanyX is audited by auditor_fkey 222 in 2001, I need the companyIND to show up for that CompanyX regardless of the year (every time the company is in the database). The issue I am running into is I need that 1 to show up for each time the company (company_fkey) was audited by a certain auditor based on the auditor_fkey. Thank you!

dlazer1 · ‎03-21-2018

I am trying to figure out how to do an indicator variable for any company_fkey that has ever been associated with a particular auditor_fkey. Thank you!

dlazer1 · ‎03-14-2018

Hi, I am trying to calculate the firm age based on FISCAL_YEAR_END_OP. I am trying to index the file in order to calculate from the first to late date of the opinion in my dataset. I am not able to output an age based on the code below. Any help would be greatly appreciated! proc sort data=opinion; by COMPANY_FKEY FISCAL_YEAR_END_OP; run; data age; retain index; set opinion; if index=. then index=0; if COMPANY_FKEY = lag(COMPANY_FKEY) then index=index; else index=index+1; run; data age; set age; by index; if first.index then output age; run;

dlazer1 · ‎02-25-2018

Thank you!

dlazer1 · ‎02-25-2018

Hi, What is the best way to output the average X (Earnings/price) per year into the dataset with all my other variables. Here is the previous code I have tried but it is not including the mean EP per year next to each row (I need it to show per observation for my future calculation). Thank you! proc sort data=marketadj1; by fyear X; run; proc means data=marketadj1; var X; by fyear; run; proc univariate data=marketadj1; var x; by fyear; output mean=mean; run; proc print data=marketadj1 (obs=100); run; proc means data=marketadj1; 467 var X; 468 by fyear; 469 output=mean; ------ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 470 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE MEANS used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 471 proc univariate data=marketadj1; 472 var x; 473 by fyear; 474 out=meanstate mean n; --- 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 475 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE UNIVARIATE used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 476 proc univariate data=marketadj1; 477 var x; 478 by fyear; 479 output mean n; - 73 ERROR 73-322: Expecting an =. 480 run; NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.DATA1 may be incomplete. When this step was stopped there were 0 observations and 0 variables. NOTE: PROCEDURE UNIVARIATE used (Total process time): real time 0.01 seconds cpu time 0.00 seconds 481 482 proc univariate data=marketadj1; 483 var x; 484 by fyear; 485 output mean; - 73 ERROR 73-322: Expecting an =. 486 run; NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.DATA2 may be incomplete. When this step was stopped there were 0 observations and 0 variables. NOTE: PROCEDURE UNIVARIATE used (Total process time): real time 0.03 seconds cpu time 0.00 seconds

dlazer1 · ‎02-24-2018

Thank you! This worked.

dlazer1 · ‎02-24-2018

Hi, I am trying to invoke a macro I have. I have already run it. It looks like this. %macro truncate(dsetin=, dsetout=, var=); proc sort data=&dsetin out=rank&var; by &var; run; proc rank data=rank&var out=test&var groups=100; var &var; ranks q&var; run; data &dsetout; set test&var; if q&var = 0 or q&var = 99 then delete; run; proc sort data=&dsetout; by fyear gvkey; run; %mend truncate; When I invoke it into my program it gives me this error or does not give an error but also does not produce the data set. I am trying to truncate 1% and 99% of certain variables. Thank you! 512 %truncate(comp_ret, comp_ret1, NI_price_tm1 NI_AT_tm1 cumret) ERROR: More positional parameters found than defined. 513 %truncate(comp_ret, comp_ret1, NI_price_tm1) ERROR: More positional parameters found than defined. 514 %truncate(comp_ret,comp_ret1,NI_price_tm1) ERROR: More positional parameters found than defined. 515 %truncate(comp_ret,comp_ret1,NI_price_tm1); ERROR: More positional parameters found than defined. 516 %macro truncate(dsetin=, dsetout=, var=); 517 518 proc sort data=&dsetin out=rank&var; 519 by &var; 520 run; 521 522 proc rank data=rank&var out=test&var groups=100; 523 var &var; 524 ranks q&var; 525 run; 526 527 data &dsetout; 528 set test&var; 529 if q&var = 0 or q&var = 99 then delete; 530 run; 531 proc sort data=&dsetout; 532 by fyear gvkey; 533 run; 534 535 %mend truncate; 536 %truncate(dsetin=comp_ret, dsetout=comp_ret1, var=NI_price_tm1; 537 %truncate(dsetin=comp_ret, dsetout=comp_ret1, var=NI_price_tm1); ERROR: More positional parameters found than defined. 538

dlazer1 · ‎02-21-2018

Hi, I am unable to properly informat the date from my csv file. When I do a proc import or using the import wizard, the date is cut off to have a format of $1. and informat of $1. proc import datafile='C:***********.csv' dbms=csv out=work.test replace; run; I have tried including "input Date MMDDYY10." in the proc import statement but it does not work. My date format from the csv file is 12/31/2017 but it is currently only showing up as the first character or "1". Thank you for your help!

dlazer1 · ‎02-07-2018

Hi, I am using SAS and have been running my code up till now just fine. Tonight I got an error message saying (below) when doing a proc sql. I have looked at previous answers to questions on this topic and have troubleshooted them using that concept but it still doesn't work. Do you have any other suggestions? NOTE: The query requires remerging summary statistics back with the original data. ERROR: Sort execution failure.

Online Status	Offline
Date Last Visited	‎05-28-2019 07:34 PM

Most efficient way to find a change in data

Re: Matching sample with control group on size and industry

Matching sample with control group on size and industry

How to delete specific numbers in oberservations

Re: creating an Indicator

Re: creating an Indicator

creating an Indicator

How to code if a company has been associated with another company?

Calculate Firm Age

Re: How to output mean next to each observation?

Re: Cannot properly informat date from csv to sas

Most efficient way to find a change in data

Re: Matching sample with control group on size and industry

Matching sample with control group on size and industry

How to delete specific numbers in oberservations

Re: creating an Indicator

Re: creating an Indicator

creating an Indicator

How to code if a company has been associated with another company?

Calculate Firm Age

Re: How to output mean next to each observation?

How to output mean next to each observation?

Re: Cannot properly informat date from csv to sas

Why does SAS truncate macro not work?

Cannot properly informat date from csv to sas

ERROR: Sort execution failure in PROC SQL