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
how does sas handle missing values in assignment statements? : Sas programming
What would be the value of month at the end of data step execution and how many observations would be there?
Difference between informat and format?
I have a dataset concat having a variable a b & c. How to rename a b to e & f?
which date functions advances a date time or date/time value by a given interval? : Sas programming
What are the functions used for character handling?
how to do user inputs and command line arguments in sas?
how to change the execute of macro
what is the primary data source for the wrs? : Sas-bi
why is sas data integration studio important? : Sas-di
Why double trailing @@ is used in input statement?
What will calendar procedure do?
Describe the ways in which you can create a macro variable?
how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming
what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?