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: 
mahler_ji
‎03-13-2017
  • 101 Posts
  • 0 Likes Given
  • 0 Solutions
  • 4 Likes Received

Logic Problem!!

by Obsidian | Level 7 in SAS Programming
‎01-12-2016 12:51 PM
‎01-12-2016 12:51 PM
Hey All,   I am trying to figure out some elegant logic that will work for the following problem.  I have dates that come in the following three forms:   YYYYMMDD (20160112) YYYYMM (201601) YYMMDD(160112)   I need logic that can identify the different date forms, and then parse out the respective year, month and day.  For the YYYYMM format, the day will be automatically set to the first of the month.  I have some logic that works right now for this, but it is very hacky and will not work after the year 2020 (it involves taking advantage of the fact that SAS dates only go back to 1582.... if this is an indicator of how hacky my way is)      I need the logic to work for all dates starting from 1900 going forward indefinitely into the future.     Thanks for any help you can offer! ... View more

Re: Proc Expand Help

by Obsidian | Level 7 in SAS Procedures
‎09-15-2015 01:39 PM
‎09-15-2015 01:39 PM
Thank you very much!  Didn't know you could put those commands together like that! ... View more

Proc Expand Help

by Obsidian | Level 7 in SAS Procedures
‎09-15-2015 11:28 AM
‎09-15-2015 11:28 AM
Hello All,   I am working with Proc Expand and have a quick question.  I am pretty good wiht this procedure, but there is somemthing that I can't figure out.   I have data that takes the following form:   Obs      ID         Value: 1          1              3 2          1              4  3          1              6 4          1              1 5          1              3 6          1              2 7          1              5 8          1              5 9          1              9 10          1              2 etc.   and I want to get a backwards looking moving average that DOES NOT take into account the current observation.  So, for example, if I wanted the the three obs backward moving average, I have been using TRANSFORMOUT = (movave 3) and then changing the obs value and remerging, but I want to be able to do that in one step in proc expand, so that I don't have to worry about data issues when remerging.   Ultimately, this is what i want:   The three day backward moving ave for obs 4 would be 13/3 and not 11/3.  I hope that makes sense.   Thanks!!   John   ... View more

Re: Does Anyone Like Sports?!

by Obsidian | Level 7 in SAS Programming
‎09-14-2015 04:03 PM
‎09-14-2015 04:03 PM
This looks really great! I was actually working on doing it in a similar way!  Thanks for finishing the thoughts for me! John ... View more

Re: Does Anyone Like Sports?!

by Obsidian | Level 7 in SAS Programming
‎09-14-2015 01:03 PM
‎09-14-2015 01:03 PM
Awesome!   Post updated with data sample. ... View more

Does Anyone Like Sports?!

by Obsidian | Level 7 in SAS Programming
‎09-14-2015 12:51 PM
‎09-14-2015 12:51 PM
Hey All,   I am looking for some help, working with a large set of sports data.  I have data that takes the following form:   Date     Team     Venue     Score XXX       A           Home     80 XXX       B           Away       90 XXX       C          Home       78 XXX       D          Away         65 YYY       A          Home        100 YYY       D         Away          87     And I want to create a column or something that looks like the following:   Date     Team     Venue     Score       didWin XXX       A           Home     80              0 XXX       B           Away       90             1 XXX       C          Home       78             1 XXX       D          Away         65            0 YYY       A          Home        100          1 YYY       D         Away          87            0   There are no variables currently in the dataset in which I could do a transpose so that I could compare the home score and the away score.  The games are always in pairs of home/away teams.  I just need a way to compare the scores for each pair of teams on a given date, and then assign either a 1 or 0 for a win during that game.   AS A BONUS:  I am also going to be tallying a total wins and total losses column at each point in the season, going back to the beginning of the season, so the data would look like this:   Date     Team     Venue     Score       didWin        totalWins       totalLosses XXX       A           Home     80              0                  0                       0 XXX       B           Away       90             1                  0                       0 XXX       C          Home       78             1                  0                       0 XXX       D          Away         65            0                  0                      0 YYY       A          Home        100          1                  0                       1  YYY       D         Away          87            0                  0                       1     So coming into date YYY, I would know that the two teams that are playing each other both have zero wins and one loss up to that point in the season!   I attached a sample dataset to work with!     Thanks!  ... View more

Re: proc reg output

by Obsidian | Level 7 in SAS Procedures
‎08-20-2015 03:33 PM
‎08-20-2015 03:33 PM
Update:  I think that I got the output statement to work with the following code: %macro regA(dat, port);  proc reg data = &dat outest = regA_&port;   model &port = A B C D E;   restrict B = 0; run; quit; %mend regA; But now it is only outputting the regression coefficients into the output dataset and not any of the statistics information like the tstat or the pvalue. Am I using the wrong output statement!? Thanks, ... View more

Re: proc reg output

by Obsidian | Level 7 in SAS Procedures
‎08-20-2015 03:28 PM
‎08-20-2015 03:28 PM
Sorry, the OUTEST was a typo.  I have fixed it in the original post. Here is the code that I am using: %macro regA(dat, port) ;  proc reg data = &dat;   model &port =A B C D E;   restrict B = 0;   outest out = regA_&port; run; %mend regA; And here is the error that I am receiving: NOTE: The previous statement has been deleted. ERROR 180-322: Statement is not valid or it is used out of proper order. And I tried to put the outest statement in the top line along with the proc reg statement, but then my restrict statement didn't work? the sas dataset name is allowable. Thanks, ... View more

proc reg output

by Obsidian | Level 7 in SAS Procedures
‎08-20-2015 03:09 PM
‎08-20-2015 03:09 PM
Hello all, I have the following proc reg macro that I would like to output the regression parameters into data sets, but I cannot get it to work.  The following code works: %macro regA(dat, port);   proc reg data = &dat;   model &port = A B C D E;     restrict B = 0; run; %mend regA; %regA(a3, core); However, when I add the following statement (which I use all the time) after the restrict statement: outest out = regA_&port I get an error. Thanks in advance ... View more

Can Someone Please Explain this Code to me?

by Obsidian | Level 7 in SAS Procedures
‎03-12-2015 11:29 AM
‎03-12-2015 11:29 AM
Hello All, I am a relatively experienced user of SAS, but I received the following code from another SAS Support member for winsorizing data (which works amazingly, by the way), and I would love it if someone could explain part of his code to me, so that I know what is happening and maybe I could use techniques like this in my later code.  The code is as follows: %let L=10;    %* 10th percentile *; %let H=%eval(100 - &L);   %* 90th percentile*; proc univariate data=have noprint;    by qtr;    var size;    output out=_winsor   pctlpts=&L  &H     pctlpre=__size ; run; data want (drop=_:);   set have;   if _n_=1 then set _winsor;   array wlo  {*} __size&L  ;   array whi  {*} __size&H ;   array wval {*} wsize ;   array val   {*} size ;   do _V=1 to dim(val);      wval{_V}=min(max(val{_V},wlo{_V}),whi{_V});   end; run; I know what the first two parts are doing, setting my limits for the winsorization and using Univariate to get my percentile values for my by variable.  But the third part I don't really understand. What are the two set statements doing and what is _n_ = 1 mean?  I don't have that variable anywhere?  I have never seen _: which shows up in the drop statement.  And what is _V?  I don't see that variable anywhere else? Any help would be awesome, and thanks for taking the time to educate a newbie. John ... View more

Re: Convert Character Date to SAS Date

by Obsidian | Level 7 in SAS Procedures
‎02-20-2015 02:29 PM
2 Likes
‎02-20-2015 02:29 PM
2 Likes
Ok, I was able to figure it out, I just needed to use the correct INFORMAT in the input statement.  The following code works, and I created the merging date variable, called fp, using the INTNX statement: data want;   set have;   newdate = input(date, YYQ6.);   fp = intnx("QTR", newdate, 0);   format fp yyq.; run; ... View more

Re: Convert Character Date to SAS Date

by Obsidian | Level 7 in SAS Procedures
‎02-20-2015 02:21 PM
‎02-20-2015 02:21 PM
Hey Tom, I just updated the first post with a little more detail.   The dates that are in the dataset that I would like to merge with have been converted to quarters using the INTNX function, so I will not be hindered by the first day of the month, etc. In actuality, the format that the character date is in (1998Q1) is perfect, but I need it to be converted to a SAS date and not a character variable. Is there an easy data step way to do this, so that I don't have to input every single date individually with a cards statement?  The dataset that I have has about 10 million observations. Thanks, John ... View more

Re: Convert Character Date to SAS Date

by Obsidian | Level 7 in SAS Procedures
‎02-20-2015 02:00 PM
‎02-20-2015 02:00 PM
I just need it in SAS Date YYQ. format, so that I can merge it with the other data set, in which I have the dates in yyq. SAS Date format. ... View more

Convert Character Date to SAS Date

by Obsidian | Level 7 in SAS Procedures
‎02-20-2015 01:50 PM
1 Like
‎02-20-2015 01:50 PM
1 Like
Hello, I have dates that are important for merging that come in the following character format: 1998Q1 1998Q2 1991Q1 I would like these to be turned into SAS dates, so that I can change the format, and use them to merge with other SAS dates.  I would like to merge with another dataset that has SAS dates in the yyq. format, after using intnx("QTR", date, 0) to turn the dates into quarter measures. I am using the following code, but that is not working: data want;   set have;   newdate = input(put(date,6.),YYQ.);   format newdate yyq.; run; I know that this is probably pretty simple, but just let me know. Thanks, John ... View more

Creating rolling "betas" using regressions on time-series data

by Obsidian | Level 7 in SAS Procedures
‎02-11-2015 06:52 AM
‎02-11-2015 06:52 AM
Hello All, I have data that, essentially, takes the following form: Date               var1                   var2 x/x/xx                        2                         3 x/x/xx                         2                         2 x/x/xx                    2                              1 x/x/xx                    3                              5 x/x/xx                    2                              1 and so on.  What I want to do is regress one variable on another for the previous y periods, and then have the regression beta be output as a variable in the dataset.  For example, if I picked y = 5, I would take an observation, regress var1 on var2 for the past 5 periods, and then the code would return that regression coefficient as a variable in the dataset. I may have done a bad job explaining this, but if you have any questions, please let me know. Thanks, John ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎03-13-2017 01:10 PM
Likes from
Quick links