Search the Community
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
380 results
Sorted by:
09-02-2014
04:07 PM
03-20-2024
12:46 PM
I am pulling 11 csv files over from my local c: and the first row is not becoming the sas column names. The first field name is 'sep=' and the following field names are 'var1, var2, var3......
02-09-2017
06:34 AM
Dear experts, Me, the newbe, has created a macro to read in some csv files. It works but I think the code can be smarter since now I do this manually for something like 30 files which are a...
11-29-2023
03:47 PM
..." /b';
/* This step resolves the file names in the directory (the downloaded csv files) to SAS dataset "files" - one table is created "fname" with the names of the csv files*/
data _HR;
length fname $2...
07-01-2020
03:25 PM
...ariables and are in the same format. I am relatively new to SAS, but am hoping to utilize a macro as I have multiple CSV files to combine for several projects. Thank you in advance and please let me know if I...
04-27-2023
02:37 PM
I have a directory with a large number of csv files. I want to import some of them without writing a separate proc import for each, because that would be silly. For arguments sake, let's say the files...
12-13-2017
04:09 PM
Hi all, I am trying to import quite a large pipe-delimited txt file (approx. 18 million observations/ 17 million KB) into sas (version 9.4), but there are too many line breaks in my d...
Show results in replies (8)
-
...ctual data file ever have truncated records? That is records that only contain some of the fields a...
-
...he raw data you are using? If it's the latter get the person who made the file redo it c...
-
try using proc import, something like this proc import datafile ="C:\data.txt" out= xyz dbms="d...
-
It was realy a chalenge. Next code works fine with the sample. I hope you'll be able to addapt it...
-
@Tom's solution seems very neat, but testing it I have the feeling it misses the last input re...
-
@Shmuel wrote: @Tom's solution seems very neat, but testing it I have the feeling it misses...
-
...bsp; I have updated my sample data file as well.
-
Shmuel - your code seems like it will work for this data. I just tried modifying it a bit using my ...
07-02-2023
11:33 AM
Hello Experts,
I need to import multiple files from a location. Each files are having different format(xlsx,xls,csv,txt). I need to import all the files into sas. How to import all file w...
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:
01-25-2017
02:59 AM
Every month I have daily CSV files (from 2nd day of the month to 1st day of next month, e.g. 2 Oct to 1 Nov). I have no problem in importing the CSV file individually into SAS. May I k...