PC-Axis User Manual
Contents
1. EA Edit Calculate View Window Help la x g OpenDatabase CO l r A x PE Mae me Import Ctrl I T G 1 Footnote yearclasses period 2 Close 3 Save Ctrl 5 2000 2001 4 en Women Men Women 5 Page layout Essen 237667 225619 234563 222247 7 Print Ctrl P 306059 290905 292851 278807 8 Fe 295241 279768 306524 290550 E 3 Database contents 260267 246371 264295 249528 Herr 264190 254366 262816 253373 mm 9 301940 291726 298385 288161 re 324572 310024 318075 305392 ag Exit 318476 303389 328930 312662 44 40 44 299385 289038 298117 287357 297255 286645 15 45 49 315607 307753 296851 289163 296215 288383 16 50 54 328290 317461 327237 320973 319216 313621 Fr 55 59 242681 239471 290365 282921 307550 299748 18 60 64 198051 207013 216354 220577 222999 225789 19 65 69 185062 208276 180651 199095 181531 197748 20 70 74 173941 209527 165337 198700 163932 196331 21 75 79 145539 196381 147089 196361 143428 190150 22 80 84 89625 144817 93575 147482 98479 153568 23 85 89 43804 89558 46165 93258 46648 93631 24 90 94 12374 34419 14105 38658 14658 39555 z 4 Ef Press F1 for Help R 25 ICG A Start Inbox By Utforsk F pcama Z namni ALDE 2 10 yea 25 PC A Cle dd 18 02 Picture 8 Then a windows turns up where you can enter where to save the file and name the file Save To EJ To Databaze Convert File Name Directore2. 95 20 55 79 45 100 00 19 99 80 01 100 00 19 60 80 40 100 00 4 EEE b E Press F1 for Help R 24 C 9 A Start Inbox Microsoft Du DN Utforskar C edro pcaman2002e doc Ezi namnlos Paint Zu PC AXIS c c ws 18 53 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 14 PC AXIS 2003 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 m and the picture below will turn up where you can select from different types of graphs PAY PC AXIS Graph ET PC AXIS Graph Tal ily Eile Edt Calculate View Window Help l x Bkh ESR RRE E A x 0A Mean population by 5 yearclasses period region and sex Close
3. Statistics Sweden Statistiska centralbyran www scb se PC Axis 2003 Users Manual PC Axis 2003 huvudmodul inklusive funktion for att skapa egna indelningar News in PC Axis 2003 wee The most important news in PC Axis 2003 ed The table cells can get a thousand delimiter Optional menu for long texts in variable values link between PC Axis and Excel is automatically established when installing PC ia function to produce HTML list of contenst for a PC Axis database List of contents TS OO COIN DI T oora N AA 1 SOME INFORMATION ON PC AXIS AND ITS HELPFUNCTIONS cccee0s 2 WALK THROUGH OF THE TOOLBAR essssssssssssssssssssssssssssssssssssssssssssssssnsssssssssssssssssnssnssssnssse 3 OPEN A DATABASE NPD ve 4 MAKE A TABLE NTN 4 TOSAMEA TM vvs NG 9 TO EDIT A TABLE IN PC AX IS saadan 11 TO DO SIMPLE CALCULATIONS USING PC AXIS eseeeesssessevvennnssrseennnssesesnnnnseneeeee 12 UPDATING TABLES hr AE EENE 14 TO MAKE GRAPHS IN PC AXIS ag 15 PX MAP PRESENTS THE STATISTICS AS A THEMATIC MAP 00 eee 17 ABOUT ADVANCED FUNCTIONS IN PC AXIS eesssececcssececcsseccccsececcosececcssececcsseeeesoe 18 EA SUZ D EE EEE EEA 21 CLASSIFICA TONS unde 23 TO CREATE A CLASSIFICATION BASED ON AN EXISTING VALUE SET cessccesseeesseeesseeenees 23 TO CREATE A CLASSIFICTAION BASED ON A NEW VALUE SET csessseesseeesseeeseeesseeesseeesees 26 VNR ochre tact been cesc oem E bee pha cone ea E done
4. nges ade ae 2 m 3 nam non ng Lu ad nar 10 rit 12 mo i13 igr 15 i 3 45 46 ar MLE di te MA wag re Jodl a glir MLE 52 PG 53 ne gt TEET ee ii METT See mogn non 53 mo 34 95 RS nr 87 58 ggr ag 91 g2 ne g3 We nag ngge 96 ad BF gg rgg r CODES civilstand Ne UG GI SK EN PRESTEXT tid 0 DOMAIN omr de VPOMRADE DOMAIN ken VPKeN DOMAIN alder VPALI DOMAIN civilstand ELIMINATION omr de ELIMINATION alder DECIMALS 0 rr arr R VP GTSTIL Hele landet ilder i alt LAST OPPspeT 10990621 00 00 STOCKFA F SOURCE Danmarks Statistik CONTACT Thomas Norup DS Per O1l telefon 39173308 fax e post TNORDST DKHX400 Lar s Pedersen DS Bru 16fftelefon 39173158 fax e post LAPADST DK X400 COPYRIGHT YES DATABASE SUM Databasen REFPERIOD 3 BASEPERIOD of 4 Tryk p F1 for at f hj lp INUM Picture30 21 PC AXIS 2003 www scb se History PC Axis was developed for the 1990 Population Census inn Sweden The software has been further developed in the framework of the International PC Axis Reference Group For instance a Windows version 1995 that has become a help application to the Sweden s Statistical Databases on Internet An Internet version of PC Axis named PX Web is available and in use since 2000 In Statistics Denmark a software to create PC Axis
5. 12001 00 Sweden men i GGG 2001 00 Sweden women Print Copy Save as 2D 3D Line Chart Bar Chart Horizontal Bar Stacked Horizontal Bar 300000 200000 100000 0 100000 200000 300000 Press F1 for Help R 26 C 2 H Start K Inbox Microsoft Du AJ Utforskar C edro pcaman2002e doc RF namnl s Paint a PC AXIS Graph OS 19 02 Picture 17 If you press the button Adjust you will get some options to change in the graph oe Adjustments for graph Of x Background colour oray v Show graph Title Asle Mean population by 5 yearclasses period region and sex MW Show ek Location P Vertical text peace Font size E Legend Ans W Show I Show Bold Vertical text Font size T Bold Test length If limit Font size E Show per page Mo of data points if limit Picture 18 15 PC AXIS 2003 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 th
6. 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 statistics BE0101A4_ px gt File Edit SIRES View window Help x B k e Sum FE 24 x 0m 7 a Mit D E F G H I a 1 Mean p Per 1000 yearclasses period and sex Add 2000 2001 eae Subtract Total Men Women Total Men Women Total 4 DOSwed Multiply Bjo4 Divide 535013 237667 225619 463286 234563 222247 456810 6 15 9 Add table 606462 306059 290905 596964 292851 278807 571658 7 10 14 Subtract table 516471 295241 279768 575009 306524 290550 597074 g 15 19 Multiply table 503056 260267 246371 506638 264295 249528 513823 9 20 24 Divide table 557568 264190 254366 518556 262816 253373 516189 M n 25 29 307635 295894 603529 301940 291726 593666 298385 288161 586546 11 30 34 335493 317154 652647 324572 310024 634596 318075 305392 623467 12 35 39 298526 285308 583834 318476 303389 621865 328930 312662 641592 13 40 44 299385 289038 588423 298117 287357 585474 297255 286645 583900 14 45 49 315607 307753 623360 296851 289163 586014 296215 288383 584598 15 50 54 328290 317461 645751 327237 320973 648210 319216 313621 632837 1946 55 59 242681 239471 482152 290365 282921 573286 307550 299748 607298 17 60 54 198051
7. files named PX Make 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 statistics from statistical agencies in the following countries Algeria Basque country Bolivia Brazil Denmark Estonia The Philippines Finland Faeroe Islands Greenland Ireland Iceland Croatia Kuwait Lithuania Latvia Norway Slovenia Spain South Africa and Uganda Furthermore PC Axis is used by UN ECE East Africa Commission Kenya Tanzania Uganda In Sweden PC Axis is used outside Statistics Sweden by Integrationsverket Sverige Folkhalsoinstitut Falk pings kommun Halmstads kommun Link pings kommun T by kommun V stra G talandsregionen rebro kommun Overview of the PC Axis family software The PC Axis family i 3 r software is leaning on the The Nordic concept for dissemination of MG statistics on the Internet Sundgren on Output pp N databases using many dimensional matrices also Makrometa MetaDok called cubicles or boxes These thoughts are MacroData implemented into the data Statistics Sweden MetaL ist model used in the PC Axis SQL meta data models Mit de ei Data poani formado and ases and also in use in ar ou the databanks of Denmark PX Batch mode PX Publ Hi and Norway In the figure batini to the left are the programs PX Make pr that touches the ell
8. 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 Options for Advanced Heading Data Cells 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 effect the whole table It is easy to change the table layout If you do not want to have line numbers gridframes just enter the View menu omit or insert the different properties 21 PC AXIS 2003 iy PC AXIS cAcdrom2002D atabaze S weden Population Population statistics BED p pe Xb Hg mr Hean population period and sex an 00 Sweden Total eo 01 Stockholm count 8 Total EN 0114 Upplande v st pu Total EE 0115 Vallentuna he Total STROM Bsteraker O O Total 17480 17291 Picture 24 i ig hy Ti T ou LEI LEI ETT 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 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
9. the result Then save To create a classifictaion based on a new value set To be able to create aggregations based on values not available in a classification register you first have to import that 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 commaseparated file which 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 open
10. 207013 405064 216354 220577 436931 222999 225789 448788 18 65 69 185062 208276 393338 180651 199095 379746 181531 197748 379279 19 70 74 173941 209527 383468 165337 198700 364037 163932 196331 360263 20 75 79 145539 196381 341920 147089 196361 343450 143428 190150 333578 21 80 84 89625 144817 234442 93575 147482 241057 98479 153568 252047 22 85 89 43804 899558 133362 46165 93258 139423 46648 93631 140279 23 90 94 12374 34419 46793 14105 38658 52763 14658 39555 54213 24 95 1969 7614 9583 2264 9059 11323 2330 9558 11888 4 l E ENE b E Press F1 for Help R 24 C 9 SR start KO Inbox ay Utforsk f pcama Z namni ALDE 2 5 year E 10 yea Zu PC A Cor 18 33 Picture 12 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 fregion fi yearclasses 20 period 3 00 Sweden U 4 a 1997 OK 5 9 2000 2001 Cancel oom Initial values fr included excluded Picture 13 12 PC AXIS 2003 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 Pec cel 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 fi
11. 26 MS Yaar cessed A A EE 28 PC AXIS FOR DISSEMINATION OF STATISTICS FROM OTHER ORGANISATION Sisiane irinin an OR Er aa aA E a OEE a E RAAE a a r 28 OVERVIEW OF THE PC AXIS FAMILY SOFTWARE eesseeeecssseeccssececcssccccssececcoseeeee 28 CONTACT PERSON srira E ET AE E E 28 PC AXIS 2003 www scb se Some information on PC Axis and its helpfunctions There a few things good to know before you start using PC Axis for the first time If you let the mouse stay over a toolkey in the toolbar a small yellow frame will tell the purpose of that very toolkey Pit PC AXIS ale vier ak z a EE Open database If you need more help please use the toolkey that opens the help function It is on the farest 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 F1 keyboardkey to get context related help where ever you are in PC Axis pay PC AXIS File View Help r eer Gel Se EN Hj lpavsnitt Guide for PC AXIS Inneh ll Index Sik 1 Skriv in de f rsta bokst verna p ordet du soker efter RR 2 Markera onskat indexord och valj Visa Active Database Add Calculate menu Add Data from another Table Add Table Calculate menu Add Additional information for Gesmes CB Additions Advanced lew menu Aggregate Values Aggregation List definition Aggregation List Aggregation Lists Alignment lew menu Alternate between
12. Code and Test in table Alternate between Tables PC AXIS 2003 www scb se A walk through of the toolbar Ta Open a database i Footnote Select new values mj Save E Print out r d Undo Ea Copy ot Pivot clockwise tg Pivot anti clockwise t4 Pivot any option T Sum r Percent pet Per mille Add com Subtract Hd Multiply Divide More information Graphs Maps Search help El H PC AXIS 2003 www scb se Open 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 which contains the current database or table On this picture you can see the PC Axis files all having the extension PX Drive Sc v fan Folders fr ables in c cd2003 D atabase S weden Population Population statistics Description Filename I Population by region age period sex and marital status BEO10141 px 2003 05 06 09 1367 Foreign citizens by region age period sex and marital status BE010142 px 2003 05 06 09 1107 Population growth by region age period sex and marital status BEO010143 px 2003 05 06 09 1323 Mean population by region age period sex and marital status 2003 05 15 15 1368 Foreign citizens by country of citizenship period s
13. R wh Press F1 for Help A Start Inbox N Utforsk pcama Ezi namn Picture 7 Now you can click on the tool key with the icon of a star which gives the footnote information for this very table In this case latest up date source contact persons etc PC AXIS 2003 www scb se w Footnote 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 A vears old at the end of year n and the number of 6 years old at the end of wear n 1 Since I January 1999 a new regional division has been established Parts of Sodertalje municipality code 0181 have formed new municipality called Nykvarn code 0140 Latest update 2002 02 27 09 57 Source Statistics Sweden Contact Ewa Erikszzon SCB Tel 4619176743 If there are 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 textfile it is written PC AXIS 2003 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 pulldown menu File Save as pax PC AXIS c cdrom2002 D atabase S weden Population Population statistics BE0101A4_ px
14. 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 listboxes The table will appear similar in both cases pax PC AXIS c cdrom2002 D atabase S weden Population Population statistics BE0101A4 px Eile Edit Calculate View Window Help x sax Barn Ble REl A x 0e B B D F Mean population by region 5 yearclasses period and sex 1997 2000 2001 Men Women Men Women Men Women 00 Sweden 0 4 273910 261103 237667 225619 234563 222247 5 9 311548 294914 306059 290905 292851 278807 10 14 265499 250972 295241 279768 306524 290550 15 19 257671 245385 260267 246371 264295 249528 20 24 284295 273273 264190 254366 262816 253373 25 29 307635 295894 301940 291726 298385 288161 30 34 335493 317154 324572 310024 318075 305392 35 39 298526 285308 318476 303389 328930 312662 40 44 299385 289038 298117 287357 297255 286645 45 49 315607 307753 296851 289163 296215 288383 50 54 328290 317461 327237 320973 319216 313621 55 59 242681 239471 290365 282921 307550 299748 60 64 198051 207013 216354 220577 222999 225789 65 69 185062 208276 180651 199095 181531 197748 70 74 173941 209527 165337 198700 163932 196331 75 79 145539 196381 147089 196361 143428 190150 80 84 89625 144817 93575 147482 98479 153568 85 89 43804 89558 46165 93258 46648 93631 90 94 12374 34419 14105 38658 14658 39555 wo coO MIMI
15. at 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 16 PC AXIS 2003 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 are using the CD ROM Statistics Across the Borders and want a regional distributed table to be a map just click the globe icon in the toolbar All tables can not be presented as maps If it is not possible the icon is non collored This is how a thematic map in PX Map looks like P Map Mean population by region age period and sex BE010144 File Edit Navigation Show Thematic map Help HBDS ng 89 0 936 8 1379 4629 4630 6 432 E 493 10553 10554 19571 18 572 362 401 MOMEeN Age total Period 2001 EE If you retrieve a table from the Sweden s Statistical databases there is not yet made any link to Maps If you insists to make a map from a table retreived from Sweden s Statisitcal Database on the Internet download the table in PC Axis file format to your computer and save it Then you open
16. box Maintenance Select a subject area as Population and delete copy or move the tables 22 PC AXIS 2003 www scb se 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 summings The classification register then can be used on all files where the very variable classified is used One usefull 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 It is obviously possible to make your own classification if the ones delivered from the statistical office on CD ROM or on Internet is not exactly the one you want to use To make a classification list takes some time but you gain from it every time you use it in the future To create a classification based on an existing value set Open File Classification pay PC AXIS F c cdrom20074D atabase S weden Population Population statistics BEO_ Miel E4 md AES Edit Calculate View Window Help a x go Open Database Ctrl 0 43 T Import Ctrl Footnote Clos
17. e Save Ctrl 5 Save as Page layout Print preview Print Ctrl P Maintenance ml l bod Off RGI bay Database contents l Classification l no 17480 Picture 25 Select among the valuesets available in the listbox For example ALDER or use Browse if you want to change to another classification catalogue If the value set is on a read only medium as a CD ROM you have to copy it into your hard disc or a server and change property to not read only status 23 PC AXIS 2003 www scb se Classifications Welcome to the Classification Guide Select a Valueset or Enter a New Mame Browse Regionk 95 Current c cedrom2002 Classitications S weden Directory Continue End Picture 26 Press Continue Classifications Valueset Type y O 20 m OT F I Find Domaine 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 allready existing value sets 24 PC AXIS 2003 www scb se Read from file File Name c edrom2O02Classifications 5 wedent File type e C Delimited file eh amp te VS file CO PC Asis File Add file Picture 28 Now the page will be filled with values from the selected value set text and codes for example ALDER1 the name of the domain and the type of value se
18. esired values Then only those selected will be put into the table 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 AlI button See Pictureers 4 and 5 You can use the classifications if you have a table which is more detailed than you want it to be For example 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 avialable for classification for this very table in this case the variables age and region We select age Select variable reglar DE Cancel Picture 4 PC AXIS 2003 www scb se Press OK In next window you will find a list showing the different classifications available Select Aggregation List variable nk age 10 vearclasses H nearclasser Cancel 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 ccd2003 Database Sweden Population Populatio
19. ex and age BETEZ 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 BEO101B5 px 2003 05 06 09 2621 Live births by region period age of mother and sex BEO101D1 px 2003 05 06 09 108 Deaths by region age period and sex BEO101D3 px 2003 05 06 09 329 CI Agriculture forestry and fishe Population by region and period BEO101E1 px 2003 04 29 12 3 CJ Environment Migration by region age period sex and Type BE0101F1 px 2003 05 06 09 2541 CJ Financial markets Population and population changes in Sweden by period and Ty BEO101G1 px 2003 04 29 13 17 S Ga Housing and construction Population in smaller localities by region and period BEO101S2 px 2003 04 29 12 143 Population by region and period BEO101T1 px 2003 04 29 12 101 2 National accounts E C Population 03 Population forecast 3 Population statistics Ea Diana aus mans biene er c cd2003 D atabase S wedenPopulation Population statistics VBE010144 px OK Picture 2 Change Classification 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 on Picture 2 When you are going to select a new table you either can click on it or
20. gures 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 Picture 15 Change texts in the table 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 number region A Yearclasses period ZEM WAWE ERE 13 PC AXIS 2003 www scb se Updating tables If you have a table that contains the population in sixteen municipalities 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 imigration 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 pax PC AXIS c cdrom2002 D atabase S weden Population Population stat
21. ing a table the reasons can be the following e The Current Classification catalogue does not contain the created classification register Shift classification catalogue 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 26 PC AXIS 2003 www scb se BEF1 px WordPad Torx Filer Rediger Vis Inds t Formater Hj lp oea S a el 32 r 33 r 34 r 35 r 36 r r37 r 38 r 39 r rag r 41 r 42 r 43 r 49 r 50 r 51 r 52 r 53 r 54 r 55 r 56 Oc S57 r 58 r 59 Ac 60 r 66 r 67 ar 68 r 69 r 70 ar RERI r 72 r rere ar 74 r 75 r 76 r w77 ar 83 r 84 ar 85 r 86 r 87 r 88 r 89 ar 90 r 91 r 92 r 93 r 94 ar VALUES tid 1971 1972 1973 1974 1975 1976 419977 1978 1979 1980 1981 190 1991 1992 re 1993 RE 1994 m rr 1995 1996 1997 a rr 1998 1999 2000 ee OO TA VALUES civilstand Ugifte Gifte og separerede Fraskilte Enker og enkem nd CODES omr de 000 CODES k n y EE CODES alder TOT
22. ipse re PX Edit lated to the SQL database while those not touching SuperCross the ellipse is only using ER the PC Axis file format Z0 PX Web PC Axis files can be ae P DRN produced by PC Axis PAX WaN SQL PX Batch PX Make PX Edit From Fin land and SuperCross PX Publ can produce tables Meta driven databases and publication production for Internet direct into a MS Word or MS Excel documents Ma ad Statistisk sentralbyr DENMARK PP krometa and Metalist are used for the maintenance of the metadata Metadok is software for entering metadata on registers for micro data Contact person Lars Nordb ck e mail lars nordback scb se and telephone 46 8 5069 4095 28 PC AXIS 2003
23. istics BE0101A4_ px me File Calculate View Window Help 8 x Undo MZ U X Ol 2 Delete value FEAR ee 1M Change variable order eriod and sex 2 Change value order 2001 3 Change texts omen Total Men Women Total 4 00 Change texts codes 5 0 Change decimals 48 70 100 00 51 35 4865 100 00 6 Link with table 48 73 100 00 51 23 48 77 100 00 a 1 Overlay with table 48 65 100 00 51 34 48 66 100 00 8 1 Er Che 48 63 100 00 51 44 48 56 100 00 g 2 Fed F3 49 05 100 00 50 91 49 09 100 00 10 2 SelectAll Crea 49 14 100 00 50 87 4913 100 00 Wy 30 48 85 100 00 51 02 48 98 100 00 12 3 Select new values for the table 4879 100 00 5127 4873 10000 13 40 44 50 88 4912 100 00 50 92 49 08 100 00 50 91 49 09 100 00 14 45 49 50 63 49 37 100 00 50 66 49 34 100 00 50 67 49 33 100 00 15 50 54 50 84 49 16 100 00 50 48 4952 100 00 50 44 49 56 100 00 16 55 59 50 33 4967 100 00 50 65 49 35 100 00 50 64 49 36 100 00 17 60 64 48 89 5111 100 00 4952 50 48 100 00 4969 50 31 100 00 18 65 69 47 05 5295 100 00 47 57 5243 100 00 47 86 5214 100 00 19 70 74 45 36 5464 100 00 45 42 5458 100 00 45 50 54 50 100 00 20 75 79 42 57 57 43 100 00 42 83 57 17 100 00 43 00 57 00 100 00 21 80 84 38 23 61 77 100 00 38 82 61 18 100 00 39 07 60 93 100 00 22 85 89 32 85 67 15 100 00 33 11 66 89 100 00 33 25 66 75 100 00 23 90 94 26 44 73 56 100 00 26 73 73 27 100 00 27 04 72 96 100 00 24
24. 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 subcatalogue Population statistics and then select the table named Mean population by region age period and sex See Picture 3 Make a table in PC Axis Now it is time to select values for the variables decide what the table shall contain 4 PC AXIS 2003 Select values to the table How to select all About classification of values www scb se c cd7003 Database Sweden Population Population statistics vBEOIOLA4 px X P 010144 Mean population OF Cancel lu nits number Total no of cells 509184 All Aggregate Variable marital status Elimination not allowed Zoom region 312 fage 102 period 2 Long texts 2001 01 Stockholm county 1 2002 0114 Upplands W sby 0115 Vallentuna 0117 Oster ker 0120 Varndo 0123 J rf lla Prterer re tre titre rete eee rere rere i iis Selected values CTRL mause widowers ridon divorced Click here to select all values Picture 3 If you desire all values in a variable you can click on the namebar for the very variable selection box As in sample on Picture 3 where all two values will be selectged 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 mousebutton on the d
25. n statistics BEO10144 px X E 0144 Mean population DE Units number Total no of cells 104832 See 2 Variable period Elimination not allowed Zoom region 312 o vear intervals 21 period 2 Long tests 01 Stockholm county 0114 Upplands W sby 0115 vallentuna 0117 ster ker 0120 Varmdao 0123 J rf lla cit I roe fad 3 marital status 4 widowers widows divorced Picture 6 a When all selections are finnished click OK and the table appears on the screen If there are very long texts on the variable values there is an option in the new version 2003 of PC Axis to get an alternative menu Just press Om det ar mycket langa texter for variabelvarden finns fran och med version 2003 av PC Axis en m jlighet att f en annan layout genom att trycka pa knappen Langa texter D far man denna bild ist llet PC AXIS 2003 www scb se c cd2003 Database Sweden Population Population statistics BE010144 px oj xj iu 0144 Mean population OK Cancel Units number Total no of cells 104832 Ja 1 28 42 All for variable Mariable sex Elimination possible made by summing Aggregate region Selected 1 of 31 2 5 year intervals Selected 21 of 21 period Selected 1 of 2 sex Selected 2 of 2 marital status Selected 0 of 4 hid women Use this layout as default Figure 6 b If you tick the option Use this layout as default the only way to
26. ogram Program mm _ 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 informations 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 Inthe field Program the path and the name of the exe file has to be entered using Browse support If you can not 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 19 PC AXIS 2003 www scb se hir PC AXIS F cAcdrom2002D atabaze S weden Population Population statistics BED E ooo 1600 4495363 Cf BUS 934998 ET I bis 12752 Ti 17480 17291 Picture 22 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 20 PC AXIS 2003 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 make you glad is that you do not have to watch all these table cells on the
27. raph Total Map J12 11 0115 Vallentuna Standard Total vw Advanced 13 0117 ster ker 14 Total 17450 17291 4 Hj Press Fl for Help A 626 Cs 2 Picture 19 Where you select the tag Format for data cells Options for Advanced X Close select 4 format for presentation of data Apply Example ten thousand shown ag 10000 f 10000 10 000 f 10 000 Figure 20 Then mark the type of thousand delimiter you want to use in the tables The selected option will work from the next table opened in PC Axis 18 PC AXIS 2003 www scb se 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 a folder named More Features and then click on Additions Now Change use the folder Other programs andthe button e And you will find this window Additions F Add program by entering menu text and program with complete path Remove program by removing the menu text Cancel du 1 2 Menu test File type Program Menu test File type Excel Jxls2 Prograrn c Program Olffice2k OfficeSEXCEL 3 4 Menu test File type Menu test File type mm E EE FEN Pr
28. s BE 010144 px C Lokal PC Asis_2 ER 4 fr Lokal PC sis databas Subject Area Population Cancel New folder _ New alder Drives 3 Update subject E area in table files with selected Description folder Save as OOS E files Picture 9 If you would like to save the table in another file format you just select the tag Convert as in Picture 10 9 PC AXIS 2003 www scb se Save To BE0101A4 xls Lotus wk dB ase dbf dBase for Mapinto dbf FC AAIS file py Table tt Picture 10 In the listbox File Format you can save the table in any of the optional file formats 10 PC AXIS 2003 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 done 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 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 reglar H Hearclasses Picture 11 When you are satisfied just press OK and the new table turns up This can be repeated so you will realy be satisfied with your table 11 PC AXIS 2003 www scb se To do simple calculations using PC Axis There are some simple tasks
29. t V Value set of normal structure H Hierarcical value set N sub areas Press on the button named Aggregations Aggregation for ALDER 1 Aggregation PP Moule Add zave 10 vearclasses Description Delete Close Read from File 1 re Show Groups Overlapping Code 0 9 oon Allow values ina group to Test Change overlap E Delete Values Values Included Un Mio 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 transfered to the left using the arrow key on the screen 25 PC AXIS 2003 www scb se If it is not ticked on Allow values in a group to overlap the values will dissapear from the right hand box when clicked to the left This is the most common way of using classification If you make groupes 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
30. 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 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 A more detailed description of PX Map is in a separate Users Manual available on the CD ROM Statisitcs Across borders 17 PC AXIS 2003 www scb se About advanced functions in PC Axis The presentation of figures in the table cells can optionally hold thousand delimiters Use the menu View Advanced pay PC AXIS c cdrom20074D atabase S weden Population Population statistics BEO_ Miel E4 Window Help my x T File Edit Calculate ex GJE v Ioba EX x 4 Mule me A w Status Bar 7 Hean population w Zero Rows period and sex s Sar Gallet 3 vw Grid Lines Ea vw Column Identities w Row Number 00 Sweden Shani Tabie Te 6 Total Fonts 363 01 Stockholm count Alignment fea Total Language Riggs 9 10714 Upplands v st G
Download Pdf Manuals
Related Search