topic Re: How to import a .csv file in a table format in SAS in SAS Procedures

How to import a .csv file in a table format in SAS

Asudipta — Tue, 13 Jan 2015 18:47:54 GMT

Hi , I am using SAS Studio, have already uploaded csv file which are my data files.How do I convert the csv file to data file.I do not find the data import wizard in the SAS on Demand for Academics.

Thank you and Best regards,

Sudipta

Re: How to import a .csv file in a table format in SAS

SASKiwi — Thu, 07 Sep 2017 17:47:11 GMT

Editor's note: Thanks for the additional explanation provided by @Cynthia_sas.

You could try PROC IMPORT:

PROC IMPORT OUT = my_csv

FILE = "c:\my_csv.csv"

DBMS = CSV

REPLACE;

RUN;

Re: How to import a .csv file in a table format in SAS

Cynthia_sas — Tue, 13 Jan 2015 19:32:04 GMT

HI: Basically, PROC IMPORT is the correct approach. However, remember that SAS Studio does not read a C: drive location if you are using SAS Studio with the University Edition or with SAS OnDemand for Academics. For the SAS University Edition, you will need to put the CSV file in your shared folder location and your FILE= option will be something like: FILE='/folders/myfolders/my_csv.csv'. But for SAS OnDemand for Academics, when you signed up for the account, you were given a directory path, so in this instance, you would need to upload the file to your space on the server and then your FILE= option would be something like: FILE='~/xxxxxxxxx/my_csv.csv'; (where ~/xxxxxxxxxx/ is the location you find in your OnDemand control center for your directory path).

cynthia

Re: How to import a .csv file in a table format in SAS

Asudipta — Wed, 14 Jan 2015 01:45:28 GMT

Thank you both, I tired out the same procedure.Got the following output.

I wanted the name of the variables to be left blank.Here it is taking the first value as variable names.

Re: How to import a .csv file in a table format in SAS

SASKiwi — Wed, 14 Jan 2015 02:07:37 GMT

Try adding this statement to your program before the RUN statement:

GETNAMES = NO;

Re: How to import a .csv file in a table format in SAS

Asudipta — Wed, 14 Jan 2015 02:17:57 GMT

Thank you both, my problem got resolved. If I need to insert names to the variable, how do I go about it?

Re: How to import a .csv file in a table format in SAS

SASKiwi — Wed, 14 Jan 2015 03:08:50 GMT

Check out the RENAME statement in the documentation.

Re: How to import a .csv file in a table format in SAS

Asudipta — Wed, 14 Jan 2015 03:21:37 GMT

Thank you very much! Appreciate your support!

Re: How to import a .csv file in a table format in SAS

Shivi82 — Wed, 30 Dec 2015 06:55:21 GMT

Hi Cynthia,

How can i recall my directory path as i am also facing error while uploading the csv file.

I have enrolled to 3 courses however dont find themm listed on my login screen.

Regards, Shivi