Where do the database management systems store data and how do
u import them.
Answer Posted / rajkumar
Most of the people are store their data in Oracle , SQL
Server.
We have to import the data by using import procedure.
Proc import datafile = <file path> out = <dataset name>
dbms = <identifier> replace;
<data-source-statement(s)>;
run;
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain the difference between using drop = data set option in set and data statement?
Explain the difference between nodup and nodupkey options?
how does sas handle missing values in a merge? : Sas programming
what are some good sas programming practices for processing very large data sets? : Sas programming
Are you sensitive to code walk-throughs peer review or QC review?
In proc transpose and data step with arrays which one you pick?
Mention few capabilities of sas framework.
What is connection profile? : sas-grid-administration
Explain append procedure?
How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?
what do the mod and int function do? What do the pad and dim functions do? : Sas programming
how can you create zero observation dataset? : Sas programming
What is program data vector (pdv)?
how to debug and test the sas program? : Sas-administrator
if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming