Saturday, 24 December 2016

SAS TIPS

SAS TIPS



   A semicolon is your friend, 
       That's how all SAS Program ends,
   If you have lots of error,
      Search for missing semicolon, which can end your terror.. :))




   1.       Do you know: You can prevent the SAS Datasets from Accidently being replaced…!!!
Users can specify the NOREPLACE system option to prevent a permanent SAS data set from being accidentally replaced with another like-named data set.
   
   2.       If you have a Note: “CHARACTER STRING WAS MORE THAN 200 CHARACTERS” in Log there are fair chances that you program have unbalanced Quotation Marks.
   3.       Do you know that you can capture the ONLY SAS Windows Screen shot using ALT + PRTSC.
  4.        Do you know for sorting SAS Dataset, it requires 4 times space of your data for processing?
   5.       Before submitting the final SAS Program that use a large data, Use OBS= option to test on subset of data to make sure your program syntax is correct.
   6.       Do you know how many factors affect the performance of your program?
   7.       Do you have problem in remembering Syntax?
  Ease your efforts with use of Abbreviation. It can also reduce the typing efforts?
  Goto : Tools  à Add Abbreviation
   8.        Do you know COUNT function can give you count of number of occurrence of substring within a string?
COUNT (string, substring, optional modifiers)
   9.       Do you know  option compress= char or compress=yes is good for compressing the data with large character values




No comments:

Post a Comment