About anweinbe

anweinbe · ‎01-18-2021

Good evening, I have 2 very simple datasets that have limited information in them. File 1: Main file (named temp.CEO_FILE) of firms that hired a CEO. Variables are named: Company_Name, Size_millions, Year, and Industry File 2: Control file (named OTHER_FILE) of all firms who did not hire a CEO. I am trying to match my firms who hired a CEO to a similar firm in the same year and industry who did not hire a CEO. I've tried the PSMatch but I admit I am struggling to make sense of any of it.... any help would be great. Thank you kindly!

anweinbe · ‎12-03-2020

found an article on WRDS: 2 options for those with the same issue: Option 1: Add "inencoding=asciiany" to your custom libname statements In your SAS code where you specify the library for your saved data, or if you have custom libname statements referencing WRDS data, simply add the option "inencoding=asciiany" to the end of the statements, for example: libname mylib '~/' inencoding=asciiany; libname complib '/wrds/comp/sasdata/d_na/' inencoding=asciiany; Option 2: Change the encoding of your saved dataset to UTF-8 so it matches WRDS data encoding You can change the encoding of your dataset to UTF-8 format with the following code: proc datasets nolist library=mylib; modify mydata / correctencoding=utf8; quit;

anweinbe · ‎12-03-2020

I am using WRDS... I didn't receive any notifications from my university... Anything you can pass on?

anweinbe · ‎12-03-2020

Good evening. I have been running the same code for about 6 months without issue. All of a sudden over the past 2 days I keep getting a new error. Nothing has changed in my code at all.... I'm not sure what to do. Here is the note followed by the error I receive. Any advice? 88 data work.tfns34; set tfn.s34; NOTE: Data file TFN.S34.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. 89 ERROR: Some character data was lost during transcoding in the dataset TFN.S34. Either the data contains characters that are not representable in the new encoding or truncation occurred during transcoding.

anweinbe · ‎10-23-2020

I'm going to try what you provided. Yes, the difference between before and after would be due to the before and after and possibly other things. I am trying to see if gender is one of those other things. Perhaps I see that the before and after for males is minimal, but the before and after for women is big.

anweinbe · ‎10-23-2020

I understand the sorting as you noted, but then how will the T-test know to separate by Gender. Do I need to include a By statement in the PROC TTEST code? I would assume yes... Where does it go? Sorry for the back and forth. Trying to learn.

anweinbe · ‎10-23-2020

I did not provide the error message because I've never written it before with a control variable in it. As such, I didn't think it would be helpful to provide a log of my own random things. You noted "BY Gender". Where would that typically go?

anweinbe · ‎10-23-2020

Paige, To clarify my ask, I would like to know if the difference between before and after is due to gender. Can you provide some guidance on what the PROC GLM would look like?

anweinbe · ‎10-23-2020

Hello all! I feel like I am missing something obvious and could use some help. I am running the following paired sample t-test looking to see if there is a difference between the two variables. I would like to add in a binary variable that allows me to control for male / female. The binary variable is called "gender". How do I put "gender" in this correctly? I tried VAR, GROUP and other things but I'm getting errors. I was thinking of splitting my file to create 1 male file and 1 female file but that seems rather silly... I figured there is a better way. My code: PROC TTEST DATA=temp.IBES_STATpers_QTRS_8 ALPHA=.05; PAIRED MEANEST_O_YE*MEANEST_N_YE; RUN;

anweinbe · ‎08-19-2020

My worry is that I could have a situation where the company changes but not the year. Would this fix that worry? I think it does.... if first._year or first.company then rnk=0;

anweinbe · ‎08-19-2020

To solve for my issue... do you think if I do If last.year OR if last.company then rnk=0?

anweinbe · ‎08-19-2020

I have data that I sorted by Company Year and Salary Descending. I want to extract only the top 2 salary records for each company and year to a new table. My data looks like: Company Year Salary 1 2020 10,000 1 2020 5,000 1 2020 3,000 1 2020 2,000 1 2019 9,000 1 2019 5,000 1 2019 3,000 2 2020 8,000 2 2020 5,000 2 2020 3,000 My desired outcome is my new table will only have the records for 10,000 and 5,000 for company 1 2020, 9,000 and 5,000 for company 1 for 2019, and 8,000 and 5,000 for company 2 in 2020 I tried the following: proc sort data=temp.own2_for_sample3; by company Year descending salary; run; data temp.own2_for_sample3; set temp.own2_for_sample3; by company Year salary; if first.year then rnk=0; rnk +1; run; It appears to work.... however I am afraid that since I'm only doing first.year and not including the first.company it could mess up. Any easy modifications? Thank you!

anweinbe · ‎07-28-2020

Good morning. I have the following data: DATE TIC STYPE Name 1/1/20 MSFT Product Electronics 1/1/20 MSFT Product Computers 1/1/19 MSFT Product Electronics 1/1/19 MSFT Product Computers 1/1/20 GOOG Foreign Web Services 1/1/20 GOOG Foreign Hosting 1/1/20 GOOG Product Computers I am looking to create a summarized table that just tell me for each data and ticker how many unique segments there are. The oupout should look like this: 1/1/20 MSFT Product 2 1/1/19 MSFT Product 2 1/1/20 GOOG Foreign 2 1/1/20 GOOG Product 1 I tried this but I am getting an error. I know I took a sum statement out but in my other code I was trying to add numbers up so that wouldn't apply here. I believe I am close! proc sql; create table temp.SEGMENTS_2 as select TIC, from temp.SEGMENTS_1 group by DATE, STYPE; quit; Thank you!

anweinbe · ‎07-23-2020

Tom, So I should be ignoring what fields visually looked like when they are dates and SAS will take care of it? Pardon the ignorance here.

anweinbe · ‎07-23-2020

Hi all, In one table I have a date field called "DATE" that shows up as 20160401. It is type numeric formatted YYMMDDn8. In my second table I have a date field called "DATE2" that shows up as 20545 (a SAS date) which is type numeric with no format. I'm trying to join these tables together by customer name (in both tables) and the date fields but I am struggling to convert the dates into similar format before the join. Is there an easy way to convert the YYMMDDn8. and convert it to a SAS date? Perhaps that idea is making this more complicated?

Online Status	Offline
Date Last Visited	‎01-25-2021 05:48 PM

PSMatch Assistance

Re: encoding error?! Out of the blue

Re: encoding error?! Out of the blue

encoding error?! Out of the blue

Re: Paired T-Test - Add a control

Re: Paired T-Test - Add a control

Re: Paired T-Test - Add a control

Re: Paired T-Test - Add a control

Paired T-Test - Add a control

Re: Top Record Extraction based on multiple fields.

Re: Split a date

Re: Field Separation into multiple fields

Re: Field Separation into multiple fields

Re: Append data sets together

Re: Append data sets together

Re: Field Separation into multiple fields

Re: Remove observations with . in them

PSMatch Assistance

Re: encoding error?! Out of the blue

Re: encoding error?! Out of the blue

encoding error?! Out of the blue

Re: Paired T-Test - Add a control

Re: Paired T-Test - Add a control

Re: Paired T-Test - Add a control

Re: Paired T-Test - Add a control

Paired T-Test - Add a control

Re: Top Record Extraction based on multiple fields.

Re: Top Record Extraction based on multiple fields.

Top Record Extraction based on multiple fields.

Help with Summarizing a Group

Re: Date to SAS date

Date to SAS date