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: 
CFF
‎11-25-2015
  • 11 Posts
  • 2 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Create multiple records from single record by timevariable

by Calcite | Level 5 in SAS Programming
‎11-24-2015 12:39 PM
‎11-24-2015 12:39 PM
I misunderstood you.  I have created that now. Should I merge the new dataset with the old?  ... View more

Re: Create multiple records from single record by timevariable

by Calcite | Level 5 in SAS Programming
‎11-24-2015 11:23 AM
‎11-24-2015 11:23 AM
But my dataset still look like:  id  week_start   week_end   year       x1 1           1              52         1998      0 1          53             79          1999      1 1          78             104        1999      1 2            1              52          1998      1 So how do i create these observations indicating each 5-week time period?  What if i choose the first 9 period to contain 4 weeks, and the last 3 to contain 5 weeks,  would that be possible??  Im sorry. Im new to coding. I have tried to search on "do statement sas examples", but none seems to match my problem here.  ... View more

Re: Create multiple records from single record by timevariable

by Calcite | Level 5 in SAS Programming
‎11-23-2015 03:46 PM
‎11-23-2015 03:46 PM
Fantastic response!  1)It is because there are two observations on id=1 in the following year (1999), which i may forgot to point out.  2) It is not explicitly in the dataset, the observations per id is now sat so that they "split" each year, and maybe  if they change their x1-state (as id=1 do in 1999) in a given year.  I dont know if that makes sense. If not, just say so and i would like to try a formulate it again.    With that being said it is not completely random which month to have 4 and which to have 5,  it follows the year calender/a specific year calender. Do you need more information?  Thank you!!!     ... View more

Re: Create multiple records from single record by timevariable

by Calcite | Level 5 in SAS Programming
‎11-23-2015 03:14 PM
‎11-23-2015 03:14 PM
Hi again Astounding  I'm sorry i got the copy-paste wrong. So my reply to you was a little different.  I am close to the goal with your code What i need (and what i have not specified!) is each observation to "dividided" into 12 month - some consistent of 4 others of 5.  I have not adressed which to consist of 5 because i did not believe that it could be coded?  But okay: Each year i know which month to consist of 5 weeks.  Lets say that in first year: 1-52 i know that it is month 5 and 7,8 which should contain 5 weeks,  and it is different in the next year.  Is it possible to code that?  If not. I just want 12 observations per year, and the last month to contain 4 weeks.  PS: Thanks for the quick reply!!       ... View more

Re: Create multiple records from single record by timevariable

by Calcite | Level 5 in SAS Programming
‎11-23-2015 01:57 PM
‎11-23-2015 01:57 PM
This almost solve my problem. But what do i do with the years after that? I have tried: if year=1998 then do: week_start = 1 to 47 by 4; week_end = week_start + 3; output; end; if year=1999 then do week_start = 53 to 99 by 4; week_end = week_start + 3; output; end; run; But it does not seem work. ... View more

Re: Create multiple records from single record by timevariable

by Calcite | Level 5 in SAS Programming
‎11-23-2015 01:51 PM
‎11-23-2015 01:51 PM
This almost solve my problem.  But what do i do with the years after that?  I have tried:  if year=1998 then do:  week_start = 1 to 47 by 4;         week_end = week_start + 3;        output;    end; if year=1999 then do week_start = 53 to 99 by 4;         week_end = week_start + 3;        output;    end; run; But it does not seem work.    run; ... View more

Create multiple records from single record by timevariable

by Calcite | Level 5 in SAS Programming
‎11-23-2015 12:34 PM
‎11-23-2015 12:34 PM
Hi there I have a relatively simple problem, or at least i think so, but after two hours of search, i must admit that i still can't solve it.  What I have is a dataset looking like:  id  week_start   week_end   year       x1 1           1              52         1998      0 1          53             79          1999      1 1          78             104        1999      1 2         .                   .            . And so on for the all my id. So I have that each observation have som characterisk for some interval of time (week_end-week_start). What I want is to "split each observation by into monthly interval:  id  week_start   week_end   year       x1 1           1              4         1998      0 1           5              8          1998      0 1           9              12          1998      0 1          13              16          1998      0 1           17              20          1998      0 1           21              24          1998      0 1           25              28          1998      0 1           29              32          1998      0 1           33              36         1998      0 1           37              41          1998      0 1           42              46          1998      0 1           47              52          1998      0 1           53              56          1999     1 And so on... I do not have a clue, what i am going to do. It could be really nice, if someone could help me. Thanks  ... View more

multiply and subtract in retain function

by Calcite | Level 5 in SAS Programming
‎08-07-2015 03:07 PM
‎08-07-2015 03:07 PM
Hi I have 1 variabel A. I need to create a new variabel B thats i created through the retain function. For the first observation must B must be equal to 1. For all the other values B=1-B*A - where B is the retained result. As an example: Data have: A: 0,5 0,5 0,5 Data want A:       B 0,5     1 0,5     0,5 (calculated as: 1-1*0,5) 0,5     0,75 (calculated as: 1-0,5*0,5) Best regards ... View more

Re: Using retain an multiply down a collumn

by Calcite | Level 5 in SAS Programming
‎08-07-2015 02:53 PM
‎08-07-2015 02:53 PM
Perfect! Thanks. That helped me a lot. But I have a new question: What if I instead having b=b*a, but b=1-b*a in the retain function? If i replaced in the code: data want ;   set have ;   retain b 1;   if _n_ > 1 then b=1-b*a ; run; Then it does not work. What do I do? ... View more

Re: Using retain an multiply down a collumn

by Calcite | Level 5 in SAS Programming
‎08-07-2015 11:56 AM
‎08-07-2015 11:56 AM
Thanks for the quick response! What I have is 2 variabels A and B. Variabel A has all its values, but I want to create variabel B through the function retain. I want the first observation to have the value 1. The rest of the values i want to create as retained value from B and multiply it with the value from A. Numeric Example: What I have (I have created numbers that are easy to illustrate my point): Variabel A:       Variabel B: 0                          . 0.5                       . 0.5                        . 0.5 0.5 What I want then is the retained value to be multiplied with the A Variabel. Variabel A:      Variabel B: 0                              1 0.5                         0.5 0.5                         0.25 16                         4  0,25                       1 etc                           I Hope this makes sense ... View more

Using retain an multiply down a collumn

by Calcite | Level 5 in SAS Programming
‎08-07-2015 10:41 AM
‎08-07-2015 10:41 AM
Hi I have column A and B, where as the first obs in A is set to 0 and the first obs in B is set to 1. I would like to multiply down column B, using retain to that i multiply A*B, where the column B always will have the result from the retain value*value of column A. My code is: if _n_=1 then A=0 and B=1; data check; set example; retain b; b=b*a; run; But that does not seem to work? Best regards ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎11-25-2015 09:53 AM
Likes given to
View All
Quick links