42.0 CITIBASE Command The CITIBASE command allows the user who has licenced RATS386/RATS32S version 4.20 and later to load citibase data directly into B34S. The procedure allows data to be converted from monthly to quarterly or from quarterly to monthly. This command can be placed in a batch file or can be called from the B34S Display Manager Menu facility. The objective of this command is to provide quick access to data. Once the data is loaded in B34S it can be saved in spread sheet format, in SCA FSAVE format, in RATS format, in SAS format or in B34S datastep format. The version of RATS used is saved in the file ratsciti which is in the c:\b34slm directory General form of the command. B34SEXEC CITIBASE parameters options$ MAKECITI options parameters$ EDITCITI LOADCITI options parameters$ ADDLABELS$ B34SEEND$ Options for CITIBASE sentence CITILIST(' ') Sets location for citimaxi.lst file which contains all the series in the citibase list. Default = 'c:\citibase\citimaxi.lst' CITILIST can be set on the OPTIONS command. A max of 40 characters can be set. The file autoexec.b34 is usually used to override the default settings. NEWCITI(' ') Sets the location of the extract list. Default =_citinew.lst. A max of 40 characters can be set. MAKECITI sentence. The MAKECITI sentence calls the editor to build the _citinew.lst file. The user is placed in the editor of choice. The user deletes lines of variables that are not wanted. Since the basic file, citimaxi.lst is so large, the Microsoft editor EDIT cannot be used due to memory problems. There are no options or parameters on the MAKECITI sentence. EDITCITI sentence. The EDITCITI sentence allows the user to open the _citinew.lst to further delete series. There are no op[tions opr parameters on the EDITCITI sentence. LOADCITI sentence. The LOADCITI builds the appropriate RATS386 commands to load the citibase series listed in the file _citinew.lst. LOADCITI sentence options and parameters. MONTHLY Instructs RATS386 to convert all series to monthly. QUARTERLY Instructs RATS386 to convert all series to quarterly. This is the default. YEARLY Instructs RATS386 to convert all series to yearly. VERBOSE Instructs RATS386 to provide details on the data loaded. This is the default. NOVERBOSE Turns off RATS386 info messages. KEEPMISS Keeps missuing data in the file. DROPMISS Drops missing values. NORATSLIST Turns off listing of rats output in B34S output. This option is not recommended unless user is sure output ha been loaded correctly. COMPACT=key If the original data frequency is less than the desired frequency, the same number is used for all is used for all observations for which data is not available. For further detail see the RATS Manual. The default value for key is AVERAGE, other possible settings are SUM, GEOMETRIC, FIRST, LAST, MAXIMUM, MINUMUM. If a number is passed, the RATS SELECT=n option will be used. For example COMPACT=2 in a case were monthly data were converted to quarterly would imply that the second month in each quarter would be used to set the quarterly value. For further see the RATS manual section 2.9. RATS(' ' ' ') Allows the user to add RATS386 commands to the job. BASEYEAR=n1 Sets base year for RATS CAL command. Default = 1945 BASEPERIOD=n2 Sets base period for RATS CAL command. Default=1. ENDYEAR=n3 Sets end year. Default = 1996. ENDPERIOD Sets end period. Default= 1. The CITIRATS command uses an internal files _RATS.IN and _RATS.OUT which are removed. ADDLABELS sentence. The ADDLABELS sentence allows the user to place labels in a B34S datafile after the series have been loaded. Series labes are added from the _citinew.lst file. Note: Only one and at least one of the below listed sentences must be supplied: MAKECITI, EDITCITI, LOADCITI, ADDLABELS. Examples. Call the Editor to edit file. b34sexec citibase$ makeciti$ b34seend$ Call the editor to update an existing _citinew.lst b34sexec citibase$ editciti$ b34seend$ Load data from citibase files to B34S given existing _citinew.lst file. b34sexec citibase$ loadciti$ b34seend$ Add labels to an already loaded B34S dataset. b34sexec citibase$ addlabels$ b34seend$