Hi,    I have a dataset with character and numeric variables (var1, var2, ....) and one of the variables is called 'fy' which takes on the character values of '2022','2023', and '2024'.    I want a dataset as follows below. The value 0.7 ,for example, represents the percentage of values of var1 that is missing or blank. In this case, 70% of var1 values in the dataset is missing or blank. Code should be able to handle whether var1 is character or numeric. Thanks!      fy2022 fy2023 fy2024 var1 0.7 0.65 0.6 var2 0.4 0.35 0.3 var3 0.5 0.45 0.4 var4 0.35 0.3 0.25 var5 0.6 0.55 0.5   I tried using proc freq data=out.mydataset; tables _all_/list missing; format _character_ $missing.               _numeric_ missing.; run; ... View more

Hi,    I currently have table with vaccination date for each type of vaccination administered to a patient, where each row is a patient. A_date1 is the vaccination date of the first dose of vaccine A. I want a table with three additional columns totaling the doses given for each vaccination (a_total, b_total,c_total). There are a total of 9 vaccinations with a vaccination having up to 5 doses.   I had tried: Array Raw {*} item1-item9; Array Key {9} $ _temporary_ (‘A’ ‘B’ ‘C’ ‘D’ ‘E’ 'F' 'G' 'H' 'I'); Array Score {9} ; Do i = 1 to 9; if raw{i} eq key{i} then total{i}=1; else total{i}=0; End; TotalCorrect = sum( of total1 – total9 );   I have: a_date1 a_date2 a_date3 b_date1 b_date2 b_date3 b_date4 b_date5 c_date1 c_date2 c_date3 c_date4 c_date5 1/2/01 2/10/01   2/1/01 4/2/01 7/15/01 8/1/01 10/1/01 1/1/2001 2/1/2001 4/20/01 8/22/01 9/15/01   I want: a_date1 a_date2 a_date3 b_date1 b_date2 b_date3 b_date4 b_date5 c_date1 c_date2 c_date3 c_date4 c_date5 a_total b_total c_total 1/2/01 2/10/01   2/1/01 4/2/01 7/15/01 8/1/01 10/1/01 1/1/2001 2/1/2001 4/20/01 8/22/01 9/15/01 2 5 5           ... View more

Hi everyone,    I would like assistance with the following.  For example, for by group account=X and ticker=A, there is a gap between date 1/1/2015 and 1/5/2015. I would like to add rows for 1/2/2015 through 1/4/2015 by taking the non-date values from row of 1/1/2015. I've attached an excel example for reference. Any help will be appreciated. Thank you.               Have                         Account Ticker Date Outstanding Shares Price   X A 01/01/15 100 $1   X A 01/05/15 200 $2   X B 01/01/15 300 $3   X B 01/05/15 600 $6             Want                         Account Ticker Date Outstanding Shares     X A 01/01/15 100 $1   X A 01/02/15 100 $1   X A 01/03/15 100 $1   X A 01/04/15 100 $1   X A 01/05/15 200 $2   X B 01/01/15 300 $3   X B 01/02/15 300 $3   X B 01/03/15 300 $3   X B 01/04/15 300 $3   X B 01/05/15 600 $6                                                 ... View more

Hi everyone,    I'm getting:   var1 var2 var3 A 1/1/14   A 1/2/14 1/1/14 A 1/3/14 1/2/14 A 1/4/14 1/3/14 A 1/5/14 1/4/14 A 1/6/14 1/5/14 A 1/7/14 1/6/14 A 1/8/14 1/7/14 A 1/9/14 1/8/14 A 1/10/14 1/9/14 A 1/11/14 1/10/14 A 1/12/14 1/11/14     I want:   var1 var2 var3 A 1/1/14 1/2/14 A 1/2/14 1/3/14 A 1/3/14 1/4/14 A 1/4/14 1/5/14 A 1/5/14 1/6/14 A 1/6/14 1/7/14 A 1/7/14 1/8/14 A 1/8/14 1/9/14 A 1/9/14 1/10/14 A 1/10/14 1/11/14 A 1/11/14 1/12/14 A 1/12/14     I'm using the following code:   data datawant; set dataraw; var3=lag(var2); run;   Thanks!!! ... View more

The code I tried is:   data  mergeddata; merge datasetA (in=in1) datasetB (in=in2); by country; run;     ... View more

Hi All,    I'm trying to get the desired dataset with the following command   data wanted; merge dataA (in=in1) dataB (in=in2); by Country,  run;   But with no luck. any help is appreciated! Thanks!!!! ... View more

  Hi everyone,    I'm trying to fill in empty cells using the value from the first non-missing cell to the left of that empty cell in each row. The table runs from January 1, 2014 through August 1, 2018. For example:       I tried:   data desiredtable; set rawtable; if variable=. then lag(variable); end; run;   But seems like this only works if the table was set up in long format vs. wide format.    Any help is appreciated. Thanks.    -Aidan ... View more