I managed to import the dataset manually specifying the dictionary in the command. However, when I try to automate the code calling for the dictionary it does not work.
Code:
. cd "C:\Users\Paula\Dropbox\Pesquisa\DADOS\DATASUS\auxiliares\SIA_SIH_SIGTAP\SIGTAP_2008+\TabelaUnificada_200801" C:\Users\Paula\Dropbox\Pesquisa\DADOS\DATASUS\auxiliares\SIA_SIH_SIGTAP\SIGTAP_2008+\TabelaUnificada_200801 . . infix str cod_proc 1-10 str nom_proc 11-260 str complex 261-261 str sex 262-262 /// > str max_exe 263-266 str qt_dias 267-270 str qt_pts 271-274 str idade_max 275-278 /// > str idade_min 279-282 str vl_sh 283-292 str vl_sa 293-302 str vl_sp 303-312 /// > str financ 313-314 str rubr 315-320 str anomes 321-326 using /// > "tb_procedimento.txt", clear (4,190 observations read) . . infix using "tb_procedimento_layout.txt", using ("tb_procedimento.txt") clear Coluna,Tamanho,Inicio,Fim,Tipo file does not contain dictionary r(613); end of do-file r(613); .
Code:
. infile using "tb_procedimento_layout.txt", using ("tb_procedimento.txt") clear Coluna,Tamanho,Inicio,Fim,Tipo file does not contain dictionary r(613); end of do-file r(613); .
Code:
Coluna,Tamanho,Inicio,Fim,Tipo CO_PROCEDIMENTO,10,1,10,VARCHAR2 NO_PROCEDIMENTO,250,11,260,VARCHAR2 TP_COMPLEXIDADE,1,261,261,VARCHAR2 TP_SEXO,1,262,262,VARCHAR2 QT_MAXIMA_EXECUCAO,4,263,266,NUMBER QT_DIAS_PERMANENCIA,4,267,270,NUMBER QT_PONTOS,4,271,274,NUMBER VL_IDADE_MINIMA,4,275,278,NUMBER VL_IDADE_MAXIMA,4,279,282,NUMBER VL_SH,10,283,292,NUMBER VL_SA,10,293,302,NUMBER VL_SP,10,303,312,NUMBER CO_FINANCIAMENTO,2,313,314,VARCHAR2 CO_RUBRICA,6,315,320,VARCHAR2 DT_COMPETENCIA,6,321,326,DATE
0 Response to infix and infile commands not recognizing dictionary
Post a Comment