SAS : Importing CSV File using PROC IMPORT

[shreyansh]

Let's take a simple example to import CSV (comma-separated values) file into SAS.

DBMS=CSV tells SAS that the file being imported is a CSV file.

PROC IMPORT DATAFILE='/home/intellectsage/data.csv'
DBMS=CSV
OUT=WORK.intellectsage;
GETNAMES=YES;
RUN;

The above SAS Program creates a SAS dataset named intellectsage in the temporary library (WORK).

Output : To see the imported file in RESULTS window, you can use PROC PRINT procedure. See the SAS program below.

PROC PRINT DATA=WORK.intellectsage;
RUN;