Dear experts, Me, the newbe, has created a macro to read in some csvfiles. It works but I think the code can be smarter since now I do this manually for something like 30 files which are a...
...ariables and are in the same format. I am relatively new to SAS, but am hoping to utilize a macro as I have multipleCSVfiles to combine for several projects. Thank you in advance and please let me know if I...
I am pulling 11 csvfiles 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......
..." /b';
/* This step resolves the file names in the directory (the downloaded csvfiles) to SAS dataset "files" - one table is created "fname" with the names of the csvfiles*/
data _HR;
length fname $2...
I have a directory with a large number of csvfiles. 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...
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...
Every month I have daily CSVfiles (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 CSVfile individually into SAS. May I k...
...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 have a bunch of large CSVfiles to import, each of which well exceeds the maximum number of rows an Excel spreadsheet can hold. The data are further complicated by a mixture of different formats o...
