Hello,   I use base SAS but when I double click on a SAS file to open it (base SAS is not yet open), the file opens in Enterprise (which I'm not yet familiar with). How do I get SAS to default to opening my files in base SAS?  Screenshot of menu avaiable when I select Start, Programs on my computer, attached.   Thanks! ... View more

Hi, I'm trying to drop variables and rename variables in a dataset.   I have var1 and var2 in the orignal dataset and am converting them into percentages using arrays.  I'd like the variables in the output dataset to have the  same names var1 and var2 so I'm trying to rename the new variables I created (pctvar1 pctvar2) to become var1 and var2 and also drop the old var1 and var2 variables that I don't need.    data round (drop=var1 var2) rename= (pctvar1=var1 pctvar2=var2); set first;   *create percentages; array mult var1 var2; array pct pctvar1 pctvar2; do over mult  pct=mult*100; end;   *--round to nearest tenth; do over pct;  pct=round(pct, .1); end; run;       What am I doing wrong?  thanks! ... View more

I have the following data                 county school enrollment vax1 vax2 schooltype         countyA little tots 50 48 45 private         countyA happy days 100 88 77 public         countyA playtime 25 22 23 private         countyB busy beez 23 22 21 public         countyB child time 27 25 25 public                             We'd like to aggregate by county and by type, like the output below?                                 vax1   all public private county enrollment number percent enrollment number percent enrollment number percent countyA 175 158 90.3% 100 88 0.88 75 70 93.3% countyB 50 47 94.0% 50 47 0.94 0 0 0   Thanks! ... View more