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: 
mariamon0
‎05-15-2020
  • 34 Posts
  • 1 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: SAS character to numeric

by Fluorite | Level 6 in SAS Programming
‎03-06-2020 11:10 AM
‎03-06-2020 11:10 AM
the id= 23434 just a number the pid= 23423 is also just a number study_id is BOM234 letters and numbers I am trying to sort by just study_id I want id and pid to be be renamed as study_id ... View more

SAS character to numeric

by Fluorite | Level 6 in SAS Programming
‎03-06-2020 11:02 AM
‎03-06-2020 11:02 AM
I have an id variable in one study that is numeric and a study_id variable in another study that is a character. How do I harmonize these so that study_id=id as well as change them from character to numeric. ... View more

SAS Character and Numeric and harmonization

by Fluorite | Level 6 in New SAS User
‎03-06-2020 11:00 AM
‎03-06-2020 11:00 AM
I have a marriage variable called v1marital in one dataset and v_martial_0 in another. I am trying to harmonize the variables and also change from character to numeric. However, the variables have different conditions and I want vmarital=2 to equal 3 =v_marital_0. I'm not sure how to go about this. V_MARITAL_0 1=single, never married 2=married, co-habituating 3=divorced or separated 4=widowed and V1MARITAL 1=single, never married 2=separate 3=divorced or annulled 4=widowed 5=married   ... View more

My duplicates wont delete

by Fluorite | Level 6 in New SAS User
‎09-30-2019 10:35 AM
‎09-30-2019 10:35 AM
I use the code: proc sort nodupkey nodup data=finaldata out=unique; by study_id; run; *get count of people in the dataset=153 there are 6 duplicates.   When I do a proc means it still shows the 6 duplicates. there are a lot of variables in my data set and I want to delete certain study_id duplicates.   proc means data=finaldata; var v_ht_0; by intervention; run;    ... View more

Re: SAS variable is uninitalized

by Fluorite | Level 6 in SAS Programming
‎09-16-2019 10:55 AM
‎09-16-2019 10:55 AM
  I fixed it but its still coming up as an error.   Missing values were generated as a result of performing an operation on missing values. Each place is given by: (Number of times) at (Line):(Column). 10028 at 3824:20 10028 at 3825:21 NOTE: There were 53186 observations read from the data set WORK.STEPDATA3. NOTE: The data set WORK.STEPDATA4 has 43158 observations and 14 variables. NOTE: DATA statement used (Total process time) 3830 proc freq data=stepdata4; 3831 where stepvalid=1 and C6_day1 le 14; 3832 tables study_id/ noprint out=counts (rename=(count=per_study_id) ) ; 3833 run; NOTE: No observations were selected from data set WORK.STEPDATA4. NOTE: There were 0 observations read from the data set WORK.STEPDATA4. WHERE (stepvalid=1) and (C6_day1<=14); NOTE: The data set WORK.COUNTS has 0 observations and 3 variables. NOTE: PROCEDURE FREQ used (Total process time):   data stepdata4; set stepdata3; format C6_date mmddyy10. C6_day1 mmddyy10. C6_day14 mmddyy10. ; C6_day1=C6_date+1; C6_day14=C6_date+14; if C6_day1 le 0 then delete; run; proc freq data=stepdata4; where stepvalid=1 and C6_day1 le 14; tables study_id/ noprint out=counts (rename=(count=per_study_id) ) ; run; proc freq data=counts; tables per_study_id; run; ... View more

Re: SAS variable is uninitalized

by Fluorite | Level 6 in SAS Programming
‎09-16-2019 10:49 AM
‎09-16-2019 10:49 AM
yes but it is still saying 0 observations when I run it ... View more

SAS variable is uninitalized

by Fluorite | Level 6 in SAS Programming
‎09-16-2019 10:46 AM
‎09-16-2019 10:46 AM
  I believe my merging of the datasets is fine but I am trying to analyze the data and it keeps coming back with this error: Variable C06_day1 is uninitialized. NOTE: Missing values were generated as a result of performing an operation on missing values. Each place is given by: (Number of times) at (Line):(Column). 8969 at 2753:20 8969 at 2754:21 NOTE: There were 51080 observations read from the data set WORK.STEPDATA4. NOTE: The data set WORK.STEPDATA5 has 0 observations and 17 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds   I am trying to create new variables C6_day1 and C6day14 which are 1 day and 14 days after the C6_date. Every time I run this it says there is 0 observations. Even though it successfully merged with my other datasets.   data stepdata5; set stepdata4; format C6_date mmddyy10. C6_day1 mmddyy10. C6_day14 mmddyy10. ; C6_day1=C6_date+1; C6_day14=C6_date+14; if C06_day1 le 0 then delete; run; ... View more

Re: SAS code help

by Fluorite | Level 6 in New SAS User
‎09-06-2019 11:08 AM
‎09-06-2019 11:08 AM
thanks for clearing that up! makes sense now! ... View more

Re: SAS code help

by Fluorite | Level 6 in New SAS User
‎09-06-2019 10:40 AM
‎09-06-2019 10:40 AM
But I want to know how many study ids have 10 valid step days...this doesnt produce what I need ... View more

Re: SAS code help

by Fluorite | Level 6 in New SAS User
‎09-06-2019 09:53 AM
‎09-06-2019 09:53 AM
data stepdata3; set stepdata2; format date mmddyy10. ped_date mmddyy10. match_date mmddyy10. baseline_day1 mmddyy10. baseline_day10 mmddyy10.; ped_date = date; if steps >31000 then steps = .; if steps >= 200 then stepvalid = 1; else if steps < 200 then stepvalid = 0; else stepvalid = .; match_date = ped_date; run; I want to know how many of my study_id's have 10 stepvalid days 9 stepvalid days etc. ... View more

SAS code help

by Fluorite | Level 6 in New SAS User
‎09-06-2019 09:32 AM
‎09-06-2019 09:32 AM
I am trying to determine how many "valid wear days" my participants have. I have already determined a step valid to be more than 200 steps. stepvalid=1 vs. stepvalid=0 I want to know how many participants have 10 valid wear days 9 etc. How would I code this? I assume I use proc freq  ... View more
Labels:

Re: Missing Values

by Fluorite | Level 6 in SAS Programming
‎03-14-2019 07:45 PM
‎03-14-2019 07:45 PM
There were many different variables that the subject IDs have. Im only looking to see if the subject IDs (there are over 500) are missing cholesterol values. There is only one single cholesterol value for each subject ID. I would like a list of all subject Ids with missing cholesterol values.  ... View more

Missing Values

by Fluorite | Level 6 in SAS Programming
‎03-14-2019 07:27 PM
‎03-14-2019 07:27 PM
How would I list the missing values of a particular variable?   for instance how would I list subject IDs (Variable is ID-numeric variable) who have missing cholesterol values (variable col-numeric variable) in sas code? ... View more

Re: Make a new variable from an existing variable

by Fluorite | Level 6 in SAS Programming
‎03-04-2019 05:55 PM
‎03-04-2019 05:55 PM
yes I would have to use in. not sure what the exact coding should be together ... View more

Re: Make a new variable from an existing variable

by Fluorite | Level 6 in SAS Programming
‎03-04-2019 05:12 PM
‎03-04-2019 05:12 PM
basically I want the new variable LCuser to have the following conditions if the users cigcur said 1 or 2, if the bidicur users said 1 or 2 and if the cigsmokernew said 0.   Do I do if statements? Or Lcusrer=if the users cigcur said 1 or 2, if the bidicur users said 1 or 2 and if the cigsmokernew said 0; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎05-15-2020 05:01 PM
Likes given to
View All
Quick links