Step 1<\/h3>\n
Create a new variable called Quarter by going into the variables window \u2013 View | Variables | click the + icon to insert a new variable.
\n![\"Variable](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2017\/03\/ws6_f1v2.gif\")
<\/p>\n<\/div>\n
Step 2<\/h3>\n
Set the Type to Derived and Response to Single.<\/p>\n<\/div>\n
Step 3<\/h3>\n
For the first quarter, specify the appropriate range of dates:<\/p>\n
Q1 >= 1 Jan 04 and Q1 < 1 Apr 04<\/p>\n
Any appropriate date format can be used to specify the fixed dates your are checking against.<\/p>\n
In some circumstances, it is possible to simplify the specification. For this example we could have used Snap’s in-built month function to give us a number representing the month of the year (1=January, 12=December). Using that, we can set up the codes of the categorizing variable as follows:<\/p>\n
| Label<\/th>\n | Value<\/th>\n<\/tr>\n |
|---|---|
| First Quarter<\/td>\n | Q1 month <= 3<\/td>\n<\/tr>\n |
| Second Quarter<\/td>\n | Q1 month <= 6<\/td>\n<\/tr>\n |
| Third Quarter<\/td>\n | Q1 month <= 9<\/td>\n<\/tr>\n |
| Fourth Quarter<\/td>\n | Q1 month <= 12<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n We have simplified the specification by using the month<\/strong> function and by taking advantage of the fact that for a derived single<\/strong> variable, we only need to specify the upper bound for each code value (any respondent in the previous code will already have been captured by that code). Also note that this version will work regardless of the year the survey was conducted in.<\/p>\n Other built-in functions that may be used for extracting information from dates are:<\/p>\n Q1 weekday<\/strong> will give the day of the week (1=Monday, 7=Sunday) So it would be possible to build a similar derived variable to categorize replies according to the day of week (regardless of the month or the year) by using the weekday function in a similar way to our month function was used in the previous example.<\/p>\n<\/div>\n If there is a topic you would like a worksheet on, email to snapideas@snapsurveys.com<\/a><\/p>\n","protected":false},"excerpt":{"rendered":" |