Home

PC-Axis 2008

1. Stop recording of saved query h Women Men Women Run saved query 1 2 3 4 3 Close B T B J Save Ctrl 5 10 8 4 Save as 2 pl 4 Page layout D 1 2 Print preview t 2 D qi Print Ctrl F B 1 0 To Maintenance 0 T 3 Database contents 10 a q 1 Classification 2 El 4 B 2 5 l Excel qF Internet Explorer You will see all the steps you have selected since you started recording PC AXIS 2007 www scb se w Avsluta inspelning och spara fragor Klicka p det steg du vill editera Sparad fr ga gzelval c Databas TabellerslIrvalBE c D atabas Tabeller BE0101 c SDATABASSTABELLERN bem c ADratabassTabellerPreot psq c ADATABASSTABELLERSV cSDATABASSTABELLER ce DatabassTabellerKornwEx c SDATABASSTABELLERSB c SDATABASSTABELLERS Sparad fr ga Spara Infil LItfil Pe tel Spara utan att andra filnamnen Stoppa spara j If you want the recorded actions in a catalogue of its own you just click the down left ticking box The names that can be seen in the window of steps above will not be changed and does not need to be changed in this case If you on the contrary would like to save more than one recording in the same catalogue you has to rename some of the fields in each step Click on the first line as can be seen below and the different items opens for editing below the window The phrasing tmp must be changed for instance I
2. Statistics Sweden Statistiska centralbyr n www scb se PC Axis 2008 user s manual PC Axis 2008 main module including function to create own aggregations News in PC Axis 2008 Change variable order on graph screen new button to easily transform the table to time series Save change of texts when recording to pxq file the text for contents was introduced in 2007 now change of units and variable names can also be made Remove lines with 0 and dots Save to Google earth show data on Google Map LIST OF CONTENTS TOJUNSTALIZPCSA NIS zitat a pu eects ead cede eda cate se canes ea eere a 2 SOME INFORMATION ON PC AXIS AND ITS HELP FUNCTIONS 2 A WALK THROUGH OF THE TOOLBAR eere nn 3 OPEN ADA TA BASE INT CSANIS aniio iE EHE EIER 4 MAKE A TABLE IN PC A XDS icocct cse cuectez ortesceecos eser sese RE ageres voe Poe ea Eve ae Ps Pere su et ees ees 5 TOSAVEA TABLE iconen renean ar E err ea nE EEEE 11 TO EDIT A TABLE IN PC A XIS dre SI IE UINN SE SuEEI Roo 0002 uu 0002 00 000002 nanasan Ei ina 13 TO DO SIMPLE CALCULATIONS USING PC AXIS eee eeee eene eee ette een ane 15 UPDATING TABLES 2 iss csese edecetis ete c uade se Quse aequ Css odetcoti ede crc ese Du Edu eau Der e toa E OU EEeUS 17 TO MAKE GRAPEDS IN PC AAU iioii arai equa ein su eie senate inae eee ro eei Pe Ec rao 18 PX MAP PRESENTS THE STATISTICS AS A THEMATIC MAP 20 ABOUT ADVANCED FU
3. 2000 2001 EA Subtract Total Men Women Total Men Women Total 4 00Swed Multiply meo Divides 535013 237667 225619 463286 234563 222247 456810 8 5 9 Add table 606462 306059 290905 596964 292851 278807 571658 17 1014 Subtract table 516471 295241 279768 575009 306524 290550 597074 8 1519 Multiply table 503056 260267 246371 506638 264295 249528 513823 g 2024 Divide table 557568 264190 254366 518556 262816 253373 515189 Moy 25 29 307635 295894 603529 301940 291726 593666 298385 288161 596546 11 30 34 335493 317154 652647 324572 310024 634596 318075 305392 623467 12 35 39 298526 285308 583834 318476 303389 621865 328930 312662 641592 33 40 44 299385 289038 588423 298117 287357 585474 297255 296645 583900 44 4543 315607 307753 623360 296851 289163 586014 296215 288383 584598 M5 50 54 328290 317461 645751 327237 320973 648210 319216 313621 632837 Me 55 59 242681 239471 482152 290365 282921 573286 307550 299748 607298 47 60 64 198051 207013 405064 216354 220577 436931 222999 225789 448788 18 5563 185062 208276 393338 180651 199095 379746 181531 197748 379278 48 70 74 173941 209527 383468 165337 198700 364037 153932 196331 360263 20 75 79 145539 196381 341920 147089 196361 343450 143428 190150 333578 EZ 80 84 89625 144817 234442 93575 147482 241057 98479 153568 252047 122 85 89 43804 89558 133362 46155 93258 139423 46648 93631 140279 23 90 94 12374 34419 46793 14105 3865
4. 84 85 CODES civilstand UG GI SK EN PRESTEXT tid O DOMAIN omr de VPQ RADE DOMAIN kan VPK N DOMAIN alder VPALBER DOMAIN civilstand J VPEGTSTIL ELIMINATION omr de f Hele landet ELIMINATION alder y Alder i alt DECIMALS 0 SHOWDECIMALS 0 LAST wmABrET 19990621 00 00 STOCKFA F SOURCE Danmarks Statistik CONTACT Thomas Norup DS Per O1 telefon s Pedersen DS Bru i6fZstelefon COPYRIGHT YES DATABASE SUM Databasen REFPERIODs BASEPERIOD 39173158 fax Tryk p F1 for at f hj lp 39173308 fax e post Rt agi aor Papi ras ae 49 roo ae aq 52 s 53 m roa o5 Ae SS Git mo e og og Los nut ats o n gg go roo om 92 eS 93 n gar toSt ger Og m POR fe rngg e post TNO DST DK X400 Lar LAP DST DK xX400 s of NUM A Picture30 Saved Queries in PC Axis Main Module PC Axis has an option to record a sequence of work and run as a batch You can record calculations pivot and convert but not change text in the Edit menu It is also possible to decide how the time variable is to be treated Select for instance to always use the last time period s or to start with the same time period but add new time periods as they are available To use this option you start by selecting recording under the file menu Ay PC AXIS File View Help trto Ctrl I Open Database Import 30 St
5. 4 name time gt lt valuespecification gt text lt valuespecification gt lt values gt lt value order 1 gt 2005 lt value gt lt value order 2 gt 2006 lt value gt lt values gt lt variable gt lt variable order 5 name sex gt 36 PC AXIS 2007 www scb se lt valuespecification gt code lt valuespecification gt lt values gt lt value order 1 gt 1 lt value gt lt value order 2 gt 2 lt value gt lt values gt lt variable gt lt variables gt lt pxquery gt lt pxquery step 2 gt lt function gt pivotmanual lt function gt lt files gt lt infile gt C pxtemp tmp6 px lt infile gt lt outfile gt C pxtemp TMP7 PX lt outfile gt lt errorfile gt C pxtemp TMP7 err lt errorfile gt lt files gt lt query gt lt stuborder gt 1 2 lt stuborder gt lt headorder gt 4 5 3 lt headorder gt lt query gt lt variables gt lt noofvar gt 5 lt noofvar gt lt variable order 1 from 1 gt region lt variable gt variable order 2 from 2 gt marital status variable lt variable order 3 from 4 gt time lt variable gt lt variable order 4 from 5 gt sex lt variable gt lt variable order 5 from 3 gt 10 years lt variable gt lt variables gt lt pxquery gt lt pxqueries gt The tag valuespecification is created as code if the keywords Values and Codes exist in the PC Axis file and as text if only Values exists The values for a variable which use
6. Hierarchical value set N sub areas Press on the button named Agegregations 2 PC AXIS 2007 www scb se Aggregation for ALDERT Aggregation List M ame 10 vearclazses Description Allow values ina group to overlap Values Values Included Ma 10 Picture 29 1 In the upper field the name of the aggregation list is entered for example 10 yearclasses This name will be used in the table heading when this aggregation list is used 2 In the next field every single group is named Code and text for example 0 9 in both fields in this case Before every new group you press the button Add 3 In the bottom field you select the values that shall be included into the group for example 0 1 2 3 4 5 6 7 8 9 They will be found in the right hand side list and then transferred to the left using the arrow key on the screen If it is not ticked on Allow values in a group to overlap the values will disappear from the right hand box when clicked to the left This 1s the most common way of using classification If you make groups that contains for example 0 4 years and also one 0 9 years it is necessary to tick the Allow values in a group to overlap button This because 0 4 is a subset of 0 9 Use the Show button to check the result Then save 28 PC AXIS 2007 www scb se To create a classification based on a new value set To be able to create aggregations based on values not available in a
7. I Show Bold Vertical text Font size Bald Test length if limit Font size e SHOW per page Ma of data points if limit Picture 18 18 PC AXIS 2007 To coopy a graph Notice www scb se You can use the option copy in the graph window and insert the graph into another Windows program like MS Word and MS Excel Just click on this button Copy When arriving to the other program where the graph is supposed to be inserted use the paste special option using bitmap format If not using this a table will apear instead of the graph in the windows program Notice that some of the graph options need a certain structure of the table For example a population pyramid desires that the age variable is in the stub alone and the sex variable is as column heads If you are violating these rules PC Axis will tell you what is wrong for a certain type of graph When you have moved a diagram to Excel you must notice that it is just a picture which is not possible to adjust in Excel If you on the other hand transfer a table it is of course possible to continue to work on this table in Excel 19 PC AXIS 2007 To make a Map link www scb se PX Map presents the statistics as a thematic map Using the PX Map makes it possible to transfer your table information into a thematic map If you want a regional distributed table to be a map just click the globe icon in the toolbar All tables cannot be presented as maps If it is n
8. gt lt symbol6 gt lt symbol6 gt lt symbol7 gt lt symbol7 gt lt symbolnil gt lt symbolnil gt lt datapres gt lt pxquery step 1 gt function aggregation function files lt infile gt c database Befolkning BEO101A1oneyear px lt infile gt lt outfile gt C pxtemp tmp6 px lt outfile gt lt errorfile gt C pxtemp tmp6 err lt errorfile gt lt files gt lt keepdescription gt 1 lt keepdescription gt lt classcat gt C agereg A gereg2006 lt classcat gt lt variables gt lt noofvar gt 5 lt noofvar gt lt variable order 1 name region gt lt valuespecification gt text lt valuespecification gt lt values gt lt value order 1 gt lt value gt lt values gt lt variable gt lt variable order 2 name marital status lt valuespecification gt code lt valuespecification gt lt values gt lt value order 1 gt unm lt value gt lt value order 2 gt mar lt value gt lt value order 3 gt div lt value gt lt value order 4 gt wid lt value gt lt values gt lt variable gt lt variable order 3 name age gt lt valuespecification gt order lt valuespecification gt lt agereg gt C agereg Agereg2006 10 years age lt agereg gt lt values gt lt value order 1 gt 1 lt value gt lt value order 2 gt 2 lt value gt lt value order 3 gt 3 lt value gt lt value order 4 gt 4 lt value gt lt values gt lt variable gt lt variable order
9. is time to select values for the variables decide what the table shall contain CPC AxiszZ b5 Dababase Sweden Population Population statistics BED101A1 px X P 010141 Population Cancel OF lu nits number All nam Total na of celle 509184 eee ee eee Variable period Elimination not allowed region ale marita status 4 age 102 Long tests single O1 Stockholm county married ai Show hierarchy ij 0114 Upplands Vasby widowers widows 0115 Vallentuna divorced 0117 Osteraker 0120 Vv armdo 123 J rf lla CONI 2 RM Selected values CTRL mause men WDITIETI Click here to select all values If you desire all values in a variable you can click on the name bar for the very variable selection box As in sample on Picture 3 where all two values will be selected by clicking on the word sex If you only want some of the values just press the CTRL button at the same time as you click the left mouse button on the desired values Then only those selected will be put into the table Picture 3 If you wish to get all the variables and all their variable values just click on the button All All variables can be grouped into a classification if desired It shall be done before you select all variables with the AII button See Pictures 4 and 5 You can use the classifications if you have a table that is more detailed than you want it to be for exampl
10. statistics from Statistical agencies in a lot of organizations and countries For a complete list of PC Axis family members look at the PC Axis web site http www scb se Pages List 313990 aspx Overview of the PC Axis family software o eee centralbyran if Statistics Finland The PC Axis family software is leaning on the thesis of Professor Bo Sundgren on Output MetaPlus databases using many dimensional matrices also called cubicles or boxes MetaList These thoughts are implemented into the data model used in the Sweden s ao PX meta data PC Axis E models for macro and micro data PC AXIS PX Batch PX Publ xp 1 Statistical Databases and PX Make mw also in use in the databanks PX Edit of Denmark and Norway In the figure to the left are the programs that touches the ellipse related to the SQL database while those not touching the ellipse is only using the PC Axis file format PC Axis files can be produced by PC Axis SQL PX Batch PX Make PX RUD PMAR Af Edit From Finland and SuperCross PX Publ can produce tables direct into a MS Word or MS Excel documents Makrometa and Metalist are used for the maintenance of the metadata Metadok is software for entering metadata on registers for micro data 39 PC AXIS 2007 www scb se Contact persons lena gustafsson scb se and raitis sedlenieks scb se Tel 46 8 5069 4000 40 PC AXIS 2007
11. the same time Click on File Maintenance Copy move or delete a table within a subject matter area Select Copy Move or Delete in the dialog box Maintenance Select a subject area as Population and delete copy or move the tables Classifications Former mentioned classification will be elaborated and explained and you will see how useful the classifications can be The principle is that from a value set define a classification register that contains the desired summing The classification register then can be used on all files where the very variable classified is used One useful area is on the variable age where several different classifications can be established Another is on region where municipalities can be put together in larger areas forming special divisions of the country It is not a must to make classification registers it is possible use the sum function in PC Axis The advantage is the possibility to reuse the classifications To make a classification list takes some time but you gain from it every time you use it in the future 25 PC AXIS 2007 www scb se To create a classification based on an existing value set Open File Classification pay PC AXIS c cdrom2007 D atabaseXS5 weden Population Population statistics BEO_ Miel E3 EE Edit Calculate View window Help jaj x P Open Database trie tu Ta T ur ms JL y m ga p Import Ctrl l C A 1 Footnote ag 2 Close 3 Sa
12. 0160 T aby Clear all ow 0162 Danderyd D 0163 Sollentuna Open all D 0180 Stockholm E 0181 S dert lie Close all D 0182 Nacka 0183 Sundbyberg 0184 Solna E 0186 Liding E T10187 Vasholm PC AXIS 2007 www scb se If you select all the values the table will be presented with a hierarchical layout pay PC AXIS cAPC Axis2 006 Database Populations BEO101A1hier px File Edit Calculate View Window Help 00 Sweden 1 Stockholm county 0114 Upplands Vasby 0115 Vallentuna 0117 ster ker 0120 W rmda 0123 Jarfalla 0125 Ekera 0126 Huddinge n 27 Botkyrka 0128 Salem 0136 Haninge 138 Tyreso 133 Upplands Bro Single 2 431 699 517 611 10 288 tf 9679 9110 16 251 6 nah 24 128 20 084 3 756 13 833 11 O72 5815 Married 2004 Single 1544 702 2449038 296050 4522 028 B 26 10 335 4729 S60 6 808 9913 5 906 9 385 10 372 16 264 4 474 6 152 14 747 24 28b 13 40 20 104 2 606 3 783 11 73 18818 6 859 11 270 3 707 5 626 Married 2003 Single 1544045 2102531 297 649 469 747 B 24 3183 4 828 6 40 B B2 B 524 6 044 a 24 11 021 14 382 4 545 8 562 14 735 21619 13 507 17 581 261 3 504 11 783 17 574 B 812 10 007 3716 5 Den Married Single 1550010 2118301 297 076 473 644 6 348 9 228 4 759 B 546 6 802 832 5 812 B 477 11 08 14 266 4 43 5 652 14 324 21 768 13 475 17 553 2 625 351 11 808 17 542 69149 10143 3 743 5112 Married If you make a selec
13. 0550 9 1519 257671 245385 260267 246371 ET 284295 273273 264190 254366 307635 295894 301940 291726 335483 317154 324572 310024 298526 285308 318476 303389 233385 289038 298117 287357 315607 307753 236851 289163 WB 317461 327237 320973 3138621 A7 5558 240681 239471 290965 282921 307550 289748 18 6064 19805 207013 216354 220577 220989 225769 18 6569 185062 208276 180651 199095 181531 197748 20 7074 173941 208527 165337 198700 163932 196331 21 7579 145539 198381 147089 196351 143428 190150 22 6084 69625 144817 93575 147482 98479 153566 85 83 43804 89558 46165 33258 45648 33631 30 34 12374 34418 14105 38658 14658 33555 E Picture 7 Now you can click on the tool key with the icon of a star that gives the footnote information for this very table In this case latest up date source contact persons etc im Footnote oe When summing the mean population For instance into 10 year groups round sume may be accumulated This may cause somewhat high totals Mean population refers to the average value of for instance the number of 5 years old at the end of year n and the number of 5 lears old at the end of year n Since 1 January 1383 a new regional division has been established Parts of Sodertalle municipality cade 0181 have formed a new municipality called Mukvarn code 0140 Latest update 4002 02 27 09 57 Source Statistics Sweden Contack Ewa Eriksson SCE Tel 4619
14. 1 75743 If there is additional information available the icon showing a little book in the toolbar will be activated Press it and the book will lead you to additional documents concerning this very material It will be opened according what type of text file it is written PC AXIS 2007 www scb se If you have a table containing a hierarchy as in the case below in the variable region it will look like this c PC_Axis 006 Database Population BEO101 41 hier px pe 0141 Population OF Cancel Total no of cells 3884 Variable region Elimination value 00 Sweden Zoom region ele arital status 4 es 2 Long tests men 00 Sweden 01 Stockholm county 0114 Upplands Vasby 0115 Vallentuna 0117 Osteraker 0120 V armdo 0123 Jarfalla h Show hierarchy DIET widowers widows divorced Click on the button Show hierarchy and the following window will turn up where you can select freely from the values c PC_Axis 7006 Database Population BEO101A1hier px X BE010141 Population SE E C 00 Sweden x i A C 01 Stockholm county Eancel D 0114 Upplands W sby m D 0115 Vallentuna A 0117 ster ker 0120 vamda Aggregate oats 0123 J rf lla D 0125 Eker Zoom 0126 Huddinge D O12 Botkyrka Long texts L 0128 Salem 3 i H 0136 Haninge j D 0138 Tyres 0139 Upplands Bro select all 0140 Nykvarn C
15. 115 Vallentuna 5 la B Men 12 3 2 0 7 Women 17 3 1 0 14 a 1 q Men 26 g 2 1 1 10 omen eb 4 5 3 17 n 2 12 Men 15 13 13 Women 2 11 2 4 1 4 15 Men 20 4 1 16 16 Women 18 B 0 10 Continue choosing whatever editing and calculations you wish to do for instance pivot pay PC AXIS d databas sEesterBEO101F1xx px File Edit Calculate View Window Help OE B Ee m mum EAA x Obl m A GE nd es G 1 Migration by region age type period and sex DB 2000 2001 2002 li Men Women Men Women Men Women 4 0115 Vallentuna 5 n amp Inmigrated 12 17 10 q 13 14 Outmigrated 3 3 2 8 14 4 g Immigrants 2 1 j 1 1 e 9 Emigrants Y 0 D al Y 10 Excess of migration g 14 B 1 1 10 ETE Excess of Immigration e i 0 1 u 5 12 Internal inmigrated 10 15 10 al 12 g 13 Internal outmigrated 3 3 2 b 13 4 14 Internal excess of migration T 13 B 2 5 a 16 Inmigrated 26 26 oe 20 25 30 47 Outmigrated 9 9 14 i007 12 You can also select Save as 32 PC AXIS 2007 www scb se File Hame Directores E EQUO1F1 xx le d sdatabas DK ea databaz sd 1 batfiler TOUR Befolkning Mew folder Drives A os s File Format Lotus wk dB ase dbf dB ase Far Mapinto dbf PC ASIS file px Table tet E Fie Edit Calculate View Window Help g Open Database Ctri O Import Ctrl I Footnote Start recording bo save query
16. 16468 1422 1699 1447 1757 13 PC AXIS 2007 www scb se It is also possible to change the texts in the column headings and the stub Use Edit Change texts Here you mark the variables you want to modify the variable name and also variable values are possible to change Change Texts Contents Mean population Units Cancel number Variable region 5 uearclasses period IEN value ezte a Enter new text for variable p In the second part of the Edit menu options to combine the active table with another table is available Then the tables have to be similar Table with table can be used when data for additional periods shall be put together with the original table while Table on table is used if you have two tables with different contents as imports and exports Combination of tables also can be used in the software PX Edit 14 PC AXIS 2007 www scb se To do simple calculations using PC Axis There are some simple tasks able to carry out with the PC Axis calculation toolbox Let us study some samples Click on the pull down menu Calculate as showed on Picture 12 and you will find the different options pax PC AXIS c cdrom2002 D atabase S weden Population Population statisticsXBE 0160144 px Ele Edit REISE View window Help x ek deo xm TELE A T X uses O A MAS D E F G H I J n 1 Mean p Per 1000 yearclasses period and sex IE Add
17. 79 6597 BB 48 6658 X Bb 18 6r19 Picture 16 To use these functions click Edit and then Link with table Overlay with table See Picture 16 You will then be prompted what catalogue to pick up the second table from Be aware that you are only offered the tables that are possible to put together Select the table you want to have and click OK Then your table on the screen have got new values or variable If you are using Link with table it is a matter of adding a new time period When using Overlay with table it is because you have to similar tables possible to put together 17 PC AXIS 2007 www scb se To make graphs in PC Axis When you have a table in PC Axis it is possible to make a graph out from it It is possible to make different types of graphs like charts line diagram and population pyramids There is also possible to make thematic maps that will be showed later on If you want to make a graph please click on this icon lil and the picture below will turn up where you can select from different types of graphs Pann A ee ee ee ee ee ee ee Poe Picea Por etik ell Picture 17 If you press the button Adjust you will get some options to change in the graph nd Adjustments for graph Of x Background colour oray Show graph Title Ms Mean population by 5 pearclasses period region and sex M Show R Location Vertical text Ses let C Forti Font size je Legend Ans M Show
18. 8 52763 14658 39555 54213 24 95 19639 7514 9583 2264 39059 11323 2330 9558 11888 4 Press F1 for Help R 24 C 9 ZBPCA PC 1833 Astart KS Inbox a Utforsk F pcama HB namni ALDE Picture 12 5 year S 10 yea Let us try the percent calculation as is marked in the picture 12 above Then the following window pops up Select Base for Per cent Calculation E4 egion yearclasses 20 period E 00 Sweden 4 1337 OK 5 8 2000 2001 Cancel zoom Initial values included excluded f e mer women Picture 13 15 PC AXIS 2007 www scb se If we wish to calculate the ratio female and male compared to the total we select the total for the variable sex as the base for the operation Then you will be prompted a name of the new established value PC AaIS OK Enter name for new value K m cent Cancel Picture 14 PC Axis will automatically suggest the name Per cent you can change it if you wish and then click OK Now all the figures will turn up on the screen If you did not wish to have the initial values left in the table there is a possibility on the base selection window to tick according to your wishes See picture 15 Initial values included excluded Picture 15 16 PC AXIS 2007 www scb se Updating tables If you have a table that contains the population in sixteen municipali
19. If you let the mouse stay over a tool key in the toolbar a small yellow frame will tell the purpose of that very tool key pay PC AXIS File View Help Upen database If you need more help please use the tool key that opens the help function It is on the far right position in the toolbar This key is the way to get help for menus commands and how to work with PC Axis Press the Fl keyboard key to get context related help wherever you are in PC Axis Pay PC AXIS Ele View Help Ce te yr Merl ae gt LE ee te Hjdlpaysnitt Guide for PC AXIS Inneh ll Index Sok 1 Skriv in de f rsta bokstaverna pa ordet du soker efter _ TT 2 Markera onskat indexord och val Visa Active Database Add Calculate menu Add Data from another T able Add Table Calculate menu Add Additional information For hesmes CE Additions Advanced View menu Aggregate Values Aggregation List definition Aggregation List Alternate between Code and Text in a table Alternate between T ables PC AXIS 2007 www scb se A walk through of the toolbar y p Open a database Footnote s Select new values Save Print out c Undo Ey Copy m Pivot clockwise tu Pivot anti clockwise T Pivot any option Sum pl Percent T Per mille Add an Subtract sE Multiply Lu Divide More information m Graphs a Maps id Search help PC AXIS 2007 www scb se Open
20. NCTIONS IN PC AXIS crecer eee eee eene tenes tenet en ee eno eta 21 TABLE SME 2522522989235959232 9150552 4810232 362292 02 6011099220000350 00029210003992 00 992 00 08 0 00 359100 0005 24 CLASSIFICATIONS mc 25 TO CREATE A CLASSIFICATION BASED ON AN EXISTING VALUE SET eere 26 TO CREATE A CLASSIFICATION BASED ON A NEW VALUE SET eene 20 NAST TS WERON m qt 29 SAVED QUERIES IN PC AXIS MAIN MODULE ccccscccccccccccccccsssssssssssseeees 30 LIST ON ACTIONS THAT CAN BE RECORDED IN THE MAIN MODULE OF PCAN CPX OD m 35 PXO VU GS oases cers ace cece sce nccacccereeac DM E ND I PEE 35 ISTOR Wesco css 39 PC AXIS FOR DISSEMINATION OF STATISTICS FROM OTHER OG ANTS ONS uU 1 39 OVERVIEW OF THE PC AXIS FAMILY SOFTWARE eee ee eee eee eee eese 39 CONTACT PERSONS unaninun mnn Ti IURI Ii GLEN Lites eot 40 PC AXIS 2007 www scb se To install PC Axis PC Axis can be downloaded from the PC Axis website http www scb se Pages List 31405 1 aspx When PC Axis has been downloaded from the website follow the instructions in the installation program Some information on PC Axis and its help functions There a few things good to know before you start using PC Axis for the first time
21. YExempelFilerABED1 px i T 3 ci pacuments and Settings scbhlewelSkrivbord Exempelfiler BEOS px 46 4 cWietnam akb20111PC Axis mainmaduleYExercises Vc PILG px 30 Exit 21 22 Man 52815 Picture 8 Then a windows turns up where you can enter where to save the file and name the file Save To X To Database Convert File Hame Directories pem 0141 px co Database Location J Location Drives amp J c scblana Name Update subject area intable files with Subject Area Population selected folder Descriptions Save keys for data Save as DS a files Picture 9 11 PC AXIS 2007 www scb se If you would like to save the table in another file format you just select the tag Convert as in Picture 10 x File Name Directories BEDI CAT xls ca a c OK Cancel l New folder Drives amp J c scblana hi File Format No footnotes Mandatory footnotes dB ase for Mapinfo dbf Other footnotes PDAS file px T able t t o Al infomation Picture 10 In the listbox File Format you can save the table in any of the optional file formats In the tick boxes to the right you can decide what parts of the explaining information that shall accompany the table into the selected file format 12 PC AXIS 2007 www scb se To edit a table in PC Axis If you are not satisfied with the layout of the table there are some different things to be do
22. a database in PC Axis pay PC AXIS File View Help Open database Picture 1 When you are opening a table in PC Axis there are optional ways of doing it If the program is running you just press File Open Database or you can click on the button and you will find the catalogue that contains the current database or table On this picture you can see the PC Axis files all having the extension PX Drive fe Folders fr ables in c cd2003 D atabase S weden PopulationPopulation statistics Descipin Filename Date Size kB Population by region age period sex and marital status BEO101A1 px 2003 05 06 09 1367 Foreign citizens by region age period sex and marital status BEO101A2 p 2003 05 06 08 1107 Population growth by region age period sex and marital status BEDTOlA3 p 2003 05 06 08 1323 Mean population by region age period sex and marital status 2003 05 15 15 1368 Foreign citizens by country of citizenship period sex and age BEUIUTB2 px 2003 04 29 13 989 Foreign born persons by country of birth period sex and age BEO101B3 px 2003 04 29 13 113 Foreign born persons by region marital status age period Type BEOTO1B5 p 2003 05 06 08 2621 Live births by region period age of mother and sex BEO101D1 px 2003 05 06 08 108 Deaths by region age period and sex BEO101D3 px 2003 05 06 09 329 CI Agriculture forestry and fishe Population by regi
23. alogue Do it at the same places as where you shift database It is also possible to set a default catalogue in View Advanced Select Classification Directory and set the desired catalogue e DOMAIN is not corresponding between the PX file and the value set Open the PX file in Notepad and check if the name corresponds to the value set 29 PC AXIS 2007 www scb se BEF1_px WordPad Fil er Rediger Vis Inds t Formater Hj lp Miel Es olele el a Heel Sl 4 532 r 33 429 r 50 r 34 r 35 ar 51 ar 52 66 ar 67 ar 68 ar 69 33 r 84 r 85 r 86 VELUES TEIAS TISTI T TLT r i 36 r 53 ar 70 ar 87 ar 37 ar 54 ar 71 ar 88 ar 38 ar 39 ar 5S ar 56 alae Ae FL Oa E ar 89 ar 90 1973 1974 1975 1976 1977 1978 1979 1980 ar o ar ar 40 ar 57 ar 74 ar 91 ar 41 ar 58 ar 75 ar 92 ar 42 ar 59 ar 76 ar 93 ar 43 ar 60 ar 77 Ar ar 94 r IOBIT LOR 1991 1992 1993 1994 1995 1996 19977 1999 1999 r2000 2001 VALUES civilstand Ugifte Gifte og separerede Fraskilte Enker og enkemend CODES omr de 000 CODES kon 2 M E CODES Alder TOT ob U bas pu 2 s 3 ps dis AE MERE LA oer dr vs MER Tonn LETS zs a Has 12 n 13 ge pau TEATS 16 g i 83
24. art recording to save Stop recording of saved query Run saved Query Maintenance Database contents Classification Excel Internet Explorer CSV 1 d databasitester yx01 2002 03 px PC AXIS 2007 www scb se You will be prompted for a file name for the bat file that will be created for your selections i Start recording name batch file Saver ddatabas sbatfiler Sq EJ dS test bat EJ databas fe batfiler OK File name bat Ee eA TEE E Cancel File Format p atch bat T Mew fold Mew folder Next you select the PX file under Open database and the variables and values you want to have d databas tester BEO101F1lxx px EUTUTFT Migration lu nits number Total no of cells 854 Aggregate Variable region Elimination nat allowed Zoom region 4 age 4 es 2 Long texts men 0115 Yallentuna 0117 Osteraker 0120 Vv armmdo 0123 J rf lla E EC DIET Di Mi c3 000 Inmigrated 21 utmigrated EI Immigrants Emigrants Excess of migration Excess of Immigration Internal inmigrated 31 PC AXIS 2007 www scb se The table will be shown as usual PC AXIS di databas tester BEDT01FIxx px qEGOK d B 5o Bam m EA Xu ug esce mE F G 1 Higration by region age sex pernod and type 2 2000 3 Inmigrated Outmigrated Immigrants Emigrants Excess of migratian Excess of immigrat 4 0
25. b se When all selections are finished click OK and the table appears on the screen If there are very long texts on the variable values there is an option in PC Axis to get an alternative menu Just press the button Long texts and you get the picture 6b below instead a X c PC_Axis7006 Database Sweden Population Population statistics BEO101A1 px m 0141 Population OK Cancel Total no af cells 104832 HITS SD EN aS oe All for variable Variable see Elimination not allowed Aggregate Show hierarchy Let 5 year intervals Selected 21 of 21 period Selected 1 of 2 sex Selected 2 af 2 HOMEN w Use this layout as default Short texts Figure 6 b If you tick the option Use this layout as default the only way to alter back to the original layout can be done in the menu View Advanced the tag Information where you can tick the box Show value selection in layout with small list boxes If you immediately would like to turn back to narrow lists just click the button Short texts The table will appear similar in both cases PC AXIS 2007 www scb se Pr E PC AXIS c cdrom2002 D atabase S weden Population Population statisticssBE 0160144 px mp lg 4 Men Women Men Women Men Women S Sweden 00000000000 6 04 273910 251103 237667 225619 234563 202247 7 53 amsa 294914 306059 290905 292851 270807 8 1014 285499 250972 295241 27S768 306524 29
26. classification register you first have to import those values The value set is a file containing codes and texts for the values to be aggregated from For example 0 with the corresponding text 0 year The code 1 with the corresponding text 1 year and so on Value sets can be read into PC Axis from a comma separated file that could look like this 0 0 year 1 1 year 2 2 year It is also possible to import an existing value set a file with the extension VS to optionally correct it At most cases it is a PC Axis file one want to make aggregations for and then the PC Axis file can be used as input to get the value set To be able to use the aggregations one shall secure the consistency between the PC Axis files and the aggregations lists Domain is a keyword that can occur for any variable It refers to a class of values A list with all names of existing domains can be seen from the Classification program if the right current database is linked The name can also be found with the Domain keyword in the PX file This name is to be used when establishing a new value set When using the aggregation lists you shall secure the right classification catalogue is linked to PC Axis What is wrong If you after having created a classification register do not access to it when opening a table the reasons can be the following e The Current Classification catalogue does not contain the created classification register Shift classification cat
27. e in matriz format Bold Text Text Alignment W Title Left Stub Heading l l Data Cells t Right Heading Center v Max size for table shown on screen blas number of Ns Picture 23 Here you can set the number of lines you as a maximum want the table to use on the screen Remember that even if you cannot see the table on the screen you can work with the whole table Everything you do will affect the whole table It is easy to change the table layout If you do not want to have line numbers grid frames just enter the View menu omit or insert the different properties 24 PC AXIS 2007 www scb se pay PC AXIS c cdrom2007 D atabaseXS5 weden Population Population statistics BEO_ B m E3 we File Edit Calculate BE Window Help a x Skp g v Lebe 5 x Ol 2 w Status Bar n E E 1 Mean population v aiD UNE zs v ero Columns 2 pernod and sex is 3 wv land Lines E w Column Identities w How Numbers 00 Sweden Show T able Title Total Fonts IES O1 Stockholm counti Alignment Total Language k gE 0114 Upplands vast Graph Total Map 312 11 10115 Vallentuna Standard Total vw Advanced E 13 0117 ster ker 14 Total 17480 17281 v 4 E Press F1 for Help R 626 Es 2 Picture 24 Within the program it is possible to copy move or delete tables and subject matter areas When you are doing it in PC Axis you are sure that all references are deleted at
28. e one year classes or municipalities You can create your own age classifications or make your own areas based on the municipalities If you want to classify on variable age in the selected table it is in one year classes and you would prefer it to be five year classes On the picture where you select the variables there is a button named Aggregate Press it and it looks like Picture 4 You will find what is available for classification for this very table in this case the variables age and region We select age PC AXIS 2007 www scb se Select variable region Cancel di Picture 4 Press OK In next window you will find a list showing the different classifications available Select Aggregation List Variable nik age Cancel O pearclasses F vearclas SBS Picture 5 Select the 5 yearclasses and press on the OK button Then you will come back to Picture 3 but the list of ages has been changed to 5 yearclasses E 0141 Population Dk Cancel Total na of cells 104832 ene Aggregate Variable period Elimination nat allowed Zoom region ae marita status 4 e single a married Long tests an 01 Stockholm county Shaw hierarchy hebt dt 0114 Upplands Vasby widowers widows 0 5 0115 Vallentuna divorced 65 89 0117 Osteraker 90 94 0120 V armdo 95 99 in 0123 Jarfalla Picture 6 a 6 PC AXIS 2007 www sc
29. f you rename the output file in step 1 the input file in step2 automatically changes When a step is edited push update and the line in the window will be changed accordingly Repeat the selection and update for each line in the list When you have done so the button Save will be available m End recording and save queries a e ojx Click on the step you want to edit Step Function Saved guem Input file Em file sten selval d sdatabassbathiler stenitmp H databas stez ter BERTI Fl L WWIMMTS TMPT PX stepz pivotm d databas batfiler Step2tmp LNWINNTSETHMPT P D NWINNTSETMP3 FE step3 excel d databas batfiler Step3tmp CwAINNTSSTRHP3 E d databas BEUTUTF1 sx sls Update Saved query file d databas batiler Steplimp peq 00 Es Input File ddatabasteste BEDDI FI sepe 000000 Output File D WINNTIBIMPLER 000000000 Es Stop no save Time Options Cancel mI Bese You get a confirmation what has been created and you can run the job as often as you need by selecting run in PC Axis or by double clicking on the 34 PC AXIS 2007 www scb se bat file in Windows Explorer x The Following Files have been created d idatabasibatFiler Step1 sel px d idababasbatfilerStep2piv pxq d YdababasibatFilerStep3xls pxq d idatabastbatfFilerltesk1 bat List on actions that can be recorded in the Main Module of PC Axis PXQ Aggregations Calculations within a table C
30. hold thousand delimiters Use the menu View Advanced PC AXIS c Documents and Settings scblewe Skrivbord t xempelfiler BEO 2 px EE File Edit Calculate SES window Help E x S w Toolbar n B w Status Bar 1 Folkm ngd efter Options For Zero or Dok Rows 2 region och kon Peena DNE 3 anne w Column Identities wv Row Numbers 4 UU Riket Show Table Title z Man Fonts E Oar Sb328 Alignment 7 l r 55152 Language 8 2 55789 Graph g 3 r B3638 10 44 523670 standard 11 5 r 52819 y Advanced 12 6 ar 81271 13 ar 49360 46707 14 B r 493507 46412 15 ar 479370 45652 Picture 19 Where you select the tag Format for data cells x Close Select a format for presentation of data Apply Example ten thousand shown az C 10000 f 10000 C 10 000 C 710 000 21 PC AXIS 2007 www scb se Figure 20 Then mark the type of format for presentation of data you intend to use in the tables The selected option will work from the next table opened in PC Axis PC Axis optionally can be linked to another software Then it is possible to launge the other program from PC Axis moving the present table into that very program To make such a link use the menu View Advanced The installation program will automatically establish such a link to MS Excel if it is available on the computer In the new window select folders named More Features and then click on Change Additions Now use the folder Other progra
31. ms and the button me And you will find this window Additions E4 Add a program by entering a menu test and program with complete path Remove a program by removing the menu text Cancel Hh Browse 1 2 Menu text File type ee ae Fragram Menu text File type Excel 42 Program e Program Office2k OfficeSEXCEL 3 4 Menu text Menu text eee Frogram Frogram es 0 Picture 21 In the dialog box there are options to create links to four other programs To create such a link PC Axis needs the following information The name of the program is entered in the Menu text field If a amp sign is entered before a letter in the name this gives a key shortcut for that letter The program name will appear as a line in the File menu in PC Axis The file type for the program is entered in the field File type In the field Program the path and the name of the exe file has to be entered using Browse support If you cannot find the program search for it using the File explorer search function When you getting back to PC Axis you will find a line in the File menu named Excel 22 PC AXIS 2007 www scb se Pat PC AXIS c Documents and Settings scblewe Skrivbord txempelfiler BEO px e 3 4 5 b B J L L EA mim Edit Calculate View Window Help Open Database Import Footnote Close Save Save as Page layout Print p
32. ne to change it The Pivot function can be used to let the variables change places in the table Stub and heading can be switched according to your own needs Press this button REM which give you total freedom to move around with the variables You are using a drag and drop technique as showed on Picture 11 Change variable order Heading period OK TEs Cancel h yearclasses C Stub Heading Picture 11 When you are satisfied just press OK and the new table turns up This can be repeated so you will really be satisfied with your table You could also delete variable and values Pax PC AXIS c Wocuments and Settings scblewekrivbord txempelfiler BEO1 px Calculate View Window Help Undo Ctrl x Ol 2 ae Change variable order Elen G 1 F6 change value order in 2 Delete variable z002 3 Delete value ivinnor Marn kvinnor a rn Change texts 5 Change texts codes 3288 10922 3248 re re Change decimals E3E4 E272 E371 m 2216 1663 2263 B Linkwith table 1026 313 1042 g Overay with kable EE UO c n 6202 7069 E288 11 I Find F3 4708 4681 4711 12 8 Select Al Ctra 1233 8 1260 ul Select new values For the table e a 536 14 UT rre ma gifta 9756 r390 S308 a 9458 A404 ise Gifta 6575 6597 BB48 bBb8 6718 5719 37 Skilda 1355
33. on and period BE0101E1 px 2003 04 23 12 3 Lg Environment Migration by region age period sex and T ype BEOIO1F1 px 2003 05 06 03 2541 CJ Financial markets Population and population changes in Sweden by period and Ty BEO101G1 px 2003 04 23 13 1 2g BB Housing andconeiuction Population in smaller localities by region and period BEOT10152 px 2003 04 23 12 143 Ea Population by region and periad BEO101T1 px 2003 04 23 12 101 L National accounts Lg Population 1g Population forecast ty Population statistics i Cart Driana sn el eeerinen hows EE E c cd2003 D atabaseNS weden PopulationsPopulation statistics BE010144 px SN DK Cancel Change Classification Picture 2 To be able to use the Classification function see below you must set the right catalogue for the classifications belonging to the current database It can be changed using the button Change Classification See in Picture 2 When you are going to select a new table you either can click on it or mark it using the mouse and then press the ENTER key Let us say that you are interested in Population statistics press the subject Population select the sub catalogue Population statistics and then select the table named Mean population by region age period and sex See Picture 3 PC AXIS 2007 Select values to the table How to select all About classification of values www scb se Make a table in PC Axis Now it
34. onversion into dBase Excel Gesmes HTML Lotus text matrix PX ML PRN PX file Pivot clockwise anti clockwise and manual pivot Change value order The following actions are not allowed when recording in the Main Module of PC Axis If you try to use the following actions the recorded query will wrong The following could not be done Change texts codes Change texts Link with table and Overlay with table Calculations between tables Converting to a relational table PXQ XML files When a recording is done in PC Axis the user can decide whether to use the old ini file format or the new XML format The steps are recorded in separat temp XML files and when the user ends the recording and gives the file a name the parts are put together in one file which can look like this lt xml version 1 0 encoding 1s0 8859 1 T gt lt pxqueries version 1 0 gt lt language gt en lt language gt lt pxlangsuffix gt lt pxlangsuffix gt lt texts gt lt text id and gt and lt text gt lt text id by gt by lt text gt lt text id dist gt Distributed lt text gt lt text id unit gt unit variable lt text gt lt texts gt 39 PC AXIS 2007 www scb se lt datapres gt lt rounding gt 0 lt rounding gt lt secrecy gt 0 lt secrecy gt lt symbol1 gt lt symbol1 gt lt symbol2 gt lt symbol2 gt lt symbol3 gt lt symbol3 gt lt symbol4 gt lt symbol4 gt lt symbol5 gt lt symbol5
35. ot possible the icon is non collared This is how a thematic map in PX Map looks like PxX Map Mean population by region age period and sex BEOTOTAA File Edit Navigation Show Thematic map Help SHaS B Q2Q O 8S P 373 4 523 4650 6 432 6 495 10 553 10 554 18 571 18 572 362 401 MOMeEr Agestotal Period 2001 fi If you retrieve a table from the Sweden s Statistical databases there is not yet made any link to Maps If you insist to make a map from a table retrieved from Sweden s Statistical Database on the Internet download the table in PC Axis file format to your computer and save it Then you open the file in a text editor like MS Word Search for a section looking like this TITLE Mean population by region age period and sex CONTENTS Mean population UNITS number STUB region age HEADING period sex MAP region Sweden_municipality Insert the line MAP region Sweden_municipality You have to insert this line after STUB and HEADING which is in the beginning of the file 20 PC AXIS 2007 www scb se When you save the file again be aware of that MS Word tries to change the extension of the file when saving in another file format than doc Save in txt format and change the extension to PX it is possible to find the file from PC Axis and make a map in PX Map About advanced functions in PC Axis The presentation of figures in the table cells can optionally
36. review Print Start recording to save query Run saved query Maintenance Database contents Classification Excel 1 ciDacuments and Settings scbhlewel Skrivbord ExenpelFiler BEO px z c Documents and Settings schlewelSkrivbord ExempelFiler BEO1 px 3 ci Documents and Settings schlewelSkrivbord ExempelFiler BEOS px 4c Wietnam okke01 1PC 4xis_mainmodule Exercises CPILG px Exit 16 r 66175 B2322 1 r 67953 63608 18 r bB411 64637 13 r b4B43 61280 Picture 22 Chrl o Ctrl I 9 Ctrl 5 Ctrl P When you click on the Excel line PC Axis automatically will pass the table on into Excel In Excel the table will be put in a new sheet and footnotes will appear below the table in Excel PC AXIS 2007 23 To change the table layout www scb se Table size Another thing to be happy about concerning PC Axis is the capacity to handle tables consisting of millions of table cells One more thing that makes you glad is that you do not have to watch all these table cells on the screen The more table cells you show on the screen the longer it will take to make operations on the table Furthermore it uses more RAM So it is possible to reduce the number of table lines to be exposed on the screen Click on View Advanced and select a tag called Table Presentation x Close V Show Grid lines Show Column Headers A Z Show Line Numbers Show table title Apply Tabl
37. s an aggregation file are always referred to by their order in the aggregation list If a Valuespecification tag is used it must have the value order for that variable but the tag is not needed In the above example for variable Region the value is stated as value order 1 gt lt value gt This means that all existing values for this variable are to be used in the px file This expressions is not created in PC Axis but if the pxq xml file is edited elsewhere it is possible to define that all values should be included This means that if the px file is updated with a new region the saved query need not be changed to include the new value If the selection is followed by further steps make sure that the editing or calculations in these steps can still be done after a change of values in the original PX file The functions supported are Function Description selection Select variables and values aggregation Select aggregations and variables and values 3 PC AXIS 2007 www scb se pivotmanual pivotauto valueorder vardelete chgtextcontents textcode decimals splitquarters splitmonths calculation filecalculation excel asp XMLCI XMLC2 XMLC3 text dbasel dbase2 dbase3 dbase4 graph matrix lotus html1 html2 prnmatrix prntable reltable pxfile Change variable order manual Change variable order auto Change value order Delete a variable Change text for contents Change between text and code presen
38. tation Change number of decimals whole table only Split time variable when quarters Split time variable when months Operations remove remove values sum sum values for a variable percent per cent permille per 1000 add add 2 values subtract subtract one value from another multiply multiply 2 values divide divide one value with another Calculations involving 2 files tables Save as Excel Save as asp Save as PXML xdf Save as PXML keys Save as PXML cals Save as text file Save as dBase 1 Save as dBase 2 Save as dBase 3 Save as dBase 4 Save as graph file Save as matrix file Save as Lotus wk1 file Save as html 1 no table tag Save as html 2 with table tag Save as delimited matrix Save as delimited table Save as relational table Save as px file Updated 2008 01 17 38 PC AXIS 2007 www scb se History PC Axis was developed for the 1990 Population Census in Sweden The software has been further developed in the framework of the International PC Axis Reference Group For instance a Windows version 1995 an Internet version of PC Axis named PX Web is available and in use since 2000 In Statistics Denmark and Statistics Finland software to create PC Axis files named PX Make and PX Edit respectively has been developed Statistics Norway has made a map software named PX Map PC Axis for dissemination of Statistics from other organisations The PC Axis family products are used for dissemination of
39. ties distributed on age sex and time 1995 2000 and the figures for 2001 has become published it is possible to update with the new figures instead of download the whole table again from Sweden s statistical databases on Internet You just link a table to another table adding new values It is also possible to overlay a table with another table adding a new variable for example if immigration and emigration are retrieved from two separate tables they can be put together in a very large table using this function Please notice when using these two functions the tables have to be very similar So if something is changed in one of the tables the other has to be changed in exactly the same manner to fit in together Pat PC AXIS c Wocuments and Settings scblewe Skrivbord txempelfiler GEO1 px Calculate View Window Help Unda Ctrl 2 x X fll amp Change variable order E F E 1 F change value order n z Delete variable 2002 3 Delete value vinnar Man Kvinnor 4 01 Change texts Bm Change texts codes 3298 10322 9249 EE d Change decimals E364 E272 632 7 5 Split time variable XME 1EE3 22E3 a Link with table 1026 313 1042 g p Overlay with table EN c uw 6202 7069 6289 11 G Find F3 4708 X 4581 4711 12 5 Select All CEri 1233 946 1260 13 4 731 zM 736 Select new values For the Eable 14 01 Ir DA IAT 7 0 g 15 Udita 3155 FSan 9308 B4 9 3458 B4n4 16 Gitta 65
40. tion from the region variable the hierarchical layout will disappear pay PC AXIS c PC Axisz b5 Database Population BEO101A Lhier px Eie Edit Calculate View Window Help Mer 2003 Single 00 Sweden 01 Stockholm county 0114 Upplands v asby 10 2 431 699 517 611 10 288 Married 1544 702 2448138 296 050 6 267 4 728 2004 Single 522 026 10 336 360 Married 1544046 2102531 297 649 B 247 4 828 Women 2003 Single 465 747 3183 b 407 Married 1550010 2119301 297 BB 6 346 4 753 2004 Single 473 644 3 228 Married 1 543 669 PC AXIS 2007 www scb se To save a table When you are satisfied with the layout of the table you can save it on your hard disc or a server Use the pull down menu File Save as Pay PC AXIS c Documents and Settings scblewe Skrivbor d Exempelfiler BEO 2 px NE Edit Calculate View Window Help Open Database Chril 0 T Import Ctrl I EE Footnote 2 Close 3 Save Ckri4 5 4 Save as o Page layout B Print preview Print Ctrl P 5 Start recording to save query I T Run saved query if z Maintenance l Database contents 1 Classification 1 T Excel TE 1cDaocuments and Settings scblewelSkrivbord Exempelfiler BEO2 px 2c Documents and SettingsscbleweVMSkrivbord
41. ve Ctrl S 4 Save as women Page layout b Print previews IbU 4435353 5 Print Ctrl P B BOSD 3343938 Maintenance d Database contents Bb4L 18312 ch Classification L 1 Excel 1 PoS 12752 14 Exit 14 Total 17480 1729 4 ko Press F1 for Help R 626 Es 2 Picture 25 Select among the value sets available in the listbox For example ALDER1 or use Browse if you want to change to another classification catalogue Classifications Welcome to the Classification Guide Select a Valueset or Enter a New Mame Browse ALDER Langs L ng Lange Regionk H2 FiegionE S5 Current c edrom0lA Classifications S weden Directory Continue End Picture 26 26 PC AXIS 2007 www scb se Press Continue Classifications V alueset Type hv 2 4 H b H B 4 i ce Total 0 Domain Back End Picture 27 To avoid manual data entry you can use the option Read from file and you will find a window with already existing value sets Head from file File Mame E ecrom 002Classifications S wedeni File type Upen C Delimited file Cancel V5 file C PE Asis File dd file Picture 28 Now the page will be filled with values from the selected value set text and codes for example ALDERI the name of the domain and the type of value set V Value set of normal structure H

PC-Axis 2008

Contents

Download Pdf Manuals

Related Search

Related Contents