About mcook

mcook · ‎10-23-2020

I am trying to create a table into the format of the picture below. specifically the year and percent box layout. I have a table like the following. is it possible, with proc print or proc report to transform this table to the format above? more specifically, Since percent just represents the way that the values should be read, and not really a grouping of the variables by class or group, how do I add it in to the table?

mcook · ‎09-28-2020

There will be many documents similar to this one. Though all should have the same format and information, just different values. Originally I wanted to import it as it appears. But without changing variable names to distinguish between the Old and New Form variables, I think it best to import it as 2 separate tables., each with N.Obs, Mean, Std.Dev. and variables a_j, b_j, c_j.

mcook · ‎09-24-2020

I have the following data that i need to import. It is located in the middle of a text document. Knowing the line on which the data starts, how do i go about importing it? ===[Summary Statistics by Model]=== The three-parameter logistic (3PL) model: New Form Old Form -------------------------- -------------------------- a_j b_j c_j a_j b_j c_j N.Obs. 10 10 10 10 10 10 Mean 1.0000 -0.5549 2.0000 2.0000 -0.8378 0.4848 Std.Dev. 0.8737 0.7388 0.4899 1.0000 0.4838 1.9849 I have tried the following code, using both tab and space delimiters. Where LineEnd is the number of the last row of data and LineStart is the first row of data. Neither Tab nor Space delimiters produce the desired result. Tab gives a table with all the data in a single variable. Space gives a table with 53 variables, and the data scattered throughout. Any help appreciated. options obs=&LineEnd.; proc import datafile= "FilePath" dbms=dlm out=Test replace; getnames=yes; datarow=&LineStart.; guessingrows=max; run;

mcook · ‎09-23-2020

Is there a way to import a space delimited txt file, where it will read multiple consecutive spaces as a single delimiter?

mcook · ‎09-23-2020

/****************************************************************/ /* STUIRT */ /* A Computer Program for Scale Transformation under */ /* Unidimensional Item Response Theory Models */ /* Version 1.0 */ /* */ /* Seonghoon Kim and Michael J. Kolen */ /* */ /* Iowa Testing Programs */ /* University of Iowa */ /****************************************************************/ THE FOLLOWINGS WERE READ FROM THE INPUT FILE: < Test_2.stu > OK 55 66 Z9 2 MC 3.40100 3.40100 0.5502 4.0322 67 Z9 2 MC 3.40100 3.40100 0.6070 4.0322 68 Z9 2 MC 3.40100 3.40100 0.8946 4.0322 69 Z9 2 MC 3.40100 3.40100 -2.4236 4.0322 70 Z9 2 MC 3.40100 3.40100 0.2261 4.0322 SK 91 66 Z9 2 MC 3.40100 3.40100 0.6690 4.0322 67 Z9 2 MC 3.40100 3.40100 0.3567 4.0322 68 Z9 2 MC 3.40100 3.40100 0.0184 4.0322 69 Z9 2 MC 3.40100 3.40100 -1.2204 4.0322 70 Z9 2 MC 3.40100 3.40100 0.9993 4.0322 CI 55 BK OP ND 41 SN 4.0322 3.40100 4.0000 OD 41 SN 4.0322 3.40100 4.0000 KO SL BY ===[OPTIONS AND DEFAULTS]=== 1. ST: [DEFAULT] slope = 6, intercept = 5 2. IT: [DEFAULT] maximum number of iterations =15 3. OD: number of theta values = 5 ** OLD FORM: THETA VALUES AND WEIGHTS] ** #0001: -8.10484E+000 1.58347E-005 #0002: -6.94837E+000 3.14155E-005 #0003: -7.38954E+000 2.01854E-006 #0004: -9.48437E+000 5.48388E-006 #0005: -7.38474E+000 3.84373E-006 4. ND: number of theta values = 5 ** NEW FORM: THETA VALUES AND WEIGHTS] ** #0001: -8.10484E+000 1.58347E-005 #0002: -6.94837E+000 3.14155E-005 #0003: -7.38954E+000 2.01854E-006 #0004: -9.48437E+000 5.48388E-006 #0005: -7.38474E+000 3.84373E-006 5. FS: [DEFAULT] HAEBARA METHOD: do standardize loss functions STOCKING & LORD METHOD: do standardize loss functions 6. SY: [DEFAULT] HAEBARA METHOD: bidirection (f1 and f2) STOCKING & LORD METHOD: bidirection (f1 and f2) 7. LM: [DEFAULT] NONE 8. OP: ** This option works here. * 9. KO: The Stocking-Lord method is applied to obtain a common scale. Input files for Kolen's POLYEQUATE are provided. ===[Summary Statistics by Model]=== The three-parameter logistic (3PL) model: Attempt1 Attempt2 -------------------------- -------------------------- a_j b_j c_j a_j b_j c_j N.Obs. 10 10 10 10 10 10 Mean 6.77700 -7.6336 2.0345 2.57800 -9.1536 3.0322 Std.Dev. 4.0322 0.54568 4.0322 4.0322 0.9232 4.0322 ===[Solutions for Moment Methods]=== *** When including the NR and/or MC models, Attempt1 Attempt2 ---------------- ---------------- a_jk b_jk a_jk b_jk N.Obs. 10 10 10 10 Mean 3.40100 -6.5384 3.40100 -0.1536 Std.Dev. 4.0322 0.00011 4.0322 00003 Method Slope Intercept ------------------------------------ Mean/Mean 2.8375903 -3.333333 Mean/Sigma 4.847654 -1.111139 *** When excluding the NR and/or MC models, Attempt1 Attempt2 ---------------- ---------------- a_jk b_jk a_jk b_jk N.Obs. 10 10 10 10 Mean 3.40100 -6.5384 3.40100 -0.1536 Std.Dev. 4.0322 0.00011 4.0322 00003 Method Slope Intercept ------------------------------------ Mean/Mean 2.8375903 -3.333333 Mean/Sigma 4.847654 -1.111139 ===[First Solutions for Characteristic Curve Methods]=== Numb. Meth. 1st.S 1st.I Slope Intercept Iter# TermC Grad.S Grad.I Func.V 0000 HA 1.0 0.0 0.000087 -2.843657 2 1 -9.736328 4.032200 4.2847810 SL 1.0 0.0 2.897536 -18352874 3 1 -3.184737 4.032200 0.670331 ===[Final Summary of Solutions by Method]=== Method Slope Intercept ------------------------------------ Mean/Mean 5.5555999 -1.5839547 Mean/Sigma 4.443838 -2.863526 Haebara 3.141414 -1.987654 Stocking-Lord 3.847377 -9.999999 As the documents in question contain confidential data, I manually changed the values. There is quite a bit more to the document that would take too much time to anonymize. But I need a code that can pull out the tables and data, but ignore the header and options. My first thought was that if i could get the code to scan the document for a certain string. (i.e. ** OLD FORM: THETA VALUES AND WEIGHTS] **, or ===[Solutions for Moment Methods]===) and then import the following table. Since the documents should all follow that similar layout and format. Any help greatly appreciated. I'm quite stumped at the moment.

mcook · ‎09-22-2020

I have many txt documents that are the output of STUIRT software. I need to create a SAS program to reliably import the tables from these txt files. Does anyone familiar with STUIRT output have any suggestions?

mcook · ‎09-03-2020

I have the following code data Item_Import; SET Item_Import(RENAME=(Item_Score=cItem_Score)); Item_Score=input(cItem_Score,3.); drop cItem_Score; run; Item_Import is already numeric, but it may not always be so for other datasets on which i may want to run this code. running it when Item_Import is already numeric results in it becoming populated with '.' how do i get it to keep its values after conversion?

mcook · ‎09-01-2020

If i want to create several arrays with sequential numbers, like the following... Data Want; set Have; array Mitch[*] Temp1-Temp10; array Ed [*] Number1-Number10; array Phil[*] Letter1-Letter10; ****Other code using the arrays; run; Do the Variables of each array have to be contiguous? or only sequential in their placement in regards to the previous member of the array? Or does neither matter so long as there is a valid variable name for each array element somewhere in the table (i.e. There exists somewhere in the table, regardless of position, Temp1 Temp2 Temp3.... Temp9 Temp10? I have tables such that my variables are similar to the following. Temp1 Temp2 Temp3 Temp4 Number1 Number2 Number3 Letter1 Letter2 Letter3 Number4 Number5 Temp5 Temp6 Temp7 Letter4 Letter5 Letter6 Temp8 Number6 Letter7.... etc where the individual arrray numbers are sequential in the order of the variables, but not contiguous, as they are broken up by variables of other arrays. Will the above code create the correct arrays?

mcook · ‎07-08-2020

I have reason to believe that a data step with 4 output statements could be used.

mcook · ‎07-08-2020

I have a table with variables: Item N Mean n_A n_B n_C n_D n_0 n_1 n_2 n_3 n_4 PVal pBis I want to get it to the form with variables: Item Stats N Value Where Stats is broken up into 4 different rows. N, pBis, PVal, Mean. and Value gives the value of those stats. such as... Item Stats Nd Value A1 N 100 100 A1 pBis 100 0.4 A1 PVal 100 0.28 A1 Mean 100 0.56 B1 N 150 150 B1 pBis 150 0.31 B1 PVal 150 0.46 B1 Mean 150 0.46 C1 ............ etc.

mcook · ‎07-06-2020

Thanks. Full join did finally work. I just had a minor syntax error that i had overlooked.

mcook · ‎07-02-2020

I have been trying full joins, but it is not working as I expect.

mcook · ‎07-02-2020

I have several tables Table1: Var1 A B C D E F G Table 2: Var2 A D F G Table 3: Var3 B C D F G i want to get these into a single table in the form of Var1 Var2 Var3 A A B B C C D D D E F F F G G G any suggestions?

mcook · ‎06-25-2020

Wow. unfortunately that seems much more complicated and beyond my current understanding of SAS. Might there be a different way?

mcook · ‎06-25-2020

I have several tables of just one variable. Table 1: MasterList A B C D E F G Table2: Var1 A B E G Table3: Var2: B C E F with the rest similar. With each table having some or all of the values in MasterList. I want to create a table with the variables (var1, var2, etc) as the observations, and the columns A, B,....,G from MasterList. where the observation has a value of 1 if it contains that element from MasterList, and 0 if it does not. Like so. A B C D E F G Var1 1 1 0 0 1 0 1 Var2 0 1 1 0 1 1 0 Var3 ... any help appreciated.

Online Status	Offline
Date Last Visited	‎09-19-2024 01:59 PM

Re: In a custom warning/error: how to get a date value to show up with...

In a custom warning/error: how to get a date value to show up with a f...

Proc Report, how to change the '.' or '' of missing values to 'Unknown...

max function. which variable/argument contained the max value?

Sum Certain values across rows.

Stopping Log output for a section of code?

ODS RTF Proc Report Output Table Manipulation

Spanning multiple cols with regular(non spanning) header. And Merging...

ODS RTF Proc Report: coloring cells based on position, not values.

Re: Combining 2 correlation tables into 1. (1 above, 1 below the diag...

Re: Can you use a list of items in a macrovariable in a whare stateme...

Re: Proc Corr, Keeping only Correlations.

Re: Table of Deleted Items?

Re: check if a field exist and if not to create a field with missing v...

Re: Sql Outer Union Corr VS Data step Set statement

Re: ODS RTF Proc Report Help.

Re: ODBC connection to SSMS,

Re: Creating a table from multiple tables

Creating a custom table format?

Re: Importing a table with no clear delimiter

Importing a table with no clear delimiter

proc import option to read multiple spaces as single space?

Re: Importing from STUIRT output.

Importing from STUIRT output.

Converting numeric variable to numeric results in '.'

Do array numbers have to be sequential and contiguous in the table?

Re: Transpose Wide to Long

Transpose Wide to Long

Re: Adding variables with matching observations

Re: Adding variables with matching observations

Adding variables with matching observations

Re: Creating a table from multiple tables

Creating a table from multiple tables