Search the Community
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
390 results
Sorted by:
09-02-2014
04:07 PM
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...
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......
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...
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...
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...
-
...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 ...
-
...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...
-
@Shmuel wrote: @Tom's solution seems very neat, but testing it I have the feeling it misses...
-
It was realy a chalenge. Next code works fine with the sample. I hope you'll be able to addapt it...
-
...hat the data can then import properly. Thanks so much!
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...
10-23-2019
11:49 PM
Hello
From a SAS tutorial I found code to import multiple .csv files at the same time and it works well (code is below). I will admit that I don't fully understand the code but I a...