How to display duplicate observations in data?
Answer / ravi
we can use the sort DUPOUT in the sort procedure to display the duplicate records as a separate dataset.
| Is This Answer Correct ? | 0 Yes | 0 No |
libname deepak 'C:\SAS Files'; proc format; invalue convert 'A+' = 100 'A' = 96 'A-' = 92 'B+' = 88 'B' = 84 'B-' = 80 'C+' = 76 'C' = 72 'F' = 65; data deepak.grades; input ID $3. Grade convert.; *format Grade convert. ; datalines; 001 A- 002 B+ 003 F 004 C+ 005 A ; proc print data = deepak.grades; run; I get the following output Obs ID Grade 1 001 . 2 002 . 3 003 . 4 004 . 5 005 . I don’t understand why Grade shows up as a missing value. Everything seems fine, including ID $3. Now, in case I use ID : $3. Or use column input, I get the desired output. Kindly help Deepak
What is the Program Data Vector (PDV) and What are its functions?
what is data integration? : Sas-di
If you were told to create many records from one record show how you would do this using arrays and with PROC TRANSPOSE?
How could you generate test data with no input data?
How can I remove header from output data set?
which date functions advances a date time or date/time value by a given interval? : Sas programming
Which command is used to save logs in the external file?
What can you learn from the SAS log when debugging?
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
For what purposes have you used sas macros? : sas-macro
If money were no object, what would you like to do?