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
what do the mod and int function do? What do the pad and dim functions do? : Sas programming
Difference between informat and format?
How sas treats the dsd delimiters?
What are common programming errors committed in sas
What does P-value signify about the statistical data?
What is the function of Stop statement in a SAS Program?
Explain the special input delimiters used in sas programming.
how can you put a "trace" in your program? : Sas programming
how to change the execute of macro
Give e an example of..
what is the difference between nodup and nodupkey options? : Sas programming
what is the difference between floor and ceil functions in sas? : Sas-administrator
Differences between where and if statement?
how does sas handle missing values in procs? : Sas programming
i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;