About shortyofhb

shortyofhb · ‎12-17-2020

I looked at the data. There is a 18-29 interval and a 20-29 interval in the dataset. So I created an 18-29 Value in the proc format. But 0-18 did not read the "Under 18" value in the datasheet. The excel data sheet says "Under 18" so I am not sure how to get this to read.

shortyofhb · ‎12-17-2020

Hello all, I need some help in cleaning up an external dataset if possible, I would greatly appreciate it! I imported an external excel dataset into SAS. The variable age is in intervals of age groups (20-29, 30-39, etc.) I am supposed to format the age into age groups and clean the dataset to make it look nice. The issue I am running into is that the dataset has a bunch of messy values like (20ag-29, 30-39exa, Under 18, 70 and above, and missing values). First I used a compress function to rid of any letters or symbols in the dataset, but then I got stuck. I normally use a Proc Format to create my age variables and so far have: Proc Format Library=WorkData; Value Ageft. 18-29 = "18-29" etc. all the way to 60-69. However, how do I take into account the values that say "Under 18" "70 and above" as well as the blank cells? Would I need to use an array for the blank cells and code them as missing? Thank you in advanced! (Note: When I run a Proc Freq, it takes into account everything except the "Under 18" values. I used 70-99 = "70 and above" and I think that read fine.")

shortyofhb · ‎12-17-2020

Proc Format Library=A; Value $Ageft other = "0-17" 18-29 = "18-29" 30-39 = "30-39" 40-49 = "40-49" 50-59 = "50-59" 60-69 = "60-69" 70-99 = "70+"; run; The issue I am having is the age variable in my dataset is very messy. It has age groups in intervals of 10, but some of the values have "20-29gt" or "30s-49" or "Under 18" or "70 and above" How would I go about organizing this data? I used a compress function to get rid of any extra letters of symbols ($,&, etc.) out of the age intervals. But I do not know about to go about now formatting it so "Under 18" or "70 and above" will properly be coded. In addition, I need to take into account missing cells. Any suggestions would be great!

shortyofhb · ‎12-17-2020

Great that worked, thank you!

shortyofhb · ‎12-17-2020

Ah okay maybe I didn't ask the question clearly. So I need to run a logistic regression model using the parameterization method. I know my outcome variable of interest should be Yes=1 and No=2. (These are my newly formatted variables however, I used an array to recode No=0 to No=2) In my data set, for my outcome variable of interest, I have Yes=1, No=2, and Missing=9. If I run a proc freq, I have 1,2, and 9 pop up. Is there a way for my to run this proc logistics while ignoring the 9?

shortyofhb · ‎12-17-2020

Hello when I tried it the way you suggested I get an error in the log: ERROR: WHERE clause operator requires compatible variables. Note: I must use the Param=Ref Ref="Male" ... etc line

shortyofhb · ‎12-17-2020

So I would have Proc data=x; Class Gender (Param=Ref Ref="Male") Outcome (Param=Ref Ref="No"); Where Outcome = "No", "Yes"; Model Outcome=Gender; run; Or how would I use the where to only read "No" and "Yes" but not the 9 that codes for missing?

shortyofhb · ‎12-17-2020

Hello all, I am trying to use a Proc Logistic to run a regression, but am getting stuck. I keep getting a note in the log that says: NOTE: The REF= option for the response variable is ignored. NOTE: PROC LOGISTIC is fitting the cumulative logit model. The probabilities modeled are summed over the responses having the lower Ordered Values in the Response Profile table. Use the response variable option DESCENDING if you want to reverse the assignment of Ordered Values to the response levels. NOTE: Convergence criterion (GCONV=1E-8) satisfied. I know that when running a proc logistic the outcome variable should be dichotomous right? I believe the issue is that I have values coded for No (1) and Yes (2), but also have 9 set to missings, I see in my Proc Logisitc output its reading the 9, how would I make it not read this extra value and only the 1 and 2?

shortyofhb · ‎12-17-2020

I have to do the same thing but with cities, do you know how I would incorporate propcase into it? Would I do the same, and then just make a new function that propases the new variable name?

shortyofhb · ‎12-17-2020

Its a huge dataset, but if I run a proc freq it should show me the different values and then I could input those that pop up right?

shortyofhb · ‎12-17-2020

I think if it is just "mal" I would like to make it "Male"

shortyofhb · ‎12-17-2020

Hello all, I have a question regarding Proc Format and the value statement. I have an external dataset that has age grouped into age ranges. The dataset needs to be cleaned and organized. For values such as 20-29ax or 30s-39 I used the compress function to squeeze out the letters and used a Proc Format to change those to "20-29" and "30-39" However, what do I do about the excel columns that just say "Under 18" how would I clean that to make it presentable in SAS. I tried to do 0-17 but it didn't work because on the excel dataset it just says "Under 18"

shortyofhb · ‎12-17-2020

Hello all, I have a data cleaning question. I was given an external dataset that I imported into SAS. One of the tasks is to clean the dataset and rename the variables. How would I go about cleaning a variable that has multiple different values. For example, my gender variable has Female, Femalee, Fame, emale, etc and Male, Malee, ale, Maale, etc. I initially tried to use an If, Then statement but didn't know how to do it since not all the values start with M or F.

shortyofhb · ‎12-16-2020

Oh okay I think I see what you are saying. So then I have one array that recodes my 9's to .'s. I will have a second array that recodes all my 2's to 0's. I will use a new value statement in my proc format to now tell SAS that 0=Yes right? And then attach this value to the variable I recoded? Or am I interpreting this wrong? Do I remove the previous format from that was one the variables before this new one? I currently have a proc format. My variables Then a format option to tell SAS what I want the variable to code for.

shortyofhb · ‎12-15-2020

Hello, So I used one array to recode my 9 to "Missing" (.) I just did the array statment then did a Do loop where it says If 9 then . But how would I use the array to recode my 2 to 0 while still formatting out as "Yes" in the output?

Online Status	Offline
Date Last Visited	‎12-18-2020 01:14 AM

Re: Data Cleaning

Data Cleaning

Re: Proc Format Question - Value statement

Re: Proc Logistic help

Re: Proc Logistic help

Re: Proc Logistic help

Re: Proc Logistic help

Proc Logistic help

Re: Data Cleaning

Re: Data Cleaning

Re: Data Cleaning

Data Cleaning

Re: Proc Format Question - Value statement

Re: Proc Logistic help

Re: Proc Logistic help

Re: Proc Logistic help

Re: Proc Logistic help

Proc Logistic help

Re: Data Cleaning

Re: Data Cleaning

Re: Data Cleaning

Proc Format Question - Value statement

Data Cleaning

Re: Using an array to recode a variable

Re: Using an array to recode a variable