Hello, this is Fuka-japan. I would like to perform analysis using the data merged by IEA IDB analyzer. However, when I load the generated data, it shows "No data available in table". What should I do?   My code: /* Script created using the IEA IDB Analyzer (Version 4.0.44). */ /* Created on 2021/10/01 at 20:08. */ /* Press F8 to submit this analysis. */ /* This is where the macros are located */ %let mdir = /home/u59515621/IDB Analyzer Macros; /* This is where the data will be read from */ %let idir = /home/u59515621/Work; /* This is where the output will be saved */ %let odir = /home/u59515621/Work; /* DO NOT EDIT AFTER THIS */ options mrecall sasautos = (sasautos "&mdir"); %jb_reggp ( InDir = &idir , InFile = pattern3 , SelVar = , SelCrit = , OutDir = &odir , OutFile = test2 , CVar = IDCNTRY , NoMiss = Y , strctry = N , dvar0 = ASBGSCM , catvar = ACBGEAS ASBGEML ASBH21 ASBHAMS ASBHENA ASDHEDUP , codings = D D D D D D , ncats = 2 2 2 2 2 2 , RefCats = 1 1 1 1 1 1 , convar = , PVRoots = ASMMAT0 , PVTails = , rootpv = , tailpv = , shrtcut = N , npv = 5 , method = JRR , kfac = 0 , wgt = HOUWGT , rwgt = , nrwgt = 150 , jkz = JKZONE , jkr = JKREP , jk2type = FULL , stratvar = JKZONE , missing = listwise , newout = Y , qcstats = Y , Report = Y , intavg = Y , viewlbl = Y , ndec = 2 , viewcod = N , ViewPrgs = Y , clean = Y ); ... View more

Hello, this is Fuka-japan. I need to convert the SAS file attached to this post to a csv file for use with R, but it says "You do not have permissions". What should I do?   my code: PROC EXPORT DATA= DEF.sas OUTFILE= "/home/u59515621/元データ" DBMS=CSV REPLACE; RUN;     ... View more

When I tried to use the data converted by SAS studio with IEA IDB Analyzer, it said that The "sas.LocalProvider" provider is not registered on the local computer. Please tell me what to do. I'm sorry if this is a problem that cannot be solved by SAS. ... View more

大学の研究のためにSAS Studioを使ってTIMSS2015のSASエクスポートファイルをSASデータファイルに変換したいです。変換するためのプログラムはTIMSS公式で発表されているプログラムを用いました。 （このプログラムはこの投稿に添付してます） このプログラムのINDIR =　以降にSASエクスポートファイルがあるファイルパスを入力し OUTDIR＝以降に変換したあとのSASデータファイルを収納する場所を指定するファイルパスを入力するとのことだったのでその通り入力したのですが「ERROR: /home/u59515621/　C:\Users\〇〇（私の名前）\OneDrive - 〇〇（大学名）.jp\デスクトップ\TIMSS2015_SASData\ATGIRNN1.EXPが存在しません。」と返されてしまいます。 SASを利用したことが初めてであるため、なぜこのようなことになってしまうかがわかりません。 どなたか教えていただけると幸いです。   コード： /******************************************************************************/ /* */ /* SAS Program to Convert SAS Export Files to SAS Data Files */ /* TIMSS 2015 User Guide */ /* */ /******************************************************************************/ OPTIONS NONOTES MPRINT ; %MACRO DOIT (TYPE = , INDIR = , OUTDIR = ) ; LIBNAME OUTDIR "&OUTDIR" ; * Start of file type processing loop ; %DO F = 1 %TO %SYSFUNC(COUNTW(&TYPE)) ; %LET FTYPE = %SCAN(&TYPE,&F) ; * List of TIMSS Numeracy 2015 countries ; %LET COUNTRY = BHR IDN IRN JOR KWT MAR ZAF ABA ; * Start of country processing loop ; %LET I = 1 ; %DO %WHILE(%LENGTH(%SCAN(&COUNTRY,&I))) ; %LET CTRY = %SCAN(&COUNTRY,&I) ; PROC CIMPORT FILE="&INDIR.\&FTYPE&CTRY.N1.EXP" DATA=OUTDIR.&FTYPE&CTRY.N1 ; RUN ; * End of country processing loop ; %LET I = %EVAL(&I + 1) ; %END ; * End of file type processing loop ; %END ; %MEND DOIT ; %DOIT (TYPE = ACG ASA ASG ASH ASR AST ATG , INDIR =　C:\Users\〇〇\OneDrive - 〇〇.jp\デスクトップ\TIMSS2015_SASData , OUTDIR = C:\Users\〇〇\OneDrive - 〇〇.jp\デスクトップ\TIMSS SASデータ移行用 ) ;   ... View more

Hi, this is fuka-japan. I need TIMSS2015 data for my study. So, I want to convert TIMSS 2015 SAS export data files into SAS data files with SAS studio. However, when I enter the file pass of the export data files, it says " not exist." I'm not familiar with SAS, so I don't know what to do. please help me.   My code: /******************************************************************************/ /* */ /* SAS Program to Convert SAS Export Files to SAS Data Files */ /* TIMSS 2015 User Guide */ /* */ /******************************************************************************/ OPTIONS NONOTES MPRINT ; %MACRO DOIT (TYPE = , INDIR = , OUTDIR = ) ; LIBNAME OUTDIR "&OUTDIR" ; * Start of file type processing loop ; %DO F = 1 %TO %SYSFUNC(COUNTW(&TYPE)) ; %LET FTYPE = %SCAN(&TYPE,&F) ; * List of TIMSS 2015 fourth grade countries ; %IF %UPCASE(%SUBSTR(&FTYPE,1,1)) = A %THEN %DO ; %LET COUNTRY = AUS BHR BFL BGR CAN CHL TWN HRV CYP CZE DNK ENG FIN FRA GEO DEU HKG HUN IDN IRN IRL ITA JPN KAZ KOR KWT LTU MAR NLD NZL NIR NOR OMN POL PRT QAT RUS SAU SRB SGP SVK SVN ESP SWE TUR ARE USA ABA COT CQU NO4 AAD ADU ; %END ; * List of TIMSS 2015 eighth grade countries ; %IF %UPCASE(%SUBSTR(&fTYPE,1,1)) = B %THEN %DO ; %LET COUNTRY = AUS BHR BWA CAN CHL TWN EGY ENG GEO HKG HUN IRN IRL ISR ITA JPN JOR KAZ KOR KWT LBN LTU MYS MLT MAR NZL NOR OMN QAT RUS SAU SGP SVN ZAF SWE THA TUR ARE USA ABA COT CQU NO8 AAD ADU ; %END ; * Start of country processing loop ; %LET I = 1 ; %DO %WHILE(%LENGTH(%SCAN(&COUNTRY,&I))) ; %LET CTRY = %SCAN(&COUNTRY,&I) ; PROC CIMPORT FILE="&INDIR.\&FTYPE&CTRY.M6.EXP" DATA=OUTDIR.&FTYPE&CTRY.M6 ; RUN ; * End of country processing loop ; %LET I = %EVAL(&I + 1) ; %END ; * End of file type processing loop ; %END ; %MEND DOIT ; %DOIT (TYPE = ACG ASA ASG ASH ASR AST ATG BCG BSA BSG BSR BST BTM BTS , INDIR = C:\Users\〇〇(it's my name)\OneDrive - △△(it's my university's name).jp\デスクトップ\TIMSS2015_SASData, OUTDIR = C:\Users\〇〇\OneDrive - △△.jp\デスクトップ\TIMSS SASデータ移行用) ; ... View more