how can u import .csv file in to SAS?tell Syntax?
Answer Posted / enr
To create csv file,we have to open notepad.then ,declaring
the variables.then save the file.like enr.csv
SYNTAX: proc import datafile='external file'
out=<dataset name> dbms=csv replace;
getnames=yes;
proc print data=<dataset name>
run;
eg:proc import datafile='E:\enr.csv'
out=sai
dbms=csv replace;
getnames=yes;
proc print data=sai;
run;
Is This Answer Correct ? | 32 Yes | 2 No |
Post New Answer View All Answers
Which statement does not perform automatic conversions in comparisons?
How to include or exclude specific variables in a data set?
How do dates work in sas?
What are the parameters of scan function?
What is the use of stop statement?
Which date function advances a date, time or datetime value by a given interval?
What commands are used in the case of including or excluding any specific variables in the data set?
what are the categories that sas informats are used to the place the data? : Sas-administrator
Mention what is the difference between nodupkey and nodup options?
What are the new features included in the new version of SAS Programming Language?
what are validation tools that are used in sas? : Sas-administrator
how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming
what is sas and what are the functions? : Sas-administrator
Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?
where are dashboard components are created and maintained? : Sas-bi