topic Re: mis447 in New SAS User

mis447

laylasawaqed — Sat, 20 Feb 2021 00:02:25 GMT

Why my sas studio doesn't read my excel correctly please advice ?

find my attached is the excel sheet and how it read it ?

Re: mis447

Tom — Sat, 20 Feb 2021 03:42:36 GMT

How did you try to run the code? If you ran code please show the code and/or LOG. (Please post them as TEXT by using the insert code or Insert SAS Code icons in the forum editor).

I did not have any trouble importing the sheet from your XLSX file.

29    proc import datafile="c:\downloads\MIS445FRED-realGDP.xlsx" out=test replace dbms=xlsx;
30    run;

NOTE: The import data set has 285 observations and 2 variables.
NOTE: WORK.TEST data set was successfully created.

Re: mis447

ballardw — Sat, 20 Feb 2021 13:41:12 GMT

Define "doesn't read my excel correctly".

Error? Unexpected values? Variable names not following column headings? Missing variables? Missing rows of data?

I don't open XLSX files from unknown sources for a number of reasons so you need to be clear in describing what is wrong.