1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 68 69 PROC IMPORT DATAFILE= "/home/u63997444/ECON 348/Master_use_edited_again2.csv" 70 OUT=Master_d 71 DBMS=csv 72 REPLACE; 73 GETNAMES=Yes; 74 RUN; NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to WORK.PARMS.PARMS.SLIST. 75 /********************************************************************** 76 * PRODUCT: SAS 77 * VERSION: 9.4 78 * CREATOR: External File Interface 79 * DATE: 11DEC24 80 * DESC: Generated SAS Datastep Code 81 * TEMPLATE SOURCE: (None Specified.) 82 ***********************************************************************/ 83 data WORK.MASTER_D ; 84 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */ 85 infile '/home/u63997444/ECON 348/Master_use_edited_again2.csv' delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ; 86 informat Date mmddyy10. ; 87 informat " Price"N best32. ; 88 informat " MarketCap"N best32. ; 89 informat Shares best32. ; 90 informat Firm best32. ; 91 informat FirmName $5. ; 92 format Date mmddyy10. ; 93 format " Price"N best12. ; 94 format " MarketCap"N best12. ; 95 format Shares best12. ; 96 format Firm best12. ; 97 format FirmName $5. ; 98 input 99 Date 100 " Price"N 101 " MarketCap"N 102 Shares 103 Firm 104 FirmName $ 105 ; 106 if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */ 107 run; NOTE: The infile '/home/u63997444/ECON 348/Master_use_edited_again2.csv' is: Filename=/home/u63997444/ECON 348/Master_use_edited_again2.csv, Owner Name=u63997444,Group Name=oda, Access Permission=-rw-r--r--, Last Modified=10Dec2024:10:40:10, File Size (bytes)=3210548 NOTE: 60885 records were read from the infile '/home/u63997444/ECON 348/Master_use_edited_again2.csv'. The minimum record length was 44. The maximum record length was 66. NOTE: The data set WORK.MASTER_D has 60885 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds user cpu time 0.03 seconds system cpu time 0.00 seconds memory 11821.15k OS Memory 32028.00k Timestamp 12/11/2024 08:32:43 PM Step Count 24 Switch Count 2 Page Faults 0 Page Reclaims 486 Page Swaps 0 Voluntary Context Switches 15 Involuntary Context Switches 2 Block Input Operations 0 Block Output Operations 5904 60885 rows created in WORK.MASTER_D from /home/u63997444/ECON 348/Master_use_edited_again2.csv. NOTE: WORK.MASTER_D data set was successfully created. NOTE: The data set WORK.MASTER_D has 60885 observations and 6 variables. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.08 seconds user cpu time 0.06 seconds system cpu time 0.02 seconds memory 11821.15k OS Memory 32544.00k Timestamp 12/11/2024 08:32:43 PM Step Count 24 Switch Count 8 Page Faults 0 Page Reclaims 4383 Page Swaps 0 Voluntary Context Switches 97 Involuntary Context Switches 2 Block Input Operations 0 Block Output Operations 5992 108 109 proc contents data=Master_d; 110 run; NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.02 seconds user cpu time 0.03 seconds system cpu time 0.01 seconds memory 3361.53k OS Memory 27564.00k Timestamp 12/11/2024 08:32:43 PM Step Count 25 Switch Count 0 Page Faults 0 Page Reclaims 684 Page Swaps 0 Voluntary Context Switches 3 Involuntary Context Switches 1 Block Input Operations 0 Block Output Operations 8 111 112 proc means data=Master_d; 113 run; NOTE: There were 60885 observations read from the data set WORK.MASTER_D. NOTE: PROCEDURE MEANS used (Total process time): real time 0.02 seconds user cpu time 0.02 seconds system cpu time 0.00 seconds memory 7739.09k OS Memory 32444.00k Timestamp 12/11/2024 08:32:43 PM Step Count 26 Switch Count 1 Page Faults 0 Page Reclaims 1652 Page Swaps 0 Voluntary Context Switches 42 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 16 114 115 data capsizedata; 116 set Master_d; 117 118 /* Assigning capsize based on Firm */ 119 if 1 <= Firm <= 10 then capsize = "mega"; 120 else if 11 <= Firm <= 20 then capsize = "large"; 121 else if 21 <= Firm <= 30 then capsize = "mid"; 122 else if 31 <= Firm <= 40 then capsize = "small"; 123 else if 41 <= Firm <= 50 then capsize = "micro"; 124 else capsize = "unknown"; /* Default case for capsize if Firm is not in expected range */ 125 126 /* Convert capsize into numeric dummy variables for regression */ 127 if capsize = "mega" then capsize_mega = 1; else capsize_mega = 0; 128 if capsize = "large" then capsize_large = 1; else capsize_large = 0; 129 if capsize = "mid" then capsize_mid = 1; else capsize_mid = 0; 130 if capsize = "small" then capsize_small = 1; else capsize_small = 0; 131 if capsize = "micro" then capsize_micro = 1; else capsize_micro = 0; 132 NOTE: There were 60885 observations read from the data set WORK.MASTER_D. NOTE: The data set WORK.CAPSIZEDATA has 60885 observations and 12 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds user cpu time 0.01 seconds system cpu time 0.00 seconds memory 3575.78k OS Memory 29356.00k Timestamp 12/11/2024 08:32:43 PM Step Count 27 Switch Count 2 Page Faults 0 Page Reclaims 526 Page Swaps 0 Voluntary Context Switches 12 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 11536 133 data capsizedata; 134 set Master_d; 135 /* Assigning capsizeadjust based on MarketCap */ 136 if MarketCap >= 2 then capsizeadjust = "mega_ad"; 137 else if 10000000000 <= MarketCap <= 200000000000 then capsizeadjust = "large_ad"; 138 else if 2000000000 <= MarketCap <= 10000000000 then capsizeadjust = "mid_ad"; 139 else if 300000000 <= MarketCap <= 2000000000 then capsizeadjust = "small_ad"; 140 else if 50000000 <= MarketCap <= 300000000 then capsizeadjust = "micro_ad"; 141 else capsizeadjust = "unknown"; /* Default case for capsizeadjust if MarketCap is not in expected range */ 142 run; NOTE: Variable MarketCap is uninitialized. NOTE: There were 60885 observations read from the data set WORK.MASTER_D. NOTE: The data set WORK.CAPSIZEDATA has 60885 observations and 8 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds user cpu time 0.01 seconds system cpu time 0.01 seconds memory 3563.93k OS Memory 29356.00k Timestamp 12/11/2024 08:32:43 PM Step Count 28 Switch Count 2 Page Faults 0 Page Reclaims 531 Page Swaps 0 Voluntary Context Switches 12 Involuntary Context Switches 1 Block Input Operations 0 Block Output Operations 7696 143 144 proc reg data=Master_d; 145 Model Price= MarketCap; ERROR: Variable PRICE not found. ERROR: Variable MARKETCAP not found. NOTE: The previous statement has been deleted. 146 run; WARNING: No variables specified for an SSCP matrix. Execution terminating. NOTE: PROCEDURE REG used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 3498.31k OS Memory 28864.00k Timestamp 12/11/2024 08:32:43 PM Step Count 29 Switch Count 0 Page Faults 0 Page Reclaims 616 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 1 Block Input Operations 0 Block Output Operations 48 147 148 proc reg data=capsizedata; 149 model Price =capsize_mega capsize_large capsize_mid capsize_small capsize_micro; ERROR: Variable PRICE not found. ERROR: Variable CAPSIZE_MEGA not found. ERROR: Variable CAPSIZE_LARGE not found. ERROR: Variable CAPSIZE_MID not found. ERROR: Variable CAPSIZE_SMALL not found. ERROR: Variable CAPSIZE_MICRO not found. NOTE: The previous statement has been deleted. 150 run; WARNING: No variables specified for an SSCP matrix. Execution terminating. NOTE: PROCEDURE REG used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 3497.43k OS Memory 28864.00k Timestamp 12/11/2024 08:32:43 PM Step Count 30 Switch Count 0 Page Faults 0 Page Reclaims 445 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 56 151 152 proc print data=Master_d (obs=10); 153 run; NOTE: There were 10 observations read from the data set WORK.MASTER_D. NOTE: PROCEDURE PRINT used (Total process time): real time 0.01 seconds user cpu time 0.02 seconds system cpu time 0.00 seconds memory 2003.18k OS Memory 27304.00k Timestamp 12/11/2024 08:32:43 PM Step Count 31 Switch Count 0 Page Faults 0 Page Reclaims 270 Page Swaps 0 Voluntary Context Switches 1 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 154 155 proc print data=capsizedata (obs=10); 156 run; NOTE: There were 10 observations read from the data set WORK.CAPSIZEDATA. NOTE: PROCEDURE PRINT used (Total process time): real time 0.01 seconds user cpu time 0.01 seconds system cpu time 0.00 seconds memory 2018.37k OS Memory 27304.00k Timestamp 12/11/2024 08:32:43 PM Step Count 32 Switch Count 0 Page Faults 0 Page Reclaims 257 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 157 158 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 168 My teacher said the reason is this as its something she has never seen before Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to WORK.PARMS.PARMS.SLIST.
... View more
