217.ANALYZING GLOBAL ARTIFICIAL INTELLIGENCE SYSTEMS USING PROC SQL AND MACROS IN SAS ACROSS INDUSTRIES APPLICATIONS CAPABILITIES RELEASE COUNTRIES AND INNOVATORS
ANALYZING GLOBAL ARTIFICIAL INTELLIGENCE SYSTEMS USING PROC SQL AND MACROS IN SAS ACROSS INDUSTRIES APPLICATIONS CAPABILITIES RELEASE COUNTRIES AND INNOVATORS
/*A unique dataset about AIs used worldwide*/
STEP 1: CREATING THE DATASET
data ai_systems;
length AI_ID 8 Name $30 Developer $25 Country $15 Year_Released 8 Sector $25
Capability $60;
infile datalines dsd dlm=' ';
input AI_ID Name :$30. Developer :$25. Country :$15. Year_Released Sector :$25.
Capability :$60.;
datalines;
1 ChatGPT OpenAI USA 2022 "Conversational NLP" "Conversational AI, Code, Reasoning"
2 Gemini Google USA 2023 "Conversational NLP" "Multimodal Input, Research Assistant"
3 Watson IBM USA 2011 Healthcare "Diagnostics, Oncology, QA System"
4 Alexa Amazon USA 2014 "Smart Home" "Voice Assistant, IoT Integration"
5 Siri Apple USA 2011 Smartphones "Voice Assistant, Task Management"
6 Bard Google USA 2023 Research "Text Generation, Summarization"
7 Sophia HansonRobotics HongKong 2016 Robotics "Facial Recognition, Speech, Emotions"
8 AlphaGo DeepMind UK 2016 Games "Go Master, Reinforcement Learning"
9 AlphaFold DeepMind UK 2020 Biotech "Protein Structure Prediction"
10 ErnieBot Baidu China 2023 "Conversational NLP" "Multilingual LLM"
11 PaLM Google USA 2022 "Language Modeling" "Translation, Dialogue"
12 Claude Anthropic USA 2023 "Ethical NLP" "AI Alignment, Safety-focused"
13 Mistral MistralAI France 2023 "Open-Source LLM" "Efficient Transformer-based AI"
14 LLaMA Meta USA 2023 "Language Modeling" "Research-grade Transformer LLM"
15 JARVIS NVIDIA USA 2021 "AI Platform" "Conversational AI, Speech AI Toolkit"
16 WatsonX IBM USA 2023 "Enterprise LLM" "Model Training, Tuning, Deployment"
17 DeepFace Meta USA 2014 "Facial Recognition" "Face Verification at Scale"
18 TeslaBot Tesla USA 2023 Robotics "Humanoid Robot, Household Tasks"
19 DeepL DeepL Germany 2017 Translation "Language Translation, Context Aware"
20 Replika "Luka Inc." USA 2017 "Mental Health" "AI Companion, Emotional Support"
;
run;
proc print data=ai_systems noobs;
run;
Output:
| Number of AI Systems by Sector |
| AI_ID | Name | Developer | Country | Year_Released | Sector | Capability |
|---|---|---|---|---|---|---|
| 1 | ChatGPT | OpenAI | USA | 2022 | Conversational NLP | Conversational AI, Code, Reasoning |
| 2 | Gemini | USA | 2023 | Conversational NLP | Multimodal Input, Research Assistant | |
| 3 | Watson | IBM | USA | 2011 | Healthcare | Diagnostics, Oncology, QA System |
| 4 | Alexa | Amazon | USA | 2014 | Smart Home | Voice Assistant, IoT Integration |
| 5 | Siri | Apple | USA | 2011 | Smartphones | Voice Assistant, Task Management |
| 6 | Bard | USA | 2023 | Research | Text Generation, Summarization | |
| 7 | Sophia | HansonRobotics | HongKong | 2016 | Robotics | Facial Recognition, Speech, Emotions |
| 8 | AlphaGo | DeepMind | UK | 2016 | Games | Go Master, Reinforcement Learning |
| 9 | AlphaFold | DeepMind | UK | 2020 | Biotech | Protein Structure Prediction |
| 10 | ErnieBot | Baidu | China | 2023 | Conversational NLP | Multilingual LLM |
| 11 | PaLM | USA | 2022 | Language Modeling | Translation, Dialogue | |
| 12 | Claude | Anthropic | USA | 2023 | Ethical NLP | AI Alignment, Safety-focused |
| 13 | Mistral | MistralAI | France | 2023 | Open-Source LLM | Efficient Transformer-based AI |
| 14 | LLaMA | Meta | USA | 2023 | Language Modeling | Research-grade Transformer LLM |
| 15 | JARVIS | NVIDIA | USA | 2021 | AI Platform | Conversational AI, Speech AI Toolkit |
| 16 | WatsonX | IBM | USA | 2023 | Enterprise LLM | Model Training, Tuning, Deployment |
| 17 | DeepFace | Meta | USA | 2014 | Facial Recognition | Face Verification at Scale |
| 18 | TeslaBot | Tesla | USA | 2023 | Robotics | Humanoid Robot, Household Tasks |
| 19 | DeepL | DeepL | Germany | 2017 | Translation | Language Translation, Context Aware |
| 20 | Replika | Luka Inc. | USA | 2017 | Mental Health | AI Companion, Emotional Support |
STEP 2: ANALYSIS USING ONLY PROC SQL and MACROS
Macro 1: List All AI Systems by Country
%macro list_by_country(cntry);
proc sql;
title "AI Systems Developed in &cntry";
select Name, Developer, Sector, Capability
from ai_systems
where Country = "&cntry";
quit;
%mend;
%list_by_country(USA);
Output:
| AI Systems Developed in USA |
| Name | Developer | Sector | Capability |
|---|---|---|---|
| ChatGPT | OpenAI | Conversational NLP | Conversational AI, Code, Reasoning |
| Gemini | Conversational NLP | Multimodal Input, Research Assistant | |
| Watson | IBM | Healthcare | Diagnostics, Oncology, QA System |
| Alexa | Amazon | Smart Home | Voice Assistant, IoT Integration |
| Siri | Apple | Smartphones | Voice Assistant, Task Management |
| Bard | Research | Text Generation, Summarization | |
| PaLM | Language Modeling | Translation, Dialogue | |
| Claude | Anthropic | Ethical NLP | AI Alignment, Safety-focused |
| LLaMA | Meta | Language Modeling | Research-grade Transformer LLM |
| JARVIS | NVIDIA | AI Platform | Conversational AI, Speech AI Toolkit |
| WatsonX | IBM | Enterprise LLM | Model Training, Tuning, Deployment |
| DeepFace | Meta | Facial Recognition | Face Verification at Scale |
| TeslaBot | Tesla | Robotics | Humanoid Robot, Household Tasks |
| Replika | Luka Inc. | Mental Health | AI Companion, Emotional Support |
%list_by_country(UK);
Output:
| AI Systems Developed in UK |
| Name | Developer | Sector | Capability |
|---|---|---|---|
| AlphaGo | DeepMind | Games | Go Master, Reinforcement Learning |
| AlphaFold | DeepMind | Biotech | Protein Structure Prediction |
%list_by_country(China);
Output:
| AI Systems Developed in China |
| Name | Developer | Sector | Capability |
|---|---|---|---|
| ErnieBot | Baidu | Conversational NLP | Multilingual LLM |
Macro 2: Group AI Systems by Sector and Count
%macro count_by_sector;
proc sql;
title "Number of AI Systems by Sector";
select Sector, count(*) as Total_AI
from ai_systems
group by Sector;
quit;
%mend;
%count_by_sector;
Output:
| Number of AI Systems by Sector |
| Sector | Total_AI |
|---|---|
| AI Platform | 1 |
| Biotech | 1 |
| Conversational NLP | 3 |
| Enterprise LLM | 1 |
| Ethical NLP | 1 |
| Facial Recognition | 1 |
| Games | 1 |
| Healthcare | 1 |
| Language Modeling | 2 |
| Mental Health | 1 |
| Open-Source LLM | 1 |
| Research | 1 |
| Robotics | 2 |
| Smart Home | 1 |
| Smartphones | 1 |
| Translation | 1 |
Macro 3: Filter Systems Released After a Given Year
%macro filter_by_year(year);
proc sql;
title "AI Systems Released After &year";
select Name, Developer, Year_Released, Country
from ai_systems
where Year_Released > &year
order by Year_Released;
quit;
%mend;
%filter_by_year(2020);
Output:
| AI Systems Released After 2020 |
| Name | Developer | Year_Released | Country |
|---|---|---|---|
| JARVIS | NVIDIA | 2021 | USA |
| PaLM | 2022 | USA | |
| ChatGPT | OpenAI | 2022 | USA |
| Mistral | MistralAI | 2023 | France |
| Bard | 2023 | USA | |
| Claude | Anthropic | 2023 | USA |
| WatsonX | IBM | 2023 | USA |
| TeslaBot | Tesla | 2023 | USA |
| Gemini | 2023 | USA | |
| ErnieBot | Baidu | 2023 | China |
| LLaMA | Meta | 2023 | USA |
Macro 4: Count AI Developers per Country
%macro dev_count_by_country;
proc sql;
title "Number of AI Developers by Country";
select Country, count(distinct Developer) as Unique_Developers
from ai_systems
group by Country;
quit;
%mend;
%dev_count_by_country;
Output:
| Number of AI Developers by Country |
| Country | Unique_Developers |
|---|---|
| China | 1 |
| France | 1 |
| Germany | 1 |
| HongKong | 1 |
| UK | 1 |
| USA | 10 |
Macro 5: Identify Multimodal or Specialized AI
%macro multimodal_specialized(keyword);
proc sql;
title "AI Systems with &keyword Capabilities";
select Name, Developer, Capability
from ai_systems
where Capability contains "&keyword";
quit;
%mend;
%multimodal_specialized(Multimodal);
Output:
| AI Systems with Multimodal Capabilities |
| Name | Developer | Capability |
|---|---|---|
| Gemini | Multimodal Input, Research Assistant |
%multimodal_specialized(Robot);
Output:
| AI Systems with Robot Capabilities |
| Name | Developer | Capability |
|---|---|---|
| TeslaBot | Tesla | Humanoid Robot, Household Tasks |
%multimodal_specialized(Translation);
Output:
| AI Systems with Translation Capabilities |
| Name | Developer | Capability |
|---|---|---|
| PaLM | Translation, Dialogue | |
| DeepL | DeepL | Language Translation, Context Aware |
STEP 3: SQL Analysis Without Macros
SQL 1: Total AI Systems by Country
proc sql;
title "Total AI Systems by Country";
select Country, count(*) as AI_Count
from ai_systems
group by Country
order by AI_Count desc;
quit;
Output:
| Total AI Systems by Country |
| Country | AI_Count |
|---|---|
| USA | 14 |
| UK | 2 |
| Germany | 1 |
| China | 1 |
| France | 1 |
| HongKong | 1 |
SQL 2: Sector-wise Distribution of AI
proc sql;
title "Sector-wise AI System Distribution";
select Sector, count(*) as Num_Projects
from ai_systems
group by Sector
order by Num_Projects desc;
quit;
Output:
| Sector-wise AI System Distribution |
| Sector | Num_Projects |
|---|---|
| Conversational NLP | 3 |
| Language Modeling | 2 |
| Robotics | 2 |
| Smart Home | 1 |
| Facial Recognition | 1 |
| Research | 1 |
| Open-Source LLM | 1 |
| Ethical NLP | 1 |
| Mental Health | 1 |
| Games | 1 |
| Smartphones | 1 |
| AI Platform | 1 |
| Biotech | 1 |
| Enterprise LLM | 1 |
| Healthcare | 1 |
| Translation | 1 |
Comments
Post a Comment