Pinned Repositories
utl-end-to-end-cdisc-SDTM-ADaM-processing
Createdefine.xml, SDTM, and ADaM expors for FDA submission
utl-formatting-ai-seacrh-output-in-pdf-rtf-and-excel-format-perplexity-chatGPT-results
Formatting AI seacrh output in pdf rtf and excel format perplexity chatGPT results
utl-general-framework-for-fitting-non-linear-equation-with-transcendental-functions-on-a-unit-square
General framework for fitting non linear equation with transcendental functions on a unit square
utl-highlite-sas-dataset-and-view-the-table-in-excel-without-sas-access
Highlite sas dataset and type xlh on command and view the table in excel without sas access
utl-mapping-clinical-terms-to-descriptions-for-a-large-number-of-vocabularies
Adapting the OHSDI-OMOP Common Data Model for Clinical Mapping
utl-reduce-your-sdtm-and-adam-mapping-effort-using-a-common-meta-data-model
Reduce your sdym and adam mapping effort using a common meta data model
utl_3500_sas_tips_collected_over_40_years
3,500_sas_tips_collected_over_40_years. 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_convert_pdf_tables_to_sas_tables
Converting tables in a pdf document to database tables. Data analytics. Machine learning. R, Python, Perl and 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_minimum_code_npct_clinical_report_with_bigN_headers
Minimum code npct clinical report with bigN headers. 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.
voodoo
SAS table profiling. Validation and Verification of Database Tables Validation and Verification of Database Tables. Profile anay SAS dataset. Cardinality, outliers, top n frequencies, bottom n frequencies, one to many, many to many, associations between numerical and character variables abd duplicates on key. 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.
rogerjdeangelis's Repositories
rogerjdeangelis/utl-macros-used-in-many-of-rogerjdeangelis-repositories
Macros used in many of rogerjdeangelis repositories. 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.
rogerjdeangelis/utl-general-framework-for-fitting-non-linear-equation-with-transcendental-functions-on-a-unit-square
General framework for fitting non linear equation with transcendental functions on a unit square
rogerjdeangelis/utl-add-sequence-numbers-to-a-sas-table-with-and-without-sas-monotonic
Add sequence numbers to a sas table with and without sas monotonic
rogerjdeangelis/utl-computing-sums-for-many-variables-by-group-and-create-an-across-sas-dataset
Create a sas dataset, not a listing, with variables and thier sums across
rogerjdeangelis/utl-count-mismatches-between-two-rows-column-by-colum-sas-r-python-sql
https://stackoverflow.com/questions/78933594/how-to-count-mismatches-between-two-rows-column-by-column
rogerjdeangelis/utl-create-a-special-synthetic-index-to-speed-up-sql-joins
For complex schemas synthetic indices can creatly simpliy and speed up joins
rogerjdeangelis/utl-create-an-animation-gif-plot-using-r-gganimate-package
Create an animation gif plot using r gganimate package
rogerjdeangelis/utl-create-primary-key-for-duplicated-records-using-sql-partitionaling-and-pivot-wide-sas-python-r
Create primary key for duplicated records using sql partitionaling and pivot wide sas python r
rogerjdeangelis/utl-forcasting-and-profiling-cumulative-sales-millions-using-bass-diffusion-non-linear-model-nlin
Forcasting and profiling cumulative sales millions using bass diffusion non linear model nlin
rogerjdeangelis/utl-importing-nhanes-data-in-raw-and-from-sqllite-database
Importing nhanes data in raw and from sqllite relational database
rogerjdeangelis/utl-incrementing-by-one-for-each-new-group-of-records-sas-r-python-sql-partitioning
Incrementing by one for each new group of records sas r python sql
rogerjdeangelis/utl-indentify-the-dose-and-dose-date-before-and-closest-to-remission-date-using-sas-r-python-sql
Indentify-the-dose-and-dose-date-before-and-closest-to-remission-date-using-sas-r-python-sql
rogerjdeangelis/utl-interplay-of-data-structures-in-sas-inteleaving-retaining-and-subsetting
Interplay of data structures in sas inteleaving retaining and subsetting
rogerjdeangelis/utl-leveraging-your-knowledge-of-sas-arrys-and-looping-to-r-and-python-multi-language
Identify which date ranges in a master contain the dates in a transaction table
rogerjdeangelis/utl-manipulating-dates-in-sas-r-and-python-sql-adding-time-periods-to-start-dates
Manipulating dates in sas r and python sql adding time periods to start dates
rogerjdeangelis/utl-output-first-n-observations-and-summarize-the-remaining-n-plus-one-observations-sql-r-python
Output first n observations and summarize the remaining n plus one observations sql sas r python
rogerjdeangelis/utl-pivoting-transposing-wide-using-sas-r-python-sql-macro-language
Pivoting transposing wider using r python and sas sql and macro variables
rogerjdeangelis/utl-plotting-significant-p-values-for-all-pairwise-treatment-comparisons-r-violin-graph
Plotting significant p values for all pairwise treatment comparisons r graph violin graph
rogerjdeangelis/utl-python-function-to-create-a-sas-dataset-using-stattransfer-and-intermediate-feather-file
Python function to create a sas dataset using stattransfer and intermediate feather file
rogerjdeangelis/utl-rle-run-length-encoding-by-groups-in-sas-and-r
Run length encoding by groups in sas and r
rogerjdeangelis/utl-set-up-a-temporary-in-memory-sqllite-database-in-r-for-added-functionality
Set up a temporary in memory sqllite database in r
rogerjdeangelis/utl-simple-clinical-survival-plot-using-r-packages-kaplan-meier-curves
https://stackoverflow.com/questions/78953666/shade-area-between-multiple-stratified-kaplan-meier-curves-in-r
rogerjdeangelis/utl-sql-partitioning-increase-in-investment-when-interest-rates-change-over-time-compound-interest
Increase in investment when interest rates change over time compounding interest
rogerjdeangelis/utl-stack-pairs-of-columns-with-the-same-id-and-visit-sas-r-python
Stack pairs of columns with the same id and visit sas r python
rogerjdeangelis/utl-sum-col1-distinct-levels-col2-and-count-col3-by-col3-using-sql-in-sas-r-and-python
Sum col1 distinct levels col2 and count col3 by col3 using sql in sas r and python
rogerjdeangelis/utl-tidy-up-a-messy-text-file-holding-input-records
Tidy up a messy text file holding input records
rogerjdeangelis/utl-time-series-change-in-university-enrollment-by-year-and-by-year-department-proc-corresp
Calculating the enrollment change throughout the years for each University by Year and by year and department
rogerjdeangelis/utl-transpose-table-creating-column-names-from-input-table-rownames-sas-sql-r-pyhon-multi-language
Transpose table creating column names from input table rownames sas sql r pyhon multi language
rogerjdeangelis/utl-visualization-of-a-decision-tree-with-horizontal-bar-charts-graphics-diagram
Visualization of a decision tree with horizontal bar charts graphics
rogerjdeangelis/utl-when-first-ob-of-group-is-not-missing-fill-in--missings-in-that-group-with-zeros-multi-language
When first ob of a group is not missing fill in all missings in that group with zeros