topic Re: Uploaded Data Showing '.' instead of numbers in SAS Studio

Uploaded Data Showing '.' instead of numbers

JacCoate — Tue, 27 Aug 2019 18:42:52 GMT

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;

Re: Uploaded Data Showing '.' instead of numbers

Reeza — Tue, 27 Aug 2019 19:00:54 GMT

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;

Re: Uploaded Data Showing '.' instead of numbers

PaigeMiller — Tue, 27 Aug 2019 19:06:14 GMT

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;