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
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;
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;
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
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.
Try adding this statement to your program before the RUN statement:
GETNAMES = NO;
Thank you both, my problem got resolved. If I need to insert names to the variable, how do I go about it?
Check out the RENAME statement in the documentation.
Thank you very much! Appreciate your support!
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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.