how can u import .csv file in to SAS?tell Syntax?
Answer Posted / shruthi
data DatasetName(drop = If any);
infile 'Path\CSVFileName.csv' delimiter = ',' ;
informat Var1 $2.;
informat Var2 anydtdte21.;
format Var1 $2.;
format Var2 anydtdte21.;
Input
Var1 $
Var2 $;
run;
| Is This Answer Correct ? | 14 Yes | 7 No |
Post New Answer View All Answers
explain about various caches available in data integrator? : Sas-di
In proc transpose and data step with arrays which one you pick?
what are 5 ways to perform a table lookup in sas? : Sas-administrator
how will you locate the sas platform applications? : Sas-bi
what is the primary data source for the wrs? : Sas-bi
Explain translate function?
What do the put and input function do?
How many ways to overcome a missing values???
How does proc sql work?
What is the difference between INPUT and INFILE ?
What is a macro routine?
Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro
what are the categories that sas informats are used to the place the data? : Sas-administrator
Name validation tools used in SAS
what do you mean by data staging area? : Sas-di