xml - How to retrieve some output values from SPSS Custom Tables? -


i have been trying retrieve specific output values spss custom tables , export them excel. problem ctables syntax generates 2 different tables , want retrieve specific output values both these tables , export excel. link screenshot of spss custom tables. have highlighted values in red want retrieve. trying retrieve these values in xml format, getting error message. here code.

      *1. retrieve output values , insert them text.  begin program. import spssaux gar="ctables     /vlabels variables=institution res_pay status display=label     /table  status [c] > res_pay [c] institution [c][count f40.0, colpct.count pct40.1]    /categories variables=institution order=a key=value empty=include  total=yes position=after    /categories variables=res_pay empty=include    /categories variables=status order=a key=value empty=include    /sigtest type=chisquare alpha=0.05 includemrsets=yes  categories=allvisible."      cmd = spssaux.createxmloutput(gar, visible=true)    result=spssaux.getvaluesfromxmlworkspace(cmd, 'ctables', cellattrib ='text',colcategory='cat1', rowcategory='research pay',rowsubcategory='yes')    result1=spssaux.getvaluesfromxmlworkspace(cmd, 'ctables', tablesubtype='chisquare', cellattrib = 'text',colcategory='status', rowcategory='research pay',rowsubcategory='sig.')    output new    print result[1]    print result1[1]     end program.    *2. export output excel.    output export   /contents export= layers=printsetting modelviews=printsetting  /xlsx documentfile='u:/report1.xlsx'   operation=createfile   location=startcell('c4') notescaptions=yes.

this error message getting

 file "<string>", line 4     gar="ctables      syntaxerror: eol while scanning string literal      ^

can please me code?

you have syntax error in python code. line starting gar= introducing multi-line literal, need enclose in triple quotes,

gar="""ctables
/vlabels variables=institution res_pay status display=label
/table status [c] > res_pay [c] institution [c][count f40.0, colpct.count pct40.1]
/categories variables=institution order=a key=value empty=include total=yes position=after
/categories variables=res_pay empty=include
/categories variables=status order=a key=value empty=include
/sigtest type=chisquare alpha=0.05 includemrsets=yes categories=allvisible."""

however, once these values, printing them viewer , exporting viewer, not want, since these values in table exported. seems roundabout way of doing this. perhaps if describe whole process simpler solution can found.


Comments

Post a Comment

Popular posts from this blog

shopping cart - Page redirect not working PHP -

im trying redirect user when click "empty cart". redirect working "add cart" not "empty cart". ideas great. in main .php file set current url seen $current_url = base64_encode("http://$_server[http_host]$_server[request_uri]"); then below cartaction.php file handles actions such "add cart" , "empty cart" <?php session_start(); include_once 'config.php'; //add item in shopping cart if(isset($_post["add"])) { $product_id = $_post["product_id"]; //product id $return_url = base64_decode($_post["return_url"]); //return url $qty = $_post["qty"]; $product = $mysqli->query("select product_name, unit_price, unit_quantity products product_id = '$product_id'"); $obj = $product->fetch_object(); if(!isset($_session['products'])) { $_session['products'] = array(); } if(array_key_exists($product_id...
Read more

php - How to modify a menu to show sub-menus -

i have custom php menu made person, displays categories menu. however, need display subcategories well. tried adding hierarchical parameter didn't work. hoping assistance! here code: <ul> <?php /* categories wp e-commerce products */ $wpec_product_categories = get_terms( 'wpsc_product_category', 'hide_empty=0&parent=0&exclude=298'); $myarray = array(); foreach($wpec_product_categories $wpec_categories){ $myarray[$wpec_categories->term_id]['name'] = $wpec_categories->name; $myarray[$wpec_categories->term_id]['slug'] = $wpec_categories->slug; $myarray[$wpec_categories->term_id]['term_id'] = $wpec_categories->term_id; } foreach($myarray $wpec_categories1){ $wpec_term_name = $wpec_categories1['name']; $wpec_term_slug = $wpec_categories1['slug']; $wpec_term_id = $wpec_categories1['term_id']; echo '<li> <a href="'.get_page_link(19)....
Read more

python - Installing PyDev in eclipse is failed -

unable read repository @ http://pydev.sf.net/updates/content.xml. sun.security.validator.validatorexception: pkix path building failed: sun.security.provider.certpath.suncertpathbuilderexception: unable find valid certification path requested target i installing pydev in eclipse using python, doesn't install successfully. gives above error. happened? how solve error? i had error when trying install on laptop behind corporate firewall. couldn't tell setup of firewall, not sure of root cause. i got passed error installing pydev eclipse when out behind firewall. another way got around have eclipse on non-firewalled machine, install pydev eclipse, , copy whole eclipse directory non-firewalled machine firewalled machine. there better way, , way fix properly, didn't have time work out firewall doing. this on windows 7 machine (yeah know) not work *nix versions installed through package manager yum or apt.
Read more