How would you code the criteria to restrict the output to be
produced?
- 9 Answers
- 19670 Views
- I also Faced
- E-Mail Answers
Answer Posted / jothi sankar
--> Using VAR can restrict which varibles have to be output
--> Using differnt data sets for each main condition
Eg:
DATA
MyData2
MyData3
MyData4
;
SET MyData1;
if Dept = 'Computer' OUT MyData2;
else if Dept = 'Electronic' OUT MyData3;
else if Dept = 'Chemical' OUT MyData4;
RUN;
--> Using PRINTEM for viewing datas individually
| Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
how to generate the test data in sas without input data? : Sas-administrator
How do you delete duplicate observations in sas?
What is the maximum length of the macro variable? : sas-macro
Which command is used to save logs in the external file?
Give some examples where proc report’s defaults are different than proc print’s defaults?
What is the sas data set? : sas-grid-administration
name the scheduler for scheduling job and explain the scheduler? : Sas-di
how are numeric and character missing values represented internally? : Sas programming
Explain what is data step?
Compare sas with other data analytics tools.
I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.
Mention common programming errors committed in sas ?
What are the differences between proc means and proc summary?
What are the difference between ceil and floor functions in sas?
What system options would you use to help debug a macro? : sas-macro
