1 /* region: Generated preamble */ 2 /* Make sure the current directory is writable */ 3 data _null_; 4 length rc 4; 5 %let tworkloc="%sysfunc(getoption(work))"; 6 rc=dlgcdir(&tworkloc); 7 run; NOTE: The current working directory is now "/opt/sas/viya/config/var/tmp/compsrv/default/64671b88-48d6-47fd-9483-72eb0df401e5/SAS_work6AF400000164_sas-compute-server-8c3 afca6-1742-41a7-b6cb-e4105054cee3-75081". NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 8 9 /* Setup options */ 10 title; 11 footnote; 12 options validvarname=any; 13 options validmemname=extend; 14 options dtreset date number; 15 options device=png; 16 17 /* Setup macro variables */ 18 %let syscc=0; 19 %let _clientapp = %nrquote(%nrstr(SAS Studio)); 20 %let _clientappabbrev = %nrquote(%nrstr(Studio)); 21 %let _clientappversion=2026.03; 22 %let _clientversion=; 23 %let _sasservername=&SYSHOSTNAME; 24 %let _sashostname=&SYSHOSTNAME; 25 %let _sasprogramfilehost=&SYSHOSTNAME; 26 %let _clientuserid = %nrquote(%nrstr(adriana.vieira@iesb.edu.br)); 27 %let _clientusername = %nrquote(%nrstr(adriana.vieira@iesb.edu.br)); 28 %let clientmachine = %nrquote(%nrstr()); 29 %let _clientmachine = %nrquote(%nrstr()); 30 %let _clientmode = %nrquote(%nrstr(viya)); 31 %let sasworklocation="%sysfunc(getoption(work))/"; 32 filename _cwd &sasworklocation; 33 data _null_; 34 call symput('_sasworkingdir',pathname('_cwd')); 35 run; NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds 36 filename _cwd; NOTE: Fileref _CWD has been deassigned. 37 %let _sasprogramfile = %nrquote(%nrstr(sascontent:/files/files/b2944753-7893-4bf6-b88c-0f9c0f4ecfb1)); 38 %let _baseurl = %nrquote(%nrstr(https://vfl-025.engage.sas.com/SASStudio)); 39 %let _execenv = %nrquote(%nrstr(SASStudio)); 40 %symdel _dataout_mime_type _dataout_name _dataout_url _dataout_table / nowarn; 41 %let _sasws_ = %bquote(%sysfunc(getoption(work))); 42 %let _saswstemp_ = %bquote(%sysfunc(getoption(work))); 43 44 /* Detect SAS/Graph and setup graph options */ 45 data _null_; 46 length rc $255; 47 call symput("graphinit",""); 48 call symput("graphterm",""); 49 rc=tslvl('sasxgopt','n'); 50 _error_=0; 51 if (rc^=' ') then do; 52 call symput("graphinit","goptions reset=all gsfname=_gsfname;"); 53 call symput("graphterm","goptions noaccessible;"); 54 end; 55 run; NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 56 data _null_; 57 length rc 4; 58 rc=sysprod("PRODNUM002"); 59 if (rc^=1) then do; 60 call symput("graphinit",""); 61 call symput("graphterm",""); 62 end; 63 run; NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 64 65 /* Setup ODS destinations */ 66 ods _all_ close; 67 %studio_results_directory; 68 filename _htmlout "&_results_prefix_..html"; 69 filename _listout "&_results_prefix_..lst"; 70 filename _gsfname temp; 71 filename _dataout "&_results_prefix_..dat"; 72 ods autonavigate off; 73 ods graphics on; 74 ods html5 (id=web) METATEXT='http-equiv="Content-Security-Policy" content="default-src ''none''; style-src ''unsafe-inline''; 74 ! img-src data: ;"' device=png gpath="&_saswstemp_" path="&_saswstemp_" encoding=utf8 file=_htmlout (title='Results:Resultado 74 ! Amostra Final 325 analise descritiva P9 P11 P12.sas') style=Light2025 options(bitmap_mode='inline' outline='on' 74 ! svg_mode='inline' css_prefix=".ods_&SYS_COMPUTE_JOB_ID" body_id="div_&SYS_COMPUTE_JOB_ID" ); NOTE: Writing HTML5(WEB) Body file: _HTMLOUT 75 ods listing file=_listout; 76 &graphinit; 77 %studio_initialize_custom_output; 78 /* endregion */ 79 80 /* ===================================================================== 81 1. INICIALIZAÇÃO DO AMBIENTE E CONEXÃO COM A CASUSER 82 ===================================================================== */ 83 cas _all_ terminate; NOTE: Libref MYCAS has been deassigned. NOTE: Libref YVA2 has been deassigned. NOTE: Libref YVA1 has been deassigned. NOTE: Libref VISUAL has been deassigned. NOTE: Libref VFSP has been deassigned. NOTE: Libref VDMO has been deassigned. NOTE: Libref VBBF has been deassigned. NOTE: Libref TUNDATA has been deassigned. NOTE: Libref TSFM has been deassigned. NOTE: Libref SAMPLES has been deassigned. NOTE: Libref SVTA has been deassigned. NOTE: Libref SVSO has been deassigned. NOTE: Libref ROSI has been deassigned. NOTE: Libref PUBLIC has been deassigned. NOTE: Libref POSI has been deassigned. NOTE: Libref PIVY has been deassigned. NOTE: Libref ORVY has been deassigned. NOTE: Libref MODELS has been deassigned. NOTE: Libref INTN has been deassigned. NOTE: Libref HELPDATA has been deassigned. NOTE: Libref GAVA85 has been deassigned. NOTE: Libref GAINDS has been deassigned. NOTE: Libref FORMATS has been deassigned. NOTE: Libref FVVF has been deassigned. NOTE: Libref CRVA83 has been deassigned. NOTE: Libref CPML has been deassigned. NOTE: Libref CORTEXFR has been deassigned. NOTE: Libref CASUSER has been deassigned. NOTE: Libref ADML has been deassigned. NOTE: Libref ACADEMIC has been deassigned. NOTE: Deletion of the session MYSESS was successful. NOTE: Request to TERMINATE completed for session MYSESS. 84 cas mysess; NOTE: The session MYSESS connected successfully to Cloud Analytic Services sas-cas-server-default-client using port 5570. The UUID is 2e255442-e048-ff4d-bc18-53f1795164e9. The user is adriana.vieira@iesb.edu.br and the active caslib is CASUSER(adriana.vieira@iesb.edu.br). NOTE: The SAS option SESSREF was updated with the value MYSESS. NOTE: The SAS macro _SESSREF_ was updated with the value MYSESS. NOTE: The session is using 0 workers. 85 caslib _all_ assign; NOTE: A SAS Library associated with a caslib can only reference library member names that conform to SAS Library naming conventions. NOTE: CASLIB ACADEMIC for session MYSESS will be mapped to SAS Library ACADEMIC. NOTE: CASLIB ADML for session MYSESS will be mapped to SAS Library ADML. NOTE: CASLIB CASUSER(adriana.vieira@iesb.edu.br) for session MYSESS will be mapped to SAS Library CASUSER. NOTE: CASLIB CORTEXfr for session MYSESS will be mapped to SAS Library CORTEXFR. NOTE: CASLIB CPML for session MYSESS will be mapped to SAS Library CPML. NOTE: CASLIB CRVA83 for session MYSESS will be mapped to SAS Library CRVA83. NOTE: CASLIB FVVF for session MYSESS will be mapped to SAS Library FVVF. NOTE: CASLIB Formats for session MYSESS will be mapped to SAS Library FORMATS. NOTE: CASLIB GAINDS for session MYSESS will be mapped to SAS Library GAINDS. NOTE: CASLIB GAVA85 for session MYSESS will be mapped to SAS Library GAVA85. NOTE: CASLIB HELPDATA for session MYSESS will be mapped to SAS Library HELPDATA. NOTE: CASLIB INTN for session MYSESS will be mapped to SAS Library INTN. NOTE: CASLIB ModelPerformanceData for session MYSESS will not be mapped to SAS Library ModelPerformanceData. The CASLIB name is not valid for use as a libref. NOTE: CASLIB Models for session MYSESS will be mapped to SAS Library MODELS. NOTE: CASLIB ORVY for session MYSESS will be mapped to SAS Library ORVY. NOTE: CASLIB PIVY for session MYSESS will be mapped to SAS Library PIVY. NOTE: CASLIB POSI for session MYSESS will be mapped to SAS Library POSI. NOTE: CASLIB Public for session MYSESS will be mapped to SAS Library PUBLIC. NOTE: CASLIB ROSI for session MYSESS will be mapped to SAS Library ROSI. NOTE: CASLIB SVSO for session MYSESS will be mapped to SAS Library SVSO. NOTE: CASLIB SVTA for session MYSESS will be mapped to SAS Library SVTA. NOTE: CASLIB Samples for session MYSESS will be mapped to SAS Library SAMPLES. NOTE: CASLIB TSFM for session MYSESS will be mapped to SAS Library TSFM. NOTE: CASLIB TUNDATA for session MYSESS will be mapped to SAS Library TUNDATA. NOTE: CASLIB VBBF for session MYSESS will be mapped to SAS Library VBBF. NOTE: CASLIB VDMO for session MYSESS will be mapped to SAS Library VDMO. NOTE: CASLIB VFSP for session MYSESS will be mapped to SAS Library VFSP. NOTE: CASLIB VISUAL for session MYSESS will be mapped to SAS Library VISUAL. NOTE: CASLIB YVA1 for session MYSESS will be mapped to SAS Library YVA1. NOTE: CASLIB YVA2 for session MYSESS will be mapped to SAS Library YVA2. 86 libname mycas cas caslib="CASUSER"; NOTE: Libref MYCAS was successfully assigned as follows: Engine: CAS Physical Name: 2e255442-e048-ff4d-bc18-53f1795164e9 87 88 proc casutil; NOTE: The UUID '2e255442-e048-ff4d-bc18-53f1795164e9' is connected using session MYSESS. 89 load casdata="RESULAMOSTRAFINAL.sashdat" 90 incaslib="CASUSER(adriana.vieira@iesb.edu.br)" 91 outcaslib="CASUSER(adriana.vieira@iesb.edu.br)" 92 casout="RESULAMOSTRAFINAL" 93 replace; WARNING: The table RESULAMOSTRAFINAL exists as a global table in caslib CASUSER(adriana.vieira@iesb.edu.br). By adding a session table with the same name, the session-scope table takes precedence over the global-scope table. NOTE: Cloud Analytic Services made the file RESULAMOSTRAFINAL.sashdat available as table RESULAMOSTRAFINAL in caslib CASUSER(adriana.vieira@iesb.edu.br). NOTE: The Cloud Analytic Services server processed the request in 0.001626 seconds. 94 quit; NOTE: PROCEDURE CASUTIL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 95 96 /* ===================================================================== 97 2. VERIFICAÇÃO RÁPIDA — o texto bruto do SAS bate com a planilha? 98 ===================================================================== */ 99 proc print data=mycas.RESULAMOSTRAFINAL (obs=10); 100 var P8 P9 P10 P11 P12; 101 run; WARNING: Data too long for column "P11"; truncated to 128 characters to fit. NOTE: The PROCEDURE PRINT printed page 11. NOTE: PROCEDURE PRINT used (Total process time): real time 0.04 seconds cpu time 0.03 seconds 102 103 /* ===================================================================== 104 3. BASE DE USUÁRIOS ATIVOS + INDICADORES P9, P11 E P12 105 (CORRIGIDO: mantém os espaços; remove apenas acentos) 106 ===================================================================== */ 107 data tabela_p91112; 108 set mycas.RESULAMOSTRAFINAL; 109 where not missing(P9); /* usuários ativos (n = 194) */ 110 111 /* Normalização: maiúsculas + acentos removidos (comprimentos iguais) */ 112 _p9 = upcase(strip(P9)); 113 _p9 = translate(_p9, "AAAAEEIOOOUUC", "ÁÀÃÂÉÊÍÓÔÕÚÛÇ"); 114 _p9s = compress(_p9, " -"); /* SÓ para ChatJT/NotebookLM */ NOTE: Variable "_p9s" was given a default length of 32767 as the result of a function call. If you do not like this, please use a LENGTH statement to declare "_p9s". 115 _p11 = upcase(strip(P11)); 116 _p11 = translate(_p11, "AAAAEEIOOOUUC", "ÁÀÃÂÉÊÍÓÔÕÚÛÇ"); 117 118 /* ---- P9: MODELOS (com espaços preservados) ---- */ 119 f_chatgpt = find(_p9, "CHATGPT") > 0; 120 f_gemini = find(_p9, "GEMINI") > 0; 121 f_claude = find(_p9, "CLAUDE") > 0; 122 f_copilot = find(_p9, "MICROSOFT COPILOT") > 0; /* AGORA FUNCIONA */ 123 f_chatjt = find(_p9s, "CHATJT") > 0; /* Chat-JT, CHAT JT */ 124 f_notebooklm = find(_p9s, "NOTEBOOKLM") > 0; /* Notebook LM */ 125 f_perplexity = find(_p9, "PERPLEX") > 0; 126 f_gamma = find(_p9, "GAMMA") > 0; 127 f_deepseek = find(_p9, "DEEPSEEK") > 0; 128 f_outros = find(_p9, "MANUS") > 0 129 or find(_p9, "QWEN") > 0 130 or find(_p9, "BLACKBOX") > 0 131 or find(_p9, "SCISPACE") > 0 132 or find(_p9, "CONSENSUS") > 0 133 or find(_p9, "GITHUB") > 0 /* GitHub Copilot */ 134 or find(_p9, "MODO IA") > 0 /* AGORA FUNCIONA */ 135 or find(_p9, "IA JT") > 0 /* AGORA FUNCIONA */ 136 or find(_p9, "I.A. DO PJE") > 0 /* AGORA FUNCIONA */ 137 or strip(_p9) eq "JT"; 138 139 /* ---- P11: FINALIDADES (frases exatas, com espaços) ---- */ 140 f_redacao = find(_p11, "REDACAO") > 0; 141 f_pesquisa = find(_p11, "PESQUISA E BUSCA") > 0; 142 f_sintese = find(_p11, "SINTESE") > 0; 143 f_explic = find(_p11, "EXPLICACOES") > 0; 144 f_ideias = find(_p11, "GERACAO DE IDEIAS") > 0 145 or find(_p11, "BRAINSTORMING") > 0; 146 f_organiz = find(_p11, "ORGANIZACAO") > 0; 147 f_dados = find(_p11, "ANALISE DE DADOS") > 0; 148 f_repetitiva = find(_p11, "REPETITIVAS") > 0; 149 f_consultas = find(_p11, "CONSULTAS") > 0; 150 f_decisao = find(_p11, "TOMADA DE DECISAO") > 0; 151 f_fluxos = find(_p11, "FLUXOS") > 0 152 or find(_p11, "ROTEIROS") > 0 153 or find(_p11, "PLANOS DE TRABALHO") > 0; 154 f_traducao = find(_p11, "TRADUCAO") > 0; 155 f_codigo = find(_p11, "CODIFICA") > 0 156 or find(_p11, "PROGRAMA") > 0 157 or find(_p11, "POWERSHELL") > 0 158 or find(_p11, "SCRIPTS") > 0 159 or find(_p11, "SQL") > 0 160 or find(_p11, "PYTHON") > 0 161 or find(_p11, "APLICACOES") > 0 162 or find(_p11, "CODIGOS") > 0 163 or find(_p11, "DESENVOLVIMENTO") > 0; 164 f_outras = find(_p11, "APRESENTA") > 0 165 or find(_p11, "SLIDES") > 0 166 or find(_p11, "IMAGEM") > 0 167 or find(_p11, "EXAMES") > 0 168 or find(_p11, "SEGURANCA") > 0 169 or find(_p11, "VULNERABILIDADE") > 0 170 or find(_p11, "PLANILHAS") > 0 171 or find(_p11, "DIAGNOSTICO") > 0 172 or find(_p11, "TELAS") > 0; 173 174 keep P9 P11 P12 f_:; 175 label P9 = "Ferramentas de IAGen utilizadas" 176 P11 = "Finalidades de uso da IAGen" 177 P12 = "Tempo de experiência com o uso de IAGen"; 178 run; NOTE: One or more variables were converted because the data type is not supported by the V9 engine. For more details, run with options MSGLEVEL=I. NOTE: There were 194 observations read from the data set MYCAS.RESULAMOSTRAFINAL. WHERE not MISSING(P9); NOTE: The data set WORK.TABELA_P91112 has 194 observations and 27 variables. NOTE: DATA statement used (Total process time): real time 0.23 seconds cpu time 0.22 seconds 179 180 proc sql noprint; 181 select count(*) into :n_atv from tabela_p91112; 182 quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 183 %put ==== ATENCAO: Total de usuarios ativos = &n_atv. ====; ==== ATENCAO: Total de usuarios ativos = 194 ==== 184 185 /* ===================================================================== 186 4. TABELA P9 (1 linha por modelo citado) 187 ===================================================================== */ 188 data p9_long; 189 set tabela_p91112; 190 length Categoria $60; 191 if f_chatgpt then do; Categoria = "ChatGPT"; output; end; 192 if f_gemini then do; Categoria = "Google Gemini"; output; end; 193 if f_claude then do; Categoria = "Claude"; output; end; 194 if f_copilot then do; Categoria = "Microsoft Copilot"; output; end; 195 if f_chatjt then do; Categoria = "ChatJT"; output; end; 196 if f_notebooklm then do; Categoria = "NotebookLM"; output; end; 197 if f_perplexity then do; Categoria = "Perplexity"; output; end; 198 if f_gamma then do; Categoria = "Gamma"; output; end; 199 if f_deepseek then do; Categoria = "DeepSeek"; output; end; 200 if f_outros then do; Categoria = "Outros modelos"; output; end; 201 keep Categoria; 202 run; NOTE: There were 194 observations read from the data set WORK.TABELA_P91112. NOTE: The data set WORK.P9_LONG has 361 observations and 1 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 203 204 proc sql; 205 create table tab_p9 as 206 select Categoria, 207 count(*) as Count, 208 round(count(*) / &n_atv. * 100, 0.01) as pct 209 from p9_long 210 group by Categoria 211 order by Count desc; NOTE: Table WORK.TAB_P9 created, with 10 rows and 3 columns. 212 quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.01 seconds 213 214 title "Tabela P9 - Modelos de IA Generativa utilizados (n = &n_atv.)"; 215 proc print data=tab_p9 noobs label; 216 var Categoria Count pct; 217 format pct 6.2; 218 run; NOTE: There were 10 observations read from the data set WORK.TAB_P9. NOTE: The PROCEDURE PRINT printed page 12. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.02 seconds 219 220 /* ===================================================================== 221 5. TABELA P11 (1 linha por finalidade citada) 222 ===================================================================== */ 223 data p11_long; 224 set tabela_p91112; 225 length Categoria $60; 226 if f_redacao then do; Categoria = "Redação e revisão de textos"; output; end; 227 if f_pesquisa then do; Categoria = "Pesquisa e busca de conteúdo"; output; end; 228 if f_sintese then do; Categoria = "Síntese de informações/resumos"; output; end; 229 if f_explic then do; Categoria = "Explicações de conceitos"; output; end; 230 if f_ideias then do; Categoria = "Geração de ideias/brainstorming"; output; end; 231 if f_organiz then do; Categoria = "Organização e estruturação de documentos"; output; end; 232 if f_dados then do; Categoria = "Apoio à análise de dados"; output; end; 233 if f_repetitiva then do; Categoria = "Suporte em atividades repetitivas"; output; end; 234 if f_consultas then do; Categoria = "Elaboração de consultas/prompts"; output; end; 235 if f_decisao then do; Categoria = "Apoio à tomada de decisão"; output; end; 236 if f_fluxos then do; Categoria = "Criação de fluxos, roteiros ou planos"; output; end; 237 if f_traducao then do; Categoria = "Tradução de textos"; output; end; 238 if f_codigo then do; Categoria = "Codificação/programação"; output; end; 239 if f_outras then do; Categoria = "Outras finalidades"; output; end; 240 keep Categoria; 241 run; NOTE: There were 194 observations read from the data set WORK.TABELA_P91112. NOTE: The data set WORK.P11_LONG has 293 observations and 1 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 242 243 proc sql; 244 create table tab_p11 as 245 select Categoria, 246 count(*) as Count, 247 round(count(*) / &n_atv. * 100, 0.01) as pct 248 from p11_long 249 group by Categoria 250 order by Count desc; NOTE: Table WORK.TAB_P11 created, with 7 rows and 3 columns. 251 quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 252 253 title "Tabela P11 - Finalidades de uso da IA Generativa (n = &n_atv.)"; 254 proc print data=tab_p11 noobs label; 255 var Categoria Count pct; 256 format pct 6.2; 257 run; NOTE: There were 7 observations read from the data set WORK.TAB_P11. NOTE: The PROCEDURE PRINT printed page 13. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.01 seconds 258 259 /* ===================================================================== 260 6. TABELA P12 (resposta única) 261 ===================================================================== */ 262 title "Tabela P12 - Tempo de experiência com IAGen (n = &n_atv.)"; 263 proc freq data=tabela_p91112 order=freq; 264 tables P12 / nocum missing; 265 run; NOTE: There were 194 observations read from the data set WORK.TABELA_P91112. NOTE: The PROCEDURE FREQ printed page 14. NOTE: PROCEDURE FREQ used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 266 267 title; 268 269 /* region: Generated postamble */ 270 /* Error recovery */ 271 %studio_error_recovery; 272 /* Close ODS destinations */ 273 &graphterm; ;*';*";*/;run;quit; 274 quit;run; 275 ods html5 (id=web) close; 276 ods listing close; 277 %if %sysfunc(fileref(_gsfname)) lt 0 %then %do; 278 filename _gsfname clear; NOTE: Fileref _GSFNAME has been deassigned. 279 %end; 280 %studio_capture_custom_output; 281 /* endregion */ 282