If you are worried about the order of the variables then how about trying this: %let varlist1=     ;*Define your variable list in the order you would like to keep; %let varlist2=  ; * Define you variables that you would like to drop; data a; set dsin; drop &varlist2; run; Data dsout; retail &varlist1; set a; run; ... View more

libname xx v9 'c:\'; data want; set xx.out_2; array _y{*} y1-y8; max=max(of y1-y8); i=whichN(max,of _y{*}); max_var=vname(_y{i}); drop max i; run; Ksharp ... View more

Thanks But I think I have bigger problem now my data fie is not transfering correctly from my c drive, it was doing fine and something happened so I guest I have to take care of that first thanks again ... View more

Like DN, I don't know why you didn't just use ODS.  Regardless, given that you have the same number of records in each file, and in the same order, why not combine them with: PROC IMPORT OUT= WORK.d11   DATAFILE= "C:\art\d11.xls"              DBMS=xls REPLACE;   GETNAMES=YES;   DATAROW=2;  RUN; PROC IMPORT OUT= WORK.d22   DATAFILE= "C:\art\d22.xls"              DBMS=xls REPLACE;   GETNAMES=YES;   DATAROW=2;  RUN; PROC IMPORT OUT= WORK.frequency   DATAFILE= "C:\art\frequency.xls"              DBMS=xls REPLACE;   GETNAMES=YES;   DATAROW=2;  RUN; data want;   set frequency (rename=(count=freq_count                          percent=freq_percent));     set d11 (keep=count percent                  rename=(count=d11_count                    percent=d11_percent));    set d22 (keep=count percent                  rename=(count=d22_count                    percent=d22_percent)); run; ... View more

There are procs to do such things.  Take a look at proc means and proc freq ... View more

Okay, it is beginning to look and sound less like a homework problem.  Thus, a couple of points: 1. you don't need to create the variable obs in each of the files. 2. you don't need and output statement in either datastep.  All of the records will be output, with or without the statement. 3.  If you need to scan for the second column, don't scan for the last column.  i.e., instead of using: file2_&seed=input(scan(_infile_,1,,'bs'),best12.); use file2_&seed=input(scan(_infile_,2,,'s'),best12.); 4.Don't use: data class; merge class1_&seed class2_&seed; by obs; Run; You only want to merge the each line of the one file with its corresponding line from the other file.  Just use: data class;   set class1_&seed;   set class2_&seed; Run; ... View more

Yes, it does look like you figured out how to read that particular file. But it seems that your data can vary, so you need a little flexibility. Since you seem to only want to keep tests that end in '_0' then the following code will allow you to check each test instead of using hardcoded line breaks which may fail you the next time you have to run it. The transposition creates the final dataset using the names of the test as the names of the variables data temp; infile 'c:\temp\commandfile.out' firstobs=2; input test $ @; if scan( test, -1, '_' ) = '0' then do;    input parm;    output; end; run; proc transpose data=temp out=temp; id test; run; ... View more

I have a solution If you want. [pre] data temp1; infile 'c:\log.txt' length=len; input row $varying200. len; run; data temp1(drop=row); set temp1 end=last; retain found 'N'; if scan(row,1) eq 'NOTE:' then do; name=scan(row,2); found='Y'; output; end; if last and found='N' then do; name='0'; output; end; run; [/pre] Ksharp ... View more

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

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. ... View more

Or if _N_ in (1,8) then do; skills1=1; skills2=1; skills3=1; end; ... View more

Thank you Doc, It is always great to read constructive comment vs. criticism of our lack of knowledge. ... View more