Search the Community
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
385 results
Sorted by:
03-05-2021
06:08 PM
I have been using following code to import multiple excel files. But today its giving me this error - ERROR: File WORK.RUN.DATA does not exist. Tries looking up here but unable to resolve. F...
02-05-2018
11:18 AM
Hi,
I am trying import multiple files 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...
09-05-2016
05:18 AM
I'm trying to import multiple Excel sheets. The problem is that I don't know the amount of Excel files that have to be combined into a single table in SAS. Which Excel files that are used, are f...
04-17-2022
09:31 PM
...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...
10-23-2014
01:01 PM
2 Likes
...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...
Labels:
04-14-2020
01:55 AM
Hi there - I need to import multiple sheets from one excel workbook "Transposednew" into SAS as separate SAS data files. Excel workbook "Transposednew" contains 316 sheets with name J...
03-19-2018
07:18 AM
Hi SAS Community, Please could someone assist me? I am new to SAS. My Objective: To import many excel files into sas. My Understanding: 1. a macro can be used. 2. I am a...
10-31-2023
07:20 AM
I want to import excel sheet which have multiple sheet and load the sheet's data in uppercase (i.e. everything in uppercase- variables and observations all ).
04-17-2018
09:56 PM
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...
07-10-2017
06:09 AM
Hi,
I have a number of Excel files, named Company1_2016Q1.xlsx, Company1_2016Q2.xlsx, Company2_2016Q1.xlsx, Company2_2016Q2.xlsx etc. They are stored in one folder with multiple s...