I would like to create weekly data from a start date to end date with a week indication variable, see example wanted data. %let Start= "7feb2020"d; %let End=''2apr2020"d;   Wanted Data: Start_week End _week  Week_Indicator 7feb2020    13feb2020     1 14feb2020   20feb2020    2 21feb2020   27feb2020    3 28feb2020   5mar2020     4 6mar2020   12mar2020    5 13mar2020   19mar2020   6 20mar2020  26mar2020    7 27mar2020   2apr2020      8   Thank you.   ... View more

I would like to import text (attached example data). Id and text are 2 variables. There are spaces before id, so I could not import successfully into SAS (the actual data have about 5000 rows). Thank you. ... View more

I have data with daily date data. I would like to identify 3 days interval (Day_3), see below: Date  Day_3 01012020   1 01022020   1 01032020   1 01042020    2 01052020    2 01062020    2 etc. Thank you.   ... View more

I have the following data: Name Day1 Day2 Day3 Day4 Kim        2    3   9   0  Anna      0    1   2   9  Joe        5    5   9   0  Bob        2    0   9   0  Enward  2    6   5   0    I would like to get the top 3 ranks for each day and summation of remaining data and formatted as a long data as below: Name Day Counts Joe Day1       5 Bob Day1       2 Edward Day1 2  (when tie, the take the first name--Edward is before Kim) Others Day1  2 Edward Day2 6 Joe Day2       5  Kim Day2      3 Others Day2 1 Bob Day3     9 Joe Day3      9  Kim Day3      9 Others Day3  7  Anna Day4     9 Bob Day4      0  Joe Day4      0 Others Day4  0   Actual data have many columns. Thank you.         ... View more