I have been using following code to importmultipleexcelfiles. But today its giving me this error - ERROR: File WORK.RUN.DATA does not exist. Tries looking up here but unable to resolve. F...
Hi,
I am trying importmultiplefiles from a folder. I try every code in others topics and never made it. All files in that folder have the extension xlsx
For save the name files...
I'm trying to importmultipleExcel sheets. The problem is that I don't know the amount of Excelfiles that have to be combined into a single table in SAS. Which Excelfiles that are used, are f...
...bsp;
%import(file1); %import(file2); %import(brabra.... etc.
However, it didn't work, and what I got was only
ERROR: Physical file does not exist, C:/Users/somebody/Desktop/C...
Hi there - I need to importmultiple sheets from one excel workbook "Transposednew" into SAS as separate SAS data files. Excel workbook "Transposednew" contains 316 sheets with name J...
...reate and share data sources across multiple projects. Let’s explore this topic now.
Data
We are going to import the soil.csv file which contains African soil property data into Enterprise M...
I am trying to import .xlsx file with 1700 columns using data step, but it is taking in only 255 variables.I tried using Proc import but it isn't taking it either.Any ideas how do i get all the 1...
Hi SAS Community, Please could someone assist me? I am new to SAS. My Objective: To import many excelfiles into sas. My Understanding: 1. a macro can be used. 2. I am a...
Hi SAS Users, I am converting excel to SAS dataset with the following code. now I want to convert around 10 excelfiles to SAS datasets. instead of writing 10 time this same code c...
Hi,
I have a number of Excelfiles, named Company1_2016Q1.xlsx, Company1_2016Q2.xlsx, Company2_2016Q1.xlsx, Company2_2016Q2.xlsx etc. They are stored in one folder with multiple s...
