Good afternoon,   A few questions - I'm using base SAS 9.4   1)  If I'm creating an output dataset using proc report (output out=), do I need to use a sandwich since I'm not using HMTL or outputting to ?     2)  I'm using the following code but getting unexpected results   a)  the numbers in pctvar5 aren't displaying although you can see the cell has a value if you click on it   b) the formats I've assigned aren't showing in the excel output (the output is rounded to a whole percentage instead of having 2 decimals)     3) How do I get column H to display and how do I get excel to display the output?  I tried using ods tagsetsxp and everything displayed as expected but it gives percentage signs for each value   Thank you!   p.s. I tried attaching a screenshot but I got an error message saying the file extension wasn't valid. I wasn't able to delete the file so I just uploaded a test blank program     title; footnote; ods _all_ close;   　 ods excel file= file="c:\want.xls" style=journal; ods excel options(sheet_name='Table 1' autofit_height='yes' width_fudge='0.58'); proc report data=have nowindows headline headskip ; column county ('YEAR' year)('TOTAL NUMBER' total) ('CHILDREN WITH VAR1 pctvar1) (CHILDREN WITH VAR2 pctvar2) ('CHILDREN WITH VAR3' pctvar3) ('CHILDREN WITH VAR4' pctvar4) (CHILDREN WITH VAR5' pctvar5) ('CHILDREN WITH VAR6' pctvar6); define county / group order; define year / group order=internal descending ' '; define total / analysis 'NUMBER' format=comma8.; define pctvar1 / display right 'PERCENT' format=percent7.2 ; define pctvar2/ display 'PERCENT' format=percent7.2 ; define pctvar3 / display 'PERCENT' format=percent7.2 ; define pctvar4 / display 'PERCENT' format=percent7.2; define pctvar5 / display 'PERCENT' format=percent7.2; define pctvar6 / display 'PERCENT' format=percent7.2 ; compute after county; line ' '; endcomp; run;     ods excel close;           ... View more

G'day.   We are attempting to import an .xlsx file.  We had used the proc import statement %let location= D:\; %let filename=All.xlsx; PROC IMPORT OUT= WORK.all DATAFILE= "'&location.&filename'" DBMS=EXCEL REPLACE; RANGE="All$"; GETNAMES=YES; MIXED=NO; SCANTEXT=YES; USEDATE=YES; SCANTIME=YES; RUN; The file which has about 9000 rows imported fine except one field.  This one field with problems was missing the 3 nonzero observations which were 1 digit long.  The field:    -is a 'General' type in the excel spreadsheet under 'Number' -  in the Excel file had 2 observations missing information in row 2000 and 7000 - had all zeros in the spreadsheet except 3 observations which were listed in row 3000 and 6000 and 8000 - was imported as numeric in SAS   Finally, when closing and reopening SAS and restarting the computer didn't work, after using the Import WIzard, it worked. Why did it work for the import wizard but not using the program and macro variables above?  Now, I'm importing everything using the Import wizard.    Thank you! ... View more