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: 
mkt_apprentice
‎04-04-2019
  • 33 Posts
  • 11 Likes Given
  • 0 Solutions
  • 0 Likes Received

Adding data into missing cells

by Obsidian | Level 7 in New SAS User
‎03-25-2019 07:02 PM
‎03-25-2019 07:02 PM
Hellow SAS community,   After merging several data sets I have a data set like this:   id  day   age  distance  gender 1    1       21      2           F 1    2        .        0           .  1    3        .        0           . 1    4       21      5           F 1    5       21      1           F 2    1       43      2           M 2    2       43      2           M 2    3        .        0            . 2    4       43      3           M 2    5        .       0             . 3    1       24      5           F  3    2       24      5           F 3    3       24      5           F 3    4       24      5           F 3    5        .        0           .  4    1       18      2          M 4    2        .        0           . 4    3        .        0           . 4    4        .        0           . 4    5        .        0           . 5   1       36       10        M  5   2       36        8         M 5   3       36        8         M  5   4       36        9         M  5   5       36        7         M     Basically the day a person doesn't run, I create a new observation with Distance = 0. However, my merge ended up that I have lots of missing data in all of the rest variables except id and day. How could I add data back to the missing cell where we can infer information from other cells: for example, id 1 is Female (F) by looking at day 1, 4, 5, so day 2, 3 we know that the person with id 1 is Female (F).    Please share what you think can help me solve this issue ... View more

Re: Imput missing data with avaiable values

by Obsidian | Level 7 in New SAS User
‎11-25-2018 05:22 PM
‎11-25-2018 05:22 PM
Thank you for the reference reading! I got that "want" is the newly modified data set by revising master data set "have(obs=0)" by the information in the data set "have". Could you help explain what does "have (obs=0)" refer to? Obs is not a variable right, so what does obs=0 refer to? ... View more

Re: Imput missing data with avaiable values

by Obsidian | Level 7 in New SAS User
‎11-25-2018 05:13 PM
‎11-25-2018 05:13 PM
Hi VDD, what does 0 in the second coding line indicate (retain h_age 0)? ... View more

Re: Imput missing data with avaiable values

by Obsidian | Level 7 in New SAS User
‎11-25-2018 02:24 PM
‎11-25-2018 02:24 PM
Yes, since the person with ID 1 is 35 years old as seen in the row above, the . in the below row should be the same value (35). Could you explain what is  have(obs=0) have in your codes?      ... View more

Imput missing data with avaiable values

by Obsidian | Level 7 in New SAS User
‎11-25-2018 01:36 PM
‎11-25-2018 01:36 PM
Hello SAS members,   I merged some data sets and got some missing values in my new merged data set. Currently it looks like this: ID     Date          Age        Group             Workout_mins 1       1                 35           35                   60 1       2                   .             .                     45 1       3                   .             .                      0   ... So basically age and group stay the same, how can I imput the values based on existing values to the . in the data set (i.e. "." => 35, etc.)   Thanks! ... View more

Re: Aggregate some variables and keep others same

by Obsidian | Level 7 in New SAS User
‎11-25-2018 12:16 PM
‎11-25-2018 12:16 PM
Date has a value fixed like that (probably date order). Drink is a dummy variable if the person drinks on specific day, but I am not sure how to use it in my analysis now 😞 Right now I think age of clients stays the same ... View more

Re: Aggregate some variables and keep others same

by Obsidian | Level 7 in New SAS User
‎11-25-2018 11:57 AM
‎11-25-2018 11:57 AM
Hi novinosrin, I want to sum workout_mins while keeping other variables such as age, sex same. The expected out is like this:  ID      workout_mins_sum          age          sex ... ... View more

Aggregate some variables and keep others same

by Obsidian | Level 7 in New SAS User
‎11-25-2018 11:29 AM
‎11-25-2018 11:29 AM
Hellow SAS members,   I have a data set with some variables I want to aggregate (workout_mins...) by summarizing them and some variables I want to keep the same (age, sex...). How can I do that?    My data is listed like this: ID      Date          Workout_mins         Age        Sex      Drink 1        1                20                           36           1            0        1        2                15                           36           1            1       1        3                 0                            36           1            0       1        4                 0                            36           1            1 1        5                95                           36           1            1 1        6                60                           36           1            1 1        7                60                           36           1            0 2        1                 0                            25           0            0 2        2                10                           25           0            0 .... ... View more

Add observations to id day data

by Obsidian | Level 7 in New SAS User
‎11-11-2018 06:49 PM
‎11-11-2018 06:49 PM
Hello SAS members,   I have a dataset with observations and variables like these:   id     day  workout 1      1      1 1      2      1 1      3      1 1      4      1 1      5      1 2      2      1 2      4      1 2      5      1  3      1      1 3      2      1 3      3      1    So person 1 records all day (1 to 5) as the person work out every day, but person 2 and 3 don't have workout records of day 1, 3 and day 4, 5. Since no records mean no workout, I want to add in observations of 0s for those people (person 2 and 3). How can I do that without manually entering data or 0s to each observation? I have more than 5,000 people in the data.    Thanks!   ... View more

Re: How to convert character format yyyymmdd to a date format ?

by Obsidian | Level 7 in SAS Programming
‎05-02-2018 12:48 PM
‎05-02-2018 12:48 PM
It works! Thanks a lot! ... View more

Re: How to convert character format yyyymmdd to a date format ?

by Obsidian | Level 7 in SAS Programming
‎05-02-2018 12:47 PM
‎05-02-2018 12:47 PM
Thank you! I not only ran it successfully but also understood the gap in my SAS understanding 🙂 ... View more

Re: How to convert character format yyyymmdd to a date format ?

by Obsidian | Level 7 in SAS Programming
‎05-02-2018 12:14 PM
‎05-02-2018 12:14 PM
It says Date is Num Type, Len 8, Format F8. ... View more

Re: How to convert character format yyyymmdd to a date format ?

by Obsidian | Level 7 in SAS Programming
‎05-02-2018 12:10 PM
‎05-02-2018 12:10 PM
My log said: NOTE: Mathematical operations could not be performed at the following places. The results of the operations have been set to missing values. Each place is given by: (Number of times) at (Line):(Column). 121608 at 147:13 NOTE: There were 121608 observations read from the data set ORGIN.DATE. NOTE: The data set ORIGIN.DATE1 has 121608 observations and 356 variables. NOTE: At least one W.D format was too small for the number to be printed. The decimal may be shifted by the "BEST" format. NOTE: DATA statement used (Total process time): real time 1.64 seconds cpu time 0.87 seconds ... View more

Re: How to convert character format yyyymmdd to a date format ?

by Obsidian | Level 7 in SAS Programming
‎05-02-2018 12:06 PM
‎05-02-2018 12:06 PM
Yes, 20081023 is only an example. Date is a variable. How can I change the whole variable or create a new variable to have a format of mm/dd/yyyy or show week day? ... View more

Re: How to convert character format yyyymmdd to a date format ?

by Obsidian | Level 7 in SAS Programming
‎05-02-2018 12:04 PM
‎05-02-2018 12:04 PM
Date is 20081023 so there are 8 spaces. 2008/10/23 would be a yymmdd10. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎04-04-2019 01:20 PM
Likes given to
Quick links