There are 200 observations in a dataset, i want to pull out
the observation no's 100, 150,180,190 by using Proc SQL? How
you can get it?
Answer Posted / pranoy tikadar
PROC SQL;
SELECT*,
MONOTONIC() AS COUNT
FROM TEST
HAVING COUNT IN(100,150,180,190);
QUIT;
Is This Answer Correct ? | 11 Yes | 3 No |
Post New Answer View All Answers
what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming
How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?
Describe the ways in which you can create macro variables?
Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager
Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?
How would you define the end of a macro?
Why double trailing @@ is used in input statement?
Compare sas with other data analytics tools.
What is run-group processing?
What does proc print, and proc contents are used for?
what is change analysis in sas di ? : Sas-di
What are the parameters of scan function?
which features do you use to check the data validations and errors? : Sas-administrator
what is information maps?
What commands are used in the case of including or excluding any specific variables in the data set?