About R_A_G_

R_A_G_ · ‎08-21-2011

just forgot to mention that these variables don't have any variable names What version of SAS are you using? 9.2 What operating system are you on? Window 7, 64 bit What do the files look like (e.g., delimited, fixed format, etc.)? Tab delimited What kind of field is in the last column and is it the same for all files? yes they all look the same I am attaching an example file, but I believe your codes should help work for me.

R_A_G_ · ‎08-21-2011

hello I have about 150 text files to read into SAS. I just want the last column of these files, after reading them I need to concatenate these files into one. Any help is greatly appreciated. RG

R_A_G_ · ‎07-14-2011

figured it out. This is how: data CDM.temp_&seed; infile "c:\cdm\&commandfile..out" truncover; input test $27. @; /* 27= the lenght of New/Additional Parameters*/ if trim(test)="New/Additional Parameters" then do; input / @23 L1_0 / / @23 L2_0 / / @23 L3_0 / / / @23 L4_0 / / @23 L5_0 / / @23 L6_0 / / / / @23 L7_0 ; output; stop; end; drop test; run;

R_A_G_ · ‎07-14-2011

Hello SAS experts, I am trying to read an external text file but my code does not work. any help is appreciated this is what I am trying to read from: New/Additional Parameters L1_0 -1.682 0.342 -4.911 0.000 L1_11 2.310 0.370 6.251 0.000 L2_0 -1.522 0.280 -5.433 0.000 L2_12 2.009 0.281 7.144 0.000 L3_0 -2.238 0.430 -5.202 0.000 L3_12 1.689 0.351 4.813 0.000 L3_13 2.228 0.346 6.430 0.000 L4_0 -1.167 0.211 -5.544 0.000 L4_11 1.825 0.368 4.957 0.000 L5_0 -1.796 0.359 -4.999 0.000 L5_11 1.452 0.536 2.709 0.007 L5_13 1.915 0.491 3.897 0.000 L6_0 -1.995 0.504 -3.961 0.000 L6_11 1.516 1.194 1.269 0.204 L6_12 2.161 0.717 3.015 0.003 L7_0 -3.626 0.550 -6.597 0.000 L7_11 2.524 0.550 4.593 0.000 this is my code: data CDM.temp_&seed; infile "c:\cdm\&commandfile..out" truncover end=finished;/***********/ input test $21. @; if trim(test)="New/Additional Parameters" then do; input / @20 L1_0 / / @20 L3_0 / / L3_0 / / / L4_0 / / L5_0 ; output; stop; end; drop test; run; proc print;run;

R_A_G_ · ‎06-14-2011

thanks Ksharp this simple and short code works well. R.A.G.

R_A_G_ · ‎06-13-2011

Hi KSharp, The id code does not work. I need these files to be stacked in order. Ex: 1st OUT1 2nd OUT2, 3rd OUT3 and so on. thanks

R_A_G_ · ‎06-06-2011

Sorry but it does not work. It seems like ArtC's should work, if I could make the files keep their value instead of replacing all with "0"-missing. Just to clarify what I am trying to do: I got 150 files that is several pages long but I only need this section of the data "Information Criteria" except that some of the files do not have this data -missing. So I would like to plug in "0" for the data files that do not have this information. This way I have for example :Temp_1 with all 4 variables and Temp_2 with the value of "0" for all the variables. At the end I will end up stacking all these 150 data on top each other in ORDER-that is another issue I am having. Thank you

R_A_G_ · ‎06-06-2011

Hello ArtC, This looked like it would take care of my problem except that even with the OUTPUT; code it still replaces all the data with "0" instead of just plugging in "0" for the missing data file only. Just to clarify what I am trying to do: I got 150 files that is several pages long but I only need this section of the data "Information Criteria" except that some of the files do not have this data. So I would like to plug in "0" for the data files that do not have this information. This way I have for example :Temp_1 with all 4 variables and Temp_1 with the value of "0" for all the variables. Thank you

R_A_G_ · ‎06-05-2011

Hello, I was wondering what does " / open=defer" do in that statement? Thanks

R_A_G_ · ‎06-05-2011

Hello, I have a code to read a statement from a text file but sometimes there is no text to read, which in that case I need to insert 0 for each one them. Would someone help me figure out how to do that. Thanks Code: data CDM1.temp_&seed; infile "c:\CDM1\&commandfile..out" truncover; input test $21. @; if test="Information Criteria" then do; input / / @40 num_fre_par / @40 akaike5 / @40 bayesian / @40 sam_siz_adj_bic ; else input num_fre_par=0 akaike5=0 bayesian=0; this doesn't give me 0 for each missing statement output; stop; end; drop test; run;

R_A_G_ · ‎06-05-2011

thank you that simple set statement works

R_A_G_ · ‎06-05-2011

Hello, I have 150 files named TEMP_&seed seed=1 to 150 I want to stack them in order but when I use the following syntax they files are not ordered right. Why? my codes: data SAP.result; set SAP.TEMP_:; run; Thank you

R_A_G_ · ‎04-20-2011

Thank you Cynthia, I new I could count on your help. It was a SAS issue I had a path in SAS to change directory to C:\ X "cd c:\"; I was trying to fix the Mplus syntax while it was a SAS miscoding. thank you for helping R.A.G.

R_A_G_ · ‎04-19-2011

Hello, I understand that this might not be the right place to ask this question but I am not having any luck posting this question anywhere else and cannot figure it out by myself. I am running Mplus from SAS and cannot make Mplus save the output in the same directory as the input file. any help is greatly appreciated R.A.G.

R_A_G_ · ‎04-19-2011

Thank you Rick and Tim it WORKED! R.A.G.

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?

Re: reading multiple textfiles

reading multiple textfiles

Reading text files

Reading text files

Re: concatenating

Re: concatenating

Re: IF statement

Re: IF statement

Re: concatenating

IF statement

Re: concatenating

concatenating

Re: saving output with SAS/Mplus

saving output with SAS/Mplus

Re: if then