About rfarmenta

rfarmenta · ‎03-17-2014

That is interesting because there is no place in my code where I try to assign "[Skipped]", from what I can see it is part of the data. My code for that variable is the following: if (whoshck3=1) or (whoshcko=1) then whoshcko=1; if (whoshck3=0) or (whoshcko=0) then whoshcko=0; if (whoshck3=.) and (whoshcko=.) then whoshcko=.; *Specify other Who did you share cooker, coton or rinse water with in the last 6 months; if WHOSHCKO= "HOOK UP" then WHOSHCKD=1; if WHOSHCKO= "alone" then WHOSHCKK=1; if WHOSHCKO= "doesn't share" then WHOSHCKK=1; if WHOSHCKO= "no one" then WHOSHCKK=1; if WHOSHCKO= "uses own stuff alway" then WHOSHCKK=1; if WHOSHCKO= "n/a" then WHOSHCKO=1; There are other variables with the "[Skipped]" but that is someting from the dataset that was exported out of QDS, not something I created. any thoughts on this? Thanks for your reply.

rfarmenta · ‎03-17-2014

I am not sure what this error means, the [SKIPPED] is not numeric as far as I know. Can anyone help with this? NOTE: Invalid numeric data, whoshcko='[Skipped]' , at line 3234 column 21.

rfarmenta · ‎03-17-2014

I just noticed the typo and got it to run, I used .S and everything seemed to work correctly. Thank you all for your suggestions.

rfarmenta · ‎03-17-2014

Do I have to assign the array for all of my variables? I am a little confused by your code, whar does the n_numeric refer to? I was able to get the code to run but it did not do anything to the -5. Thank you for your reply!

rfarmenta · ‎03-17-2014

I have an interesting case where all values of -5 in my dataset should be set to missing. I don't want to have to do this for every variable separately, is there way to recode all instances of -5 in the dataset as missing or .S? Any help would be greatly appreciated. This came about from the way a QDS interview was programmed for skipped questions. Thank you in advance!

rfarmenta · ‎03-04-2014

You last statement is exactly what I want to do, clear the other variable when the option is used/re-categorized. If the other had more than 1, then it would not be re-categorized into the variable because these are all select one variables. Will try some of the code and see what I can come up with.

rfarmenta · ‎03-04-2014

With the other options, there are more responses than just those listed, so if I have the code DGOTH3A2 = "";, will that clear out all of the responses and not just those listed? I agree with not changing the source data but in this case, the first option for the question was "I drank it", so the other response can safely be re categorized there to have less missing data. We are also creating new variables based on the other responses for analysis purposes. Thanks for you help.

rfarmenta · ‎03-04-2014

I had an intern help me recode other responses on a questionnaire. We had to recode them because several interviewers were typing in responses into the other field that could have fit into a category. The intern placed several other responses into categories but now I need to delete them out of the other field since they are now recategorized. For instance: if DGOTH3A2="DRANK" then DG6FQ3AG=1; else if DGOTH3A2= "DRANK IT" then DG6FQ3AG=1; else if DGOTH3A2= "DRINK" then DG6FQ3AG=1; else if DGOTH3A2= "DRINK IT" then DG6FQ3AG=1; else if DGOTH3A2= "DRINKING IT" then DG6FQ3AG=1; else if DG6FQ3AA>. then DG6FQ3AG=0; She did not include code to say, to delete the "DRANK", for instance, from the other field variable DGOTH3A2, is there a way to do that short of me writing code that says: if DGOTH3A2="DRANK" then delete. We have lots of these we had to do this for so any help would be greatly appreciated.

rfarmenta · ‎11-08-2013

I tried that and it doesn't work, it is really weird. I've tried a few things and nothing seems to work...

rfarmenta · ‎11-07-2013

I have an excel dataset, when I read the data in SAS it is adding extra decimal places, the values all have two in excel, example: 21.71 24.63 ... When SAS reads the values in they have like 10 decimal places, so: 21.71342342349 etc.. Why is SAS doing this and how do I get it to stop? Thanks for your help!

rfarmenta · ‎08-28-2013

I figured it out, you are correct ballardw, I have a condition that is not met but where I can't fill in the missing. They answered Yes to dgeverc and dgevere but did not answer oldvar so I don't know whether it is yea or no, therefore, I must keep those as missing values. Thank you or your input. I am just glad there was nothing wrong with my code and my logic is ok.

rfarmenta · ‎08-28-2013

I trying to fill in missing data in a dataset based on skip patterns and other variables but it does not seem to be doing what I want it to. I am not sure if there is a problem with my logic or the code and would appreciate some help. Here is the code I have: newvar_6m=.; if oldvar=1 then newvar_6m=1; else if oldvar=0 then newvar_6m=0; else if dgeverc=0 then newvar_6m=0; else if dgevere=0 then newvar_6m=0; else if (dgeverc=.) and (dgevere=.) then newvar_6m=.; The oldvar has 91 missing based on skip patterns because if participans answered no to previous questions then they skipped this question. However, I know that if they said no to previous questions, then the oldvar should also be no so I created code to fill in the missing and create newvar_6m. the variable dgeverc has 0 missing, and dgevere has 44 missing. I figured the code above would fill in the missing for newvar_6m so it had no missing since all missing should be recoded to 0, what did I do wrong? I am sure it is a dumb mistake I am not picking up on so any suggestions would be appreciated.

rfarmenta · ‎08-21-2013

Is there a way to export proc contents to an excel file? It would be nice to have the variable name, the label, and the format name to easily create a data dictionary. I have tried a couple different ways but they never come out right. Thanks in advance.

rfarmenta · ‎08-21-2013

I was informed by the company that there is an error in how they export the formats for SAS and am downloading the patch and hope that will work. We have over 1500 variables so I do not want to have to create formats myself. Jaap, I do want to use the formats, I think I accidentally put "not" instead of "now" in my last response, sorry about that. Thanks again everyone for your help.

rfarmenta · ‎08-20-2013

Thank you for the information. I was able to get the transport files to work for the data and am not trying to get the formats to work. I keep getting the error, "ERROR: This range is repeated, or values overlap: 9-9.", when reading the formats provided by QDS into sas.

Online Status	Offline
Date Last Visited	‎06-24-2019 08:44 PM

Re: Summarize data from long dataset

Re: Summarize data from long dataset

Summarize data from long dataset

Re: Creating new variables from long data

Creating new variables from long data

Re: Calculate percent missing in long dataset

Calculate percent missing in long dataset

Re: How do I calculate time spent in heart rate zones from heart rate ...

Re: How do I calculate time spent in heart rate zones from heart rate ...

Re: How do I calculate time spent in heart rate zones from heart rate ...

Re: Export SAS file to text or CSV

Re: Export SAS file to text or CSV

Re: Combine variables

Re: List all variables in SAS

Re: Merge duplicate records in SAS

Read password protected excel file into SAS

Re: Export SAS file to text or CSV

Re: SAS Error

SAS Error

Re: Recode all instances of -5 to missing

Re: Recode all instances of -5 to missing

Recode all instances of -5 to missing

Re: Recoding Other responses

Re: Recoding Other responses

Recoding Other responses

Re: SAS decimal places

SAS decimal places

Re: Craeting a new variable- code issue

Craeting a new variable- code issue

Export Proc Contents

Re: Save sas formats

Re: Save sas formats