SAS Life Science Analytics Framework and the clinical data products from SAS

Reading Excel worksheets in SAS Drug Development 4.x

Reply
SAS Employee
Posts: 10

Reading Excel worksheets in SAS Drug Development 4.x

Users often need additional assistance with reading Excel worksheets in SDD.

In 4.x instances of SAS Drug Development (SDD), you can access Excel spreadsheets the same way you would on a PC.  Here’s an example that creates a SAS data set named “XL_1” from the “Sheet1” worksheet in the “AE_Specs2.xlsx” workbook:


%let workbook=&_sasws_/QAGPharma/Study2/Files/documents/AE_specs2;
PROC IMPORT
   DATAFILE="&workbook"
      DBMS=xlsx
      REPLACE
      OUT=xl_1;
   SHEET="Sheet1";
run;

Ask a Question
Discussion stats
  • 0 replies
  • 281 views
  • 0 likes
  • 1 in conversation