I have a Proc Freq that produces a column of 3 numbers (Column name 'N', row 1 name is 'All', row 2 name is 'Female', row 3 name is 'Male'. Column N contains headcounts. The dataset name is B1A. I want to write these three numbers to an external excel file called 'Final_Table_Test.xlsx; tab name is .Table'. The Excel file is: filename DDE "excel|C:\...\2020-2021 TABLE\[FINAL_Table_TEST.xlsx]Table!R6C3:R8C3". At one time (years ago), I I wrote something like this that actually did this. DATA _NULL_; set SANDBOX.B1A; INFILE 'B1A'; input N; FILE FINAL_Table_TEST; PUT CELL1 CELL2 CELL3; RUN; However, no manipulation I have tried works. I get the following error: ERROR: Physical file does not exist, C:\WINDOWS\system32\B1A. ERROR: Insufficient authorization to access C:\WINDOWS\system32\FINAL_TABLE_TEST. Any ides?
... View more