Hi, I'm trying to use ODS EXCEL to output my dataset. Below is an example of my code. data test; input ID$ age; cards; A 23 B 99 C 87 ; run; ods excel file="age.xlsx" options(sheet_name="test"); proc report data=test style(header)=[background=white font_face="Calibri" foreground=black] style(column)=[font_face="Calibri"] nowd; run; ods excel close; The result is like the below picture, the background borders are not displayed.             I would like to keep all the borders like the one below, how can I modify my code? Thanks in advance. ... View more

I am a beginner in SAS I have a dataset with expected value in poission distribution. The dataset like below count 18 27 56 90 177 354   I try to generate random sample by the following code. DATA a_1; do i=1 to 100; x=RAND('POISSON', 18); output; END; drop i; RUN; The '18' is from the dataset, I want to continue to use value '27','56',....each value do 100 times Finally, I hope my data like   count 18 27 56 ... 354 1 25 26 49   335 2 12 19 60   327 3 15 20 51   367 4 16 22 53   353 ...           100 22 19 48   347   How can I  finish this process? Thanks in advance   ... View more