Interested to Buy Any Domain ? << Click Here >> for more details...
Can we replace a dataset into view?
- 6 Answers
- 12719 Views
- CliniRx, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / jyotshna
yes we can replace dataset into view
syntax:
data librefname.datasetname/view=librefnmae.datasetname;
run;
sample:
data aa/view=aa;
set sashel.class;
run;
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / vivek
proc sql;
create view <viewname> as
select *
from <Datasetname>;
quit;
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / gk
yes we can replace a data set with view by a procedure
called datasets
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / sriraghubabu
yes, we can replace dataset into view in Proc sql.
example:
proc sql;
create view newemp as
select *
from Employee
group by name;
select * from newemp;
quit;
now the data set is replaced into view..
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / guest
yes we can
ex: data aa/view=bb;
input variables;
datalines;
run;
| Is This Answer Correct ? | 0 Yes | 3 No |
I need to find the numeric field which contains blank in between..Ex:123 456...there is blank in between the 123 456..I need to know if there is any SAS function to find a field.. Please suggest...
For what purpose(s) would use the RETURN statement?
What is SAS? is it a software just for use or we can creat something over there?
What is Transaction...? And what are Comment, Roll back n Save point..?
How would you code a macro statement to produce information on the SAS log? This statement can be coded anywhere.
name some data transformation used in sas di? : Sas-di
wat has been most common programming mistake?
what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi
Hi,by usining ptf how we have to combine (likr merge)10 datasets at a time in the oracle database(and write a macro code also)?Like this i have a douts a lot if you dont mind may please send one text mail for me(madhusudhanap16@gmail.com)?
if you have 365 no of data set and each one having different variable from each other. how will you read by creating macros and create a single data set.
what is SAS ACCESS AND SAS CONNECT ? Give an example and data statements used.
Differentiate between proc means and proc summary.
Teradata 
