How would you code the criteria to restrict the output to be
produced?
Answers were Sorted based on User's Feedback
Answer / dupe
Various datestep options, can be use to restrict number of
observations
obs=;
firstobs=;
point=obsnum
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / selvi
by if exp=codn; - restrict the output to be produced
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / harish
with out proc print statement we can block the out put.
| Is This Answer Correct ? | 1 Yes | 2 No |
how to remove duplicates using proc sql?
If money were no object, what would you like to do?
How to get second top scorer student from a class- table having different sections A, B, C & D? each section has same number of student.
what is Business Intelligence?
There is a field containing a date. It needs to be displayed in the format “ddmonyy” if it’s before 1975,”dd mon ccyy” if it’s after 1985, and as ‘disco years’ if its between 1975 and 1985. How would you accomplish this in data step code? Using only PROC FORMAT.
calculate the sum of value using only DATA STEP. data count_; input year name $ value; cards; 2006 xxx 10 2007 yyy 12 2006 xxx 20 2008 yyy 15 2007 xxx 15 ; out put should be like this year name T_value ----------------------- 2006 xxx 30 2007 xxx 15 2007 yyy 12 2008 xxx 15
how to generate the test data in sas without input data? : Sas-administrator
How to read multiple excel sheets from a single excel file at once????
7 Answers HCL, Verinon Technology Solutions,
How would you include common or reuse code to be processed along with your statements?
What happens in the following code, if u type 8 instead of *? proc sql noprint; create table abc as select 8 from lib.abc; quit;
How does proc sql work?
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