Uploaded Data Showing '.' instead of numbers

[JacCoate]

Hello - I am new to SAS Studio and figured out how to upload an excel doc. I am running simple code to print my data and am seeing periods: '.' instead of my numbers. I've attached screenshots of my results tab as well as the excel doc I'm uploading.

I'm sure I am missing something very simple. Can someone help me?

data hw4;
infile '/home/u39793781/sasuser.v94/DS6371 Statistical Foundations/Unit_1/Unit1HW4.xlsx';
input SMU SeattleU;
run;

proc print data = hw4;
run;

[Reeza]

You cannot import an XLSX file via INPUT you need to use PROC IMPORT instead.

Use either a task or proc import to import your XLSX file and you'll be fine.

INFILE is for text files.

---

@JacCoate wrote:

Hello - I am new to SAS Studio and figured out how to upload an excel doc. I am running simple code to print my data and am seeing periods: '.' instead of my numbers. I've attached screenshots of my results tab as well as the excel doc I'm uploading.

I'm sure I am missing something very simple. Can someone help me?

data hw4;
infile '/home/u39793781/sasuser.v94/DS6371 Statistical Foundations/Unit_1/Unit1HW4.xlsx';
input SMU SeattleU;
run;

proc print data = hw4;
run;

---

[PaigeMiller]

No files are attached, and many of us will not download Microsoft Office files anyway, as they are a security risk.

Please try this:

proc import datafile='/home/u39793781/sasuser.v94/DS6371 Statistical Foundations/Unit_1/Unit1HW4.xlsx' 
    dbms=excel replace out=want;
run;