Giter VIP home page Giter VIP logo

Roger DeAngelis's Projects

utl_number_of_rows_in_a_table_at_compile_time icon utl_number_of_rows_in_a_table_at_compile_time

Keywords: sas join merge big data analytics macros oracle teradata mysql sas communities stackoverflow statistics artificial inteligence AI Python R Java Javascript WPS Matlab SPSS Scala Perl C C# Excel MS Access. Number of rows in a table.

utl_ods_excel_conditionaly_higlight_individua1_cells icon utl_ods_excel_conditionaly_higlight_individua1_cells

Ods excel conditionaly higlight individua1 cells. Keywords: sas sql join merge big data analytics macros oracle teradata mysql sas communities stackoverflow statistics artificial inteligence AI Python R Java Javascript WPS Matlab SPSS Scala Perl C C# Excel MS Access JSON graphics maps NLP natural language processing machine learning igraph DOSUBL DOW loop stackoverflow SAS community.

utl_ods_excel_create_a_table_of_contents_with_links_to_and_from_each_sheet icon utl_ods_excel_create_a_table_of_contents_with_links_to_and_from_each_sheet

Ods excel create a table of contents with links to and from each sheet. Keywords: sas sql join merge big data analytics macros oracle teradata mysql sas communities stackoverflow statistics artificial inteligence AI Python R Java Javascript WPS Matlab SPSS Scala Perl C C# Excel MS Access JSON graphics maps NLP natural language processing machine learning igraph DOSUBL DOW loop stackoverflow SAS community.

utl_ods_excel_font_size_and_justification_proc_report_titles_formatting icon utl_ods_excel_font_size_and_justification_proc_report_titles_formatting

ODS excel font size and justification proc report titles formatting. Keywords: sas sql join merge big data analytics macros oracle teradata mysql sas communities stackoverflow statistics artificial inteligence AI Python R Java Javascript WPS Matlab SPSS Scala Perl C C# Excel MS Access JSON graphics maps NLP natural language processing machine learning igraph DOSUBL DOW loop stackoverflow SAS community.

utl_ods_excel_merging_cells_after_column_header_and_before_column_names icon utl_ods_excel_merging_cells_after_column_header_and_before_column_names

Ods excel merging cells after spanned column header and before column names. Keywords: sas sql join merge big data analytics macros oracle teradata mysql sas communities stackoverflow statistics artificial inteligence AI Python R Java Javascript WPS Matlab SPSS Scala Perl C C# Excel MS Access JSON graphics maps NLP natural language processing machine learning igraph DOSUBL DOW loop stackoverflow SAS community.

utl_ods_pdf_and_rtf_two_different_page_titles_on_the_same_page icon utl_ods_pdf_and_rtf_two_different_page_titles_on_the_same_page

I need two reports with different titles on the same page. If you set 'startpage=no' then multiple procedures can appear on one page, however only one title will be honored. The solution for two titles is to use 'ods text'. You also want the pdf/rtf les to align so that they both span a portrait page.

utl_operating_on_macro_arrays icon utl_operating_on_macro_arrays

Print elements of an macro array, sums, and sums of squares. Keywords: sas sql join merge big data analytics macros oracle teradata mysql sas communities stackoverflow statistics artificial inteligence AI Python R Java Javascript WPS Matlab SPSS Scala Perl C C# Excel MS Access JSON graphics maps NLP natural language processing machine learning igraph DOSUBL DOW loop stackoverfl SAS community.

utl_operating_on_three_dimensional_arrays_in_wps_base_iml_sas_iml_and_r icon utl_operating_on_three_dimensional_arrays_in_wps_base_iml_sas_iml_and_r

Operating on three dimensional arrays in wps base iml sas iml and R. Keywords: sas sql join merge big data analytics macros oracle teradata mysql sas communities stackoverflow statistics artificial inteligence AI Python R Java Javascript WPS Matlab SPSS Scala Perl C C# Excel MS Access JSON graphics maps NLP natural language processing machine learning igraph DOSUBL DOW loop stackoverflow SAS community.

utl_optlen icon utl_optlen

Reduce the size of numeric and character variables to the max observed in the data. Keywords: sas sql join merge big data analytics macros oracle teradata mysql sas communities stackoverflow statistics artificial inteligence AI Python R Java Javascript WPS Matlab SPSS Scala Perl C C# Excel MS Access JSON graphics maps NLP natural language processing.

