What is LOGICAL VARIABLES in SAS.And how it can be used..Can
anyone support..???
Answers were Sorted based on User's Feedback
Answer / sangeeta
Fitst. and Last. varibles used in data step are called
Logical Variables.
| Is This Answer Correct ? | 26 Yes | 3 No |
Answer / nagaraju
Fitst. and Last. varibles are logical variables and returns
1 & 0 values.
These are mailnly used to give the first and last
occurances from the table.
ex: employee table having (1-100 employees) -- uses
if we give first.empid=1 then it gives only first employee
details
if we give first.empid=0 then it gives remaining employee
details except first one
in the same way
if we give last.empid=1 then it gives last employee details
if we give last.empid=0 then it gives remaining employee
details except last one
hope this is clear
| Is This Answer Correct ? | 22 Yes | 3 No |
Answer / xxx
Yes I agree with the above answers,
first.obs and last.obs are also specifies the occurrence of the data. If we mention like
first.obs=1 and last.obs=1;
it will eliminate the duplicates also.
| Is This Answer Correct ? | 7 Yes | 0 No |
here is a string like chq.2312244%4452- from that i want only special characters in a column. dont use compress. bcoz i have 1.2 billion of records.i want another process to find the values instant from the data.
what is conditional processing?
What is the difference between input and infile statement?
Why and when do you use proc sql?
what is sas metadata repository? : Sas-bi
In sas admin differentiate between roles and capabilities? : sas-grid-administration
What are the ways to do a “table lookup” in sas?
how to change the execute of macro
What are the Aggregate functions in SQL ?
Which is the best training Institute for SAS Business Intelligence course?
Intern stastical programmer written test
what is option year cuttoff in sas