Hi, I am using SAS University edition, the most recent version. I am having trouble with a data set that contains variable columns that have negative numbers. These numbers are from an excel spreadsheet. When I input the data set by double clicking on it, then run the program generated, the variable columns with negative numbers are classified as character instead of numeric. I have attached a copy of the dataset. This is the code that is automatically generated when I double click on the TAMDATA.xlsx file in myfolders: /* Generated Code (IMPORT) */
/* Source File: TAMDATA.xlsx */
/* Source Path: /folders/myfolders */
/* Code generated on: 5/7/17, 3:19 PM */
%web_drop_table(WORK.TAMDATA);
FILENAME REFFILE '/folders/myfolders/TAMDATA.xlsx';
PROC IMPORT DATAFILE=REFFILE
DBMS=XLSX
OUT=WORK.TAMDATA;
GETNAMES=YES;
RUN;
PROC CONTENTS DATA=WORK.TAMDATA; RUN;
%web_open_table(WORK.TAMDATA);
... View more