utl_output_event_record_and_2_records_before_and_2_records_after icon utl_output_event_record_and_2_records_before_and_2_records_after

Output event record and 2 records before and 2 records after. Keywords: sas sql join merge big data analytics macros oracle teradata mysql sas communities stackoverflow statistics artificial inteligence AI Python R Java Javascript WPS Matlab SPSS Scala Perl C C# Excel MS Access JSON graphics maps NLP natural language processing machine learning igraph DOSUBL DOW loop stackoverflow SAS community.

utl_overcoming_serious_deficiencies_in_call_execute_with_dosubl icon utl_overcoming_serious_deficiencies_in_call_execute_with_dosubl

Overcoming serious deficiencies in call execute with DOSUBL. Keywords: sas sql join merge big data analytics macros oracle teradata mysql sas communities stackoverflow statistics artificial inteligence AI Python R Java Javascript WPS Matlab SPSS Scala Perl C C# Excel MS Access JSON graphics maps NLP natural language processing machine learning igraph DOSUBL DOW loop stackoverflow SAS community.

utl_parallell_processing_creating_8_subsets icon utl_parallell_processing_creating_8_subsets

Running 8 processes in parallel to subset a large dataset. Not a good example but provides the algorithm. Keywords: sas sql join merge big data analytics macros oracle teradata mysql sas communities stackoverflow statistics artificial inteligence AI Python R Java Javascript WPS Matlab SPSS Scala Perl C C# Excel MS Access JSON graphics maps NLP natural language processing machine learning.

utl_parse_full_path_to_file icon utl_parse_full_path_to_file

Given a full path extract the folder, file name and filename with extension. Four Solutions 1. macro variable 'fill_path'; 2. datastep 'full path'; 3. datastep FCMP; 4. datastep DOSUBL; Keywords: sas sql join merge big data analytics macros oracle teradata mysql sas communities stackoverflow statistics artificial inteligence AI Python R Java Javascript WPS Matlab SPSS Scala Perl C C# Excel MS Access JSON graphics maps NLP natural language processing.

utl_parsing_a_complex_nested_json_file_using_r_lists icon utl_parsing_a_complex_nested_json_file_using_r_lists

Parsing a complex nested json file using r lists. Keywords: sas sql join merge big data analytics macros oracle teradata mysql sas communities stackoverflow statistics artificial inteligence AI Python R Java Javascript WPS Matlab SPSS Scala Perl C C# Excel MS Access JSON graphics maps NLP natural language processing machine learning igraph DOSUBL DOW loop stackoverflow SAS community.

utl_parsing_proc_compare_sysinfo icon utl_parsing_proc_compare_sysinfo

Overview comparison of structure and content of two datasets(or relational tables). Keywords: sas sql join merge big data analytics macros oracle teradata mysql sas communities stackoverflow statistics artificial inteligence AI Python R Java Javascript WPS Matlab SPSS Scala Perl C C# Excel MS Access JSON graphics maps NLP natural language processing machine learning.

utl_parsing_signatures_into_components_title_first_middle_last_suffix_nickname icon utl_parsing_signatures_into_components_title_first_middle_last_suffix_nickname

SAS/Python: Parsing Signatures into components title, first, middle, last, suffix, and nickname. Keywords: sas sql join merge big data analytics macros oracle teradata mysql sas communities stackoverflow statistics artificial inteligence AI Python R Java Javascript WPS Matlab SPSS Scala Perl C C# Excel MS Access JSON.

utl_partition_a_list_of_numbers_into_3_groups_that_have_the_similar_sums_python icon utl_partition_a_list_of_numbers_into_3_groups_that_have_the_similar_sums_python

Partition a list of numbers into 3 groups that have the similar sums python. Keywords: sas sql join merge big data analytics macros oracle teradata mysql sas communities stackoverflow statistics artificial inteligence AI Python R Java Javascript WPS Matlab SPSS Scala Perl C C# Excel MS Access JSON graphics maps NLP natural language processing machine learning igraph DOSUBL DOW loop stackoverflow SAS community.

utl_partition_a_list_of_numbers_into_k_groups_that_have_the_similar_sums icon utl_partition_a_list_of_numbers_into_k_groups_that_have_the_similar_sums

Partition a list of numbers into k groups that have the same sum genetic algorithm. Keywords: sas sql join merge big data analytics macros oracle teradata mysql sas communities stackoverflow statistics artificial inteligence AI Python R Java Javascript WPS Matlab SPSS Scala Perl C C# Excel MS Access JSON graphics maps NLP natural language processing machine learning igraph DOSUBL DOW loop stackoverflow SAS community.

