About R_A_G_

R_A_G_ · ‎09-02-2011

Hi, I am very puzzled, I've ran the proc freq as art297 kindly suggested and used the the "/" to get an output data for these results, now I have to merge the true freq table with observed freq table. The problem is that when I do merge them only the first data set's full information shows. how can I fix this? thanks my code: proc freq data=c10000.c10000_D1 ; tables True_Class / out=c10000.D1; tables Est_Class / out=c10000.D2; tables True_class*Est_Class / out=c10000.D3; Run; data c10000.D1; set c10000.D1; obs=_n_; run; data c10000.d22; set c10000.d2; label count=Est_Frq percent=est_perc; run; data c10000.d11; set c10000.d1; label count=tru_Frq percent=tru_perc; run; data c10000.D22; set c10000.D2; obs=_n_; run; proc sort data=c10000.D1 out=c10000.D1; by obs; run; proc sort data=c10000.D2 out=c10000.D2; by obs; run; data c10000.Freqency; merge c10000.D22 c10000.D11; by obs; run; proc print data=c10000.Freqency; run;

R_A_G_ · ‎08-31-2011

I also need to do countif I need to find the percentage of 0 biases in my claculation Thanks

R_A_G_ · ‎08-31-2011

Hello, I have another question. Now I have both my estimated variable and original data and need to calculate bias, average and root mean square error, I can do the bias but do not know how to calculate the average and RMSE of the estimate column. My problem is that I do not know how to do arrays calculation Thank RG

R_A_G_ · ‎08-30-2011

thanks RG

R_A_G_ · ‎08-30-2011

Sorry for the late reply I finally found what the problem was, 'bs' is telling sas to read from right to left and I wanted 2nd column from left to right, found it by try and error. Below is the code for reading the correct column (2nd column from the left) But I have no idea what to use if I wanted to read from left to right that's why I've used -32 , I just counted the column. Thanks filename cc "C:\CDM1\5K\5K_5000obs\5K_5000obs_RIT\IN\dat1.dat"; Data class2_1; infile cc lrecl=10000 filename=filename; input; file2_2=input(scan(_infile_,-32,,'bs'),best12.); run;

R_A_G_ · ‎08-29-2011

you are right about the first line being observation number. One of these files is the estimated value and the other is the original data. I have simulatd about 150 of these files and now I am trying to grab the estimated variable from one file and the coresponding original variable form the other and calculate the bias, standard error, and RMSE of these variables 150 of them. Thanks This is my code, the only problem is that I cannot make the second file to read the 2nd column, %macro RRRUN; %let num_reps=1; %do seed=1 %to &num_reps; %LET commandfile=respondents_&SEED; %LET dat=dat&SEED; LIBNAME class "C:\CDM1\5K\OUT\class"; RUN; filename allcsv "C:\CDM1\5K\5K_5000obs\5K_5000obs_RIT\OUT\&commandfile..dat"; data class1_&seed; infile allcsv lrecl=10000 filename=filename; input; file_&seed=input(scan(_infile_,1,,'bs'),best12.); run; data class1_&seed; set class1_&seed; obs=_n_; output; run; /******************************/ filename allcsv "C:\CDM1\5K\5K_5000obs\5K_5000obs_RIT\IN\&dat..dat"; Data class2_&seed; infile allcsv lrecl=10000 filename=filename; input; file2_&seed=input(scan(_infile_,1,,'bs'),best12.); run; data class2_&seed; set class2_&seed; obs=_n_; output; run; data class; merge class1_&seed class2_&seed; by obs; Run; set %END; %MEND; %RRRUN;

R_A_G_ · ‎08-29-2011

My new problem is that each one of these files have a corresponding file from another directory that I need to read and after ward do do some calculation. My question is that how do I read another file from a different location into the file had created to then do some math calculations? this is what I had with your help, which I put it in a Macro: %macro class; OPTIONS MACROGEN %let num_reps=150; %do seed=1 %to &num_reps; %LET commandfile=respondents_&SEED; LIBNAME Out "C:\CDM1\5K\OUT"; RUN; filename allcsv "C:\CDM1\5K\5K_5000obs\5K_5000obs_RIT\OUT\commandfile..dat"; data out.class; infile allcsv lrecl=10000 filename=filename; input; file_1=input(scan(_infile_,1,,'bs'),best12.); run; data out.class1_&seed; set class; obs=_n_; output; run; %END; %MEND; I need the 2nd column of the file the following file, I can attach it if that would be more helpful This is what the file looks like: 1 5 0 0 0 0 1 1 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 2 32 1 0 1 1 1 1 1 0 1 1 1 1 0 1 1 1 1 1 1 0 1 1 1 1 0 0 1 1 1 1 1 3 13 1 0 0 1 1 0 1 1 1 0 0 1 0 0 1 0 0 1 0 1 1 0 0 1 0 1 0 0 0 0 0 4 8 0 1 1 1 1 1 1 0 0 0 1 1 1 0 1 0 0 0 1 0 0 0 1 0 0 0 0 0 1 0 1 5 31 0 0 1 1 1 1 1 0 0 0 1 1 0 1 1 0 0 1 0 1 0 1 1 1 0 1 1 1 0 1 1 6 32 0 1 1 1 1 1 0 1 0 0 0 1 1 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 7 18 0 0 0 0 0 1 0 1 0 1 0 0 1 0 0 1 1 1 1 0 0 1 1 1 1 1 0 0 0 0 0 Thank you

R_A_G_ · ‎08-29-2011

yes it did but it doesn't work for this one. I am tring to change it a bit and see if it can read this as well. Thanks

R_A_G_ · ‎08-29-2011

Hello, I have 150 .dat files which are space delimited. I need to read the last column. please help Thanks

R_A_G_ · ‎08-21-2011

Thank you art297 it worked beautifully

R_A_G_ · ‎08-21-2011

I was wondering what do these lines mean. and why should be an * after the file name in filename allcsv infile allcsv filename=filename; input; lastfield=input(scan(_infile_,-1),best12.);

R_A_G_ · ‎08-21-2011

It's sill all o's istead of numbers these numbers : 17.00000, 14.00000,.. Thanks filename allcsv "C:\CDM1\5K\5K_10000obs\5K_10000obs_RIT\OUT\respondents_*.dat"; Data out.class; infile allcsv filename=filename; input; lastfield=input(scan(_infile_,-1),best12.); run;

R_A_G_ · ‎08-21-2011

thanks I fixed those problems, although it does read something, it is not the last column. %macro RRRUN; %let num_reps=1; %do seed=1 %to &num_reps; %LET commandfile=respondents_&SEED; LIBNAME Out "C:\CDM1\5K\OUT"; RUN; filename allcsv "C:\CDM1\5K\5K_10000obs\5K_10000obs_RIT\OUT\&commandfile..dat"; Data out.class; infile allcsv filename=filename; input; lastfield=input(scan(_infile_,-1,","),best12.); run; %END; %MEND; %RRRUN; This is my LOG file: 425 %macro RRRUN; 426 OPTIONS MACROGEN 427 %let num_reps=1; 428 %do seed=1 %to &num_reps; 429 %LET commandfile=respondents_&SEED; 430 LIBNAME Out "C:\CDM1\5K\OUT"; 431 RUN; 432 433 filename allcsv "C:\CDM1\5K\5K_10000obs\5K_10000obs_RIT\OUT\&commandfile..dat"; 434 Data out.class; 435 infile allcsv filename=filename; 436 input; 437 lastfield=input(scan(_infile_,-1,","),best12.); 438 run; 439 440 %END; 441 %MEND; 442 443 %RRRUN; NOTE: Line generated by the invoked macro "RRRUN". 3 LIBNAME Out "C:\CDM1\5K\OUT"; ------- 13 ERROR 13-12: Unrecognized SAS option name, LIBNAME. 3 ! LIBNAME Out "C:\CDM1\5K\OUT"; --- 13 ERROR 13-12: Unrecognized SAS option name, OUT. 3 ! LIBNAME Out "C:\CDM1\5K\OUT"; ---------------- 13 MACROGEN(RRRUN): Out "C:\CDM1\5K\OUT"; MACROGEN(RRRUN): RUN; MACROGEN(RRRUN): filename allcsv "C:\CDM1\5K\5K_10000obs\5K_10000obs_RIT\OUT\respondents_1.dat"; MACROGEN(RRRUN): Data out.class; MACROGEN(RRRUN): infile allcsv filename=filename; MACROGEN(RRRUN): input; MACROGEN(RRRUN): lastfield=input(scan(_infile_,-1,","),best12.); MACROGEN(RRRUN): run; ERROR 13-12: Unrecognized SAS option name, "C:\CDM1\5K\OUT".

R_A_G_ · ‎08-21-2011

I think the format for my file is different. it's a .dat file and I am getting this error: ERROR: Physical file does not exist, C:\CDM1\5K\5K_10000obs\5K_10000obs_RIT\OUT\commandfile..dat? This is my code: %macro RRRUN; %let num_reps=1; %do seed=1 %to &num_reps; %LET commandfile=respondents_&SEED; LIBNAME Out "C:\CDM1\5K\OUT"; RUN; filename allcsv "C:\CDM1\5K\5K_10000obs\5K_10000obs_RIT\OUT\commandfile..dat”"; Data out.class; infile allcsv filename=filename; input; lastfield=input(scan(_infile_,,-1,","),best12.); run; %END; %MEND; %RRRUN; data OUT.class10000; set OUT.temp_1-OUT.temp_7; run;

R_A_G_ · ‎08-21-2011

Thank you very much, I'll try it right now

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: all column stacked in one

Re: all column stacked in one

Re: all column stacked in one

all column stacked in one

Re: &&

&&

Re: variable names in "row 2" how to let PROC IMPORT to start from the...

delete observations

how to use IF-Then

Re: export

Re: import data and naming the variable

Re: what does combinations do?

Mergiing Proc freq tables

sum, rmse of a variable

sum, rmse of a variable

Create a dataset from multiple datasets/criteria

Create a dataset from multiple datasets/criteria

Re: reading multiple textfiles

Re: reading multiple textfiles

reading multiple textfiles

reading multiple textfiles

Re: reading multiple textfiles

Re: reading multiple textfiles

Re: reading multiple textfiles

Re: reading multiple textfiles

Re: reading multiple textfiles

Re: reading multiple textfiles