I have some data that looks the table below, except that my columns for each group (A, B) are over 1,000 and there's thousands of rows.   The operation that I want to perform is summing specific columns (e.g., A1 + B1, A2+B2, A3+B3) to get new columns in the table (C1,C2,C3). I would like to repeat this operation for all columns.   Obs. A1 A2 A3 A4 A5 B1 B2 B3 B4 B5 1 206 138 201 240 107 222 115 59 103 200 2 85 217 33 43 138 236 66 169 126 286 3 35 250 255 38 292 74 140 123 23 58 4 245 103 135 121 56 246 82 219 230 127 5 34 136 190 210 167 273 144 135 150 299 6 41 286 58 259 25 167 6 258 20 192 7 295 148 237 184 267 221 128 246 29 62 8 82 78 282 131 165 90 258 166 48 257 9 277 219 139 115 230 147 166 155 219 213 10 67 240 38 255 95 166 286 270 282 20   I have tried crafting a small macro (see below), but I'm not getting the output I want as it keeps overwriting my previous column. Can someone help me diagnose my error, or offer a better way to approach this. Thanks   %macro sum;   %local count;   %let count = 1;     %do i = 1 %to 500;     data WANT;     set HAVE;       %put &count.;       C_&count. = A_&count. + B_&count.;     run;       %let count = %eval(&count. + 1);     %end;   %mend sum; %sum ... View more

I am using the rand function to pull simulated values from a distribution. Right now, I have it set as rand('Normal', Mu, Sigma); however, I was wondering if there was a way to specify a distribution and input its mean, std. dev., skew, and kurtosis. This way the distribution from which I simulate the data resembles its empirical distribution. Thanks. ... View more

I have a SAS dataset called "holidays" that is structured as shown below that spans 1985-2023. I have dummy variables for the Friday and the weekend, and most importantly holidays. I am trying to write a loop which works through a list of all months and days of the week to determine what percentage of a day of the week, for a given month, falls on a holiday. For instance, what percentage of Monday's in January have been a federal holiday between 1985 and 2023? What percentage of Tuesday's in January, etc... Below is my code thus far:   %let m_list = 1 2 3 4 5 6 7 8 9 10 11 12; %let d_list = 1 2 3 4 5 6 7;   %macro holidays(list1,list2);   %local month day next_month next_day;   %do month = 1 %to %sysfunc(countw(&m_list));     %let next_month = %scan(&m_list,&month);       %do day = 1 %to %sysfunc(countw(&d_list));         %let next_day = %scan(&d_list,&day);   proc freq data = holidays; where Month = &next_month and dow = &next_day; table HolDum / out = prob_&next_month._&next_day;   data _null_; set prob_&next_month._&next_day; if HolDum = 0 then call symput("M&next_month._&next_day._0",PERCENT/100); else if HolDum = 1 then do; call symput("M&next_month._&next_day._1",PERCENT/100); end; run;   %end; %end;  %mend holidays; %holidays(&m_list,&d_list)   %put &M1_1_0 &M1_1_1 &M1_2_0 &M1_2_1;   Where I am stuck is the data _null_ step--the loop does not seem to be assigning percentages for the holiday dummy variable to the variable name (as verified when I run the %put statement). Can someone help me troubleshoot this. I'm relatively new to SAS so this might be a SAS issue I'm not seeing, or perhaps just a logic issue I'm missing. Thanks. ... View more