utl_pass_character_and_numeric_arrays_to_dosubl icon utl_pass_character_and_numeric_arrays_to_dosubl

Pass character and numeric arrays to dosubl. Keywords: sas sql join merge big data analytics macros oracle teradata mysql sas communities stackoverflow statistics artificial inteligence AI Python R Java Javascript WPS Matlab SPSS Scala Perl C C# Excel MS Access JSON graphics maps NLP natural language processing machine learning igraph DOSUBL DOW loop stackoverflow SAS community.

utl_pass_data_to_from_perl_r_python icon utl_pass_data_to_from_perl_r_python

Using the windows clipboard to pass data from SAS to and from R, Perl and Python to SAS. Keywords: sas sql join merge big data analytics macros oracle teradata mysql sas communities stackoverflow statistics artificial inteligence AI Python R Java Javascript WPS Matlab SPSS Scala Perl C C# Excel MS Access JSON graphics maps NLP natural language processing.

utl_passing_sas_macro_variables_to_r_and_retrieving_macro_variables_from_r icon utl_passing_sas_macro_variables_to_r_and_retrieving_macro_variables_from_r

Passing macro variables to R and retrieving macro variables from R. Keywords: sas sql join merge big data analytics macros oracle teradata mysql sas communities stackoverflow statistics artificial inteligence AI Python R Java Javascript WPS Matlab SPSS Scala Perl C C# Excel MS Access JSON graphics maps NLP natural language processing machine learning igraph DOSUBL DOW loop stackoverflow SAS community.

utl_passthru_to_excel_to_fix_column_names icon utl_passthru_to_excel_to_fix_column_names

Using explict passthru and MS SQL to rename problematic excel column names at the time of import to a SAS Table. Keywords: sas sql join merge big data analytics macros oracle teradata mysql sas communities stackoverflow statistics artificial inteligence AI Python R Java Javascript WPS Matlab SPSS Scala Perl C C# Excel MS Access JSON graphics maps.

utl_pdf_graphics_top_40_a_sas_ods_graphics_look_at_chicago_public_schools_salaries_by_job icon utl_pdf_graphics_top_40_a_sas_ods_graphics_look_at_chicago_public_schools_salaries_by_job

ODS Graphics look at Chicago Public Schools. Keywords: sas sql join merge big data analytics macros oracle teradata mysql sas communities stackoverflow statistics artificial inteligence AI Python R Java Javascript WPS Matlab SPSS Scala Perl C C# Excel MS Access JSON graphics maps NLP natural language processing machine learning igraph DOSUBL DOW loop stackoverflow SAS community.

utl_percent_numeric_and_character_missings_by_column icon utl_percent_numeric_and_character_missings_by_column

Percent numeric and character missings by column. Keywords: sas join merge big data analytics macros oracle teradata mysql sas communities stackoverflow statistics artificial inteligence AI Python R Java Javascript WPS Matlab SPSS Scala Perl C C# Excel MS Access.

utl_percentile_winsorizization_using_r_and_sas_or_wps icon utl_percentile_winsorizization_using_r_and_sas_or_wps

Percentile winsorization using R SAS or WPS. Keywords: sas sql join merge big data analytics macros oracle teradata mysql sas communities stackoverflow statistics artificial inteligence AI Python R Java Javascript WPS Matlab SPSS Scala Perl C C# Excel MS Access JSON graphics maps NLP natural language processing machine learning igraph DOSUBL DOW loop stackoverflow SAS community.

utl_performance_package_sas_classic_editor icon utl_performance_package_sas_classic_editor

Below are a set of command macros that can greatly increase your programming performance. I have over 20 of these performance command macros mapped to my logitech G203 5 button mouse and many more mapped to function keys, and if this in not enough the same command macros can be called with and without arguments from the SAS classic editor command line. All of SAS, R, Python and Perl can operate directly on the SAS command line or on text the in the SAS classic (1980s) editor. Python functions and code can be also be executed by mouse keys. Keywords: sas sql join merge big data analytics macros oracle teradata mysql sas communities stackoverflow statistics artificial inteligence AI Python R Java Javascript WPS Matlab SPSS Scala Perl C C# Excel MS Access JSON graphics maps NLP natural language processing.

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.