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: 
anweinbe
‎01-25-2021
  • 67 Posts
  • 12 Likes Given
  • 1 Solutions
  • 3 Likes Received

Re: Split a date

by Quartz | Level 8 in SAS Procedures
‎07-22-2020 12:37 PM
‎07-22-2020 12:37 PM
That did it! Thank you!!! ... View more

Split a date

by Quartz | Level 8 in SAS Procedures
‎07-22-2020 12:26 PM
‎07-22-2020 12:26 PM
Good afternoon,   I have a column within my dataset called "file_accepted". A sample record shows as "09MAR2007:16:12:21".    I am trying to create a field that grabs the 2 digits after the first colon, in this example the 16... which is military time for 4pm. Ideally, I would like my new field to be coded as "1" if the time is at 4PM or after, and "0" if the time is before 4PM.    Thank you! ... View more

Re: Join tables, Date in between check

by Quartz | Level 8 in SAS Programming
‎07-16-2020 02:06 PM
‎07-16-2020 02:06 PM
Thank you! I knew it was easy. ... View more

Join tables, Date in between check

by Quartz | Level 8 in SAS Programming
‎07-16-2020 01:53 PM
‎07-16-2020 01:53 PM
Good afternoon SAS friends. I could use a little help.   I have one table: Temp.a, that has an Employee ID number and a Hire Date. I have another file Temp.B that has an ID number and a Beginning Date and an End Date as well as some other information. Our company recycles ID's.    I would like to join the files together on Employee ID, but add a clause where the Hire Date must be between the beginning date and end date. That will ensure it matches to the right record in the second table. In the example below, I would want my table 1 to match to the 2nd record of table 2, not the first.    Table 1:    123456     10/23/2019   Table 2:    123456      01/01/2010        12/31/2018 Table 2:     123456      01/01/2019        12/31/2019   I can write the typical join statement... but I figure I need to add something to this...   where a.empno=b.empno;     THANK YOU!!!! ... View more

Re: Join records based on next closest date.

by Quartz | Level 8 in SAS Programming
‎05-20-2020 12:14 PM
‎05-20-2020 12:14 PM
Kurt, This gets me very very close to where I need to be. The issue I am running into is that in the second file there appears to be duplicate dates, so each of the items in my original table ends up matching to the date in the 2nd table 4-5 times each.   Do you suggest that I just take the resulting table from your code and then just remove duplicates on the resulting file? ... View more

Join records based on next closest date.

by Quartz | Level 8 in SAS Programming
‎05-20-2020 07:38 AM
‎05-20-2020 07:38 AM
I have one table that shows company announcements. These could be any date at random. I have another table that shows many different financials about the company from specific dates.   Is there a way to add a clause to the join where it will join the first table to the second by joining on the next closest date in the 2nd table?   For example, lets assume my announcement date was 5/5/2020.   Lets assume that in the next table I had dates of 3/3/2020, 4/27/2020, 5/27/2020, and 6/4/2020.   I would like to join these tables on the company name (which is both tables), but I want the join to keep the data from the 5/5/2020 announcement and all the data from the 5/27/2020 record (since its the next date).   Thank you! ... View more

Re: Change dates to nearest month end

by Quartz | Level 8 in SAS Programming
‎05-20-2020 07:29 AM
‎05-20-2020 07:29 AM
I believe that I will always be going forward not backwards. I should have specified that. In any case I will save this too! I appreciate your response :-). ... View more

Change dates to nearest month end

by Quartz | Level 8 in SAS Programming
‎05-19-2020 08:10 PM
‎05-19-2020 08:10 PM
I have a column of dates. Is there a way to make a new field that returns the closest month end?   For example, Make 3/27/2020 -> 3/31/2020 Make 1/28/2017 -> 1/31/2017 etc.   My date field is currently a "date 9" format if that makes a difference!   ... View more

Re: Joining Data on Periods

by Quartz | Level 8 in SAS Programming
‎05-19-2020 11:42 AM
‎05-19-2020 11:42 AM
DATA2DATASTEP DSN IBES_NEW_APPLE DATA2DATASTEP FILE homesyranweinbe/create_WORK_IBES_NEW_APPLE_data.sas DATA2DATASTEP FMT YES DATA2DATASTEP FMTLIST STATPERS DATE9. DATA2DATASTEP INPUTLIST TICKER:$6. CUSIP:$8. STATPERS:DATE9. MEASURE:$6. FPI:$1. DATA2DATASTEP LBL YES DATA2DATASTEP LBLLIST TICKER="IBES Ticker Symbol" CUSIP="CUSIP/SEDOL" STATPERS="I/B/E/S Statistical Period (SAS Format)" MEASURE="Measure" FPI="Forecast Period Indicator" DATA2DATASTEP LIB TEMP DATA2DATASTEP LS 256 DATA2DATASTEP MEMLABEL DATA2DATASTEP MSGTYPE NOTE DATA2DATASTEP OBS 20 DATA2DATASTEP OUTLIB WORK DATA2DATASTEP VARLIST TICKER CUSIP STATPERS MEASURE FPI   data WORK.IBES_NEW_APPLE; infile datalines dsd truncover; input TICKER:$6. CUSIP:$8. STATPERS:DATE9. MEASURE:$6. FPI:$1.; format STATPERS DATE9.; label TICKER="IBES Ticker Symbol" CUSIP="CUSIP/SEDOL" STATPERS="I/B/E/S Statistical Period (SAS Format)" MEASURE="Measure" FPI="Forecast Period Indicator"; datalines; AAPL 03783310 20FEB2020 EPS 6 AAPL 03783310 20FEB2020 EPS 7 AAPL 03783310 20FEB2020 EPS 8 AAPL 03783310 20FEB2020 EPS 9 AAPL 03783310 16JAN2020 EPS 6 AAPL 03783310 16JAN2020 EPS 7 AAPL 03783310 16JAN2020 EPS 8 AAPL 03783310 16JAN2020 EPS 9 AAPL 03783310 19DEC2019 EPS 6 AAPL 03783310 19DEC2019 EPS 7 AAPL 03783310 19DEC2019 EPS 8 AAPL 03783310 19DEC2019 EPS 9 AAPL 03783310 14NOV2019 EPS 6 AAPL 03783310 14NOV2019 EPS 7 AAPL 03783310 14NOV2019 EPS 8 AAPL 03783310 14NOV2019 EPS 9 AAPL 03783310 17OCT2019 EPS 6 AAPL 03783310 17OCT2019 EPS 7 AAPL 03783310 17OCT2019 EPS 8 AAPL 03783310 17OCT2019 EPS 9 ;;;; Hopefully this is what you guys need. Sorry my SAS skills are very novice level. The AAPL and the numbers are just unique identifiers for "Apple". Ideally I would have more stock symbols in the full file. to simplify, I would like the following: AAPL 03783310 20FEB2020 EPS 6 16JAN2020   ... View more

Re: Joining Data on Periods

by Quartz | Level 8 in SAS Programming
‎05-19-2020 11:05 AM
‎05-19-2020 11:05 AM
Here is the data. My goal is to add an additional column so that the next period also shows on the row. For example, record 5 would show the january date as is, but a new column would show the february date.   AAPL 03783310 20FEB2020 EPS 7   2 AAPL 03783310 20FEB2020 EPS 6   3 AAPL 03783310 20FEB2020 EPS 9   4 AAPL 03783310 20FEB2020 EPS 8   5 AAPL 03783310 16JAN2020 EPS 7   6 AAPL 03783310 16JAN2020 EPS 8   7 AAPL 03783310 16JAN2020 EPS 6   8 AAPL 03783310 16JAN2020 EPS 9   9 AAPL 03783310 19DEC2019 EPS 9   10 AAPL 03783310 19DEC2019 EPS 7   11 AAPL 03783310 19DEC2019 EPS 8   12 AAPL 03783310 19DEC2019 EPS 6 ... View more

Re: Joining Data on Periods

by Quartz | Level 8 in SAS Programming
‎05-19-2020 10:56 AM
‎05-19-2020 10:56 AM
Noted! Let me see if I can get it to work. Currently its erroring out.  ... View more

Joining Data on Periods

by Quartz | Level 8 in SAS Programming
‎05-19-2020 10:22 AM
‎05-19-2020 10:22 AM
Good morning,   I have a data set that gives me some forecast information by period for a series of stock tickers. However, each of the records shows the current date only. I want to create a file that shows me the current period and the next period all on the same line. The period dates will not be consistent for each stock unfortunately.   I attached an excel file that has the data that I have and what I'm looking for. Essentially, Just taking the next date for that ticker and pulling it back into the original row. So if the row has a February Date, and the next period is a March Date, I want to show the March Date on the February line too.   Thank you!!! ... View more

Re: Transform Date from 9 to 8

by Quartz | Level 8 in SAS Procedures
‎01-19-2020 04:31 PM
‎01-19-2020 04:31 PM
I didn't need to transform anything sheesh! I thought because one was 8 and one was 9 they wouldn't work! All that time for nothing. At least I learned something.   Thank you Paige! ... View more

Transform Date from 9 to 8

by Quartz | Level 8 in SAS Procedures
‎01-19-2020 04:07 PM
‎01-19-2020 04:07 PM
Hi all,   I've read a lot of other posts and can't seem to figure out what I am doing wrong.   In one file I have a date that is YYMMDD8. and shows a calendar next to it. The type is numeric.   In another file I have a date that is DDFEBYYYY. It is a numeric date9, and says its a length 8.       I tried the following code to transform the date 9 to the 8, but it's still not right. Now one is showing a calendar next to it and the other isn't. The join fails. Period_End1=PUT(period_end_date_num, yymmddn8.); Period_End = input(Period_End1, 8.);   I know I'm missing something obviously simple, or I can do this is a much easier way... like convert the date 9 to a date 8? Frustrated at this point. Thank you for the help!   ... View more

Re: Macro Issue - Unbalanced Quotes and White Space

by Quartz | Level 8 in SAS Programming
‎01-17-2020 08:18 AM
‎01-17-2020 08:18 AM
Tom,   I believe that I am close! Just some slight modifications needed, but i'm not 100% sure what they are....   I used the simple code you gave me on the dsn data. That ran over and over without issue! (THANK YOU) I created a new program, pasted in the code without modification, and then modified the call statement. That is where I must need a small tweak.   currently: %EVTSTUDY(dsn=sashelp.class(obs=3)); %EVTSTUDY(dsn=sashelp.cars(obs=3));   What do I change the part in parenthesis too? obviously dsn=sashelp.class was the dataset that you used, but what changes do I make? the beginning of my macro looked like this... do I have to put each of these variables in? or do I just do %EVTSTUDY();?   %MACRO EVTSTUDY (INSET=, OUTSET=, OUTSTATS=, ID=permno, EVTDATE=, DATA=CRSP, ESTPER=, START=,END=,GAP=,GROUP=,MODEL=);   I know I'm close!!! Thank you kindly for working with me!   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎01-25-2021 05:48 PM
Likes given to
Likes from
View All
Quick links