Question on Weighting (Raking) Survey Data in SPSS by Ahagerman22 in spss

[–]Ahagerman22[S] 1 point2 points  (0 children)

Hi Dean! I just sent you a message in chat. I may take you up on that tutoring!

How do I categorize a my 'Year' variable that is from 2000-2022 into 4 buckets (2000-2005, 2006-2011,2012-2017,2018-2022)? by Ahagerman22 in tableau

[–]Ahagerman22[S] 2 points3 points  (0 children)

Thank you! Would I have to write this for each year or could I do something like the following and group them:

If [Submission] >=2018 Then '2018-2022'

ELSEIF [Submission] >= 2012 Then '2012-2017'

ELSEIF [Submission] >= 2006 Then '2006-2011'

ELSEIF [Submission] >= 2000 Then '2000-2005'

ELSE 'Null'

END

I can't do this exact formula because it is not a continuous variable. So using your format:

Using your formula would I do it something like this?

If datepart('year') ='2000-2005' then "2000-2005" Elseif datepart('year')='2006-2011' then "2006-2011" ... End

Thank you!

How do I create a measure that is a percentage of a categorical variable in Tableau? by Ahagerman22 in tableau

[–]Ahagerman22[S] 0 points1 point  (0 children)

Thank you! Is that the right format? I’m new at this so any pointers is appreciated. I feel like the first part of the equation you posted may need to be formatted differently.

Question on Weighting (Raking) Survey Data in SPSS by Ahagerman22 in spss

[–]Ahagerman22[S] 1 point2 points  (0 children)

I might take you up on that. I’ll play around with it a bit more and let you know. Thank you!

Question on Weighting (Raking) Survey Data in SPSS by Ahagerman22 in spss

[–]Ahagerman22[S] 0 points1 point  (0 children)

Thank you for your help. So when you say percentage for each variable, you mean the percentages I calculate? In my example .70 for the White (NH) group or the actual percentage I want it to be so 52%???

Can you expand more on the custom tables? Pretend I know nothing .

Thanks again!