Dummy Dataset or SAS Options: Which is better to insert a Zero Row?
• Exporting the dataset into .csv file • File exists in the library or not • Find path & filename of executed program • Finding Number of obs in the dataset: • Get the details of Format from Format Library • Import Excel files into SAS • Keyboard Shortcuts • LAG function • Local vs Global macros • Lost the SAS Code, No problem…. • MDYAMPMw.d and ANYDTDTMw.d Formats • Missing Values: How To detect using Arrays • MMDDYY+: Format that inserts a slash, space or “-” between the date, month and year • New IF functions: IFC and IFN • Option Missing=’0′ • Option nofmterr; fmtsearch option • Options in SAS INFILE statement: • PROC SQL vs Datastep: • Proc STDIZE: Replace Missing Values • PRXMATCH Function • Random Sample Selection (RANUNI Function) • Renaming variables using SASHELP views • Reordering variables to be in alphabetical order • Replace missing values into zeros • Run vs Quit Statements • SAS Tip 1_Use less code • SAS Tip of the Month: Archive • SAS to SPSS • SAS Toolbar settings •
• Exporting the dataset into .csv file • File exists in the library or not • Find path & filename of executed program • Finding Number of obs in the dataset: • Get the details of Format from Format Library • How to get the program name and path • Import Excel files into SAS • Keyboard Shortcuts • LAG function • Local vs Global macros • Lost the SAS Code, No problem…. • MDY Function • MDYAMPMw.d and ANYDTDTMw.d Formats • Missing Values: How To detect using Arrays • MMDDYY+: Format that inserts a slash, space or “-” between the date, month and year • New IF functions: IFC and IFN • Option Missing=’0′ • Option nofmterr; fmtsearch option • Options in SAS INFILE statement: • PROC SQL vs Datastep: • Proc STDIZE: Replace Missing Values • PRXMATCH Function • Random Sample Selection (RANUNI Function) • Renaming variables using SASHELP views • Reordering variables to be in alphabetical order • Replace missing values into zeros • Run vs Quit Statements • SAS Tip 1_Use less code • SAS Tip of the
