1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 68 69 data np_summary_update; 70 set pg1.np_summary; 71 keep Reg ParkName DayVisits OtherLodging Acres SqMiles Camping; 72 SqMiles=Acres*.0015625; 73 Camping=sum(OtherCamping,TentCampers, 74 RVCampers,BackcountryCampers); 75 format SqMiles comma6. Camping comma10.; 76 run; NOTE: There were 135 observations read from the data set PG1.NP_SUMMARY. NOTE: The data set WORK.NP_SUMMARY_UPDATE has 135 observations and 7 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 959.75k OS Memory 22440.00k Timestamp 01/17/2023 10:03:07 PM Step Count 55 Switch Count 2 Page Faults 0 Page Reclaims 165 Page Swaps 0 Voluntary Context Switches 18 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 264 77 78 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 88 ... View more

libname pg1 "/home/u44465073/EPG1V2/data"; this is the libname statement I use ... View more

data np_summary_update; set pg1.np_summary; keep Reg ParkName DayVisits OtherLodging Acres SqMiles Camping; SqMiles=Acres*.0015625; Camping=sum(OtherCamping,TentCampers, RVCampers,BackcountryCampers); format SqMiles comma6. Camping comma10.; run; ... View more

Hi, it doesn't seem like there is anything wrong with the files, unless I am missing something.  I am still getting 0 as the answers. I attached pictures of the code, the results for the modified table ( total rows:135, total columns 7), and results for the original table ( total rows:135, total columns: 10).   ... View more