FW: [SPSSX-L] First letters of labels all in lower case
Locked
FW: [SPSSX-L] First letters of labels all in lower case
 
|
For information only. Thanks Bruce and Hillel for your solutions (which I need time to get my head round) but Jon’s Python code worked first time. I’ve taken the attachment off the mail I sent Jon off-list (*.sav with only the two culprit variables) and deleted the screenshot (Data > Define Properties for the two variables, stretched to full width to see longest labels). If anyone wants to see them, just ask and I’ll send the original mail off-list. The data from Understanding Society (previously the British Household Panel Survey) represent a major resource for research and teaching, but first time users will find the thorough and detailed documentation and downloads daunting and baffling. I’m still finding my way round everything, but am keeping a log (with screenshots and hyperlinks) which will form the basis of a user-friendly introduction for such users. This will eventually be posted on my site and notified to appropriate lists. John F Hall (Mr) [Retired academic survey researcher] Email: [hidden email] Website: www.surveyresearch.weebly.com SPSS start page: www.surveyresearch.weebly.com/spss-without-tears.html From: John F Hall [mailto:[hidden email]] Jon Just found this in my junk folder! I’m sure it’s a value label, but for which variable(s)? I’ve checked the 400 page Word doc containing the dictionary and found: Pos. = 1268 Variable = a_jbsic07 Variable label = current job sic2007 This variable is numeric, the SPSS measurement level is scale. Value label information for a_jbsic07 Value = -9 Label = missing Value = -8 Label = inapplicable Value = -2 Label = refused Value = -1 Label = don't know Value = 1110 Label = Growing of cereals (except rice), leguminous crops and oil seeds There are some very long labels here for Standard Industrial Classification, which has dozens of values, but they all start with upper case letters. Some of them wrap round, so these may be the culprits. Value = 26309 Label = Manufacture of communication equipment other than telegraph, and telephone apparatus and equipment Value = 26400 Label = Manufacture of consumer electronics Value = 26511 Label = Manufacture of electronic measuring, testing etc. equipment, not for industrial process control Value = 26512 Label = Manufacture of electronic industrial process control equipment Value = 26513 Label = Manufacture of non-electronic measuring, testing etc. equipment, not for industrial process control I’ve just tested your code on a smaller file and this ran with no problem, so I ran it again on the large original (fascinating to watch the processor whizzing through) and picked up the problem label text from the warnings. On checking the two variables involved with Data > Define Variable Properties [best thing yet in SPSS] the full text of the longest value labels appears, so the warning messages can be ignored. [Screenshot here of value labels] Nice to be able to stretch the display, but it always bounces back afterwards. I’ve attached a file with just the two SIC variables, if you want to track down the reason for the warnings. John From: Jon K Peck [[hidden email]] I didn't see anything like that in my test. Is the text like Metal machin in a value label? And if so, does the variable in question have a large number of these? |
| Free forum by Nabble | Edit this page |