Any ideas?  ... View more

H. Howles Maybe it should be vvaluex()? Ksharp ... View more

Ahmed, thank you as well your solution works as well. Thank you ... View more

Hi Jerry, /* Test data*/ data test; length a $200.; a="Inquiry#1"; output; a="Inquiry#12"; output; a="123Inquiry#12"; output; a="111IInquiry#12"; output; run; data test1; set test; if index(a,'Inquiry#') ne 0 then do; if index(a,'Inquiry#') gt 1 then bf=substr(a,1,index(a,'Inquiry#')-1); /* Stores before that string(Inquiry#)*/ af=substr(a,index(a,'Inquiry#')+8); /* Stores after that string(Inquiry#)*/ end; run; This may be better option for you... Thanks ... View more

Scott, That was it. I didn't have it within my file statement. Thanks for the quick response. ... View more

Figured it out. I needed to add a "lrecl = 6842" to my file statement. ... View more

Thank for all of your posts. I figured this out by using a macro to cycle through the vars I'm working with. In the macro I generate a sas that has the label statement properly formatted. I created it in a seperate file because of the number of variables I have in some of my tables. I'm dealing with over 5000 variables. So i have 10 or so files that have label statements. Within my main program I use a macro to create the dataset. Within that macro I have a data step that has the %include as part of it. So all my labels get updated. I think I took the long route but I have to have pretty log files and this way does that. Thanks again for all of your help ... View more

sss, Thank you for your reply as well. That won't work because there can be other "V" in the string. I need the number "V" number pattern. Thank you for the suggestion Jerry ... View more

SPR, Thank you for your reply. Jerry ... View more

Did you try setting the registry to the highest number possible rather than 0? ... View more

Hi. I looked so many replys ,So I also think it for a while. data i;   input ID Year Name $; datalines; 1 1990 Bob 1 1991 Ken 1 1997 Cindy 1 1998 Will 2 1990 Jack 2 1991 Frank 2 1992 Mindy run; proc sort data=i;  by id year; run; proc sql;  create table temp as   select id,year    from (select distinct id from i),(select distinct year from i)     order by id,year; quit; data _temp;  merge i temp;  by id year; run; proc transpose data=_temp out=result(drop=_name_) prefix=_;  by id;  id year;  var name; run; [pre] Ksharp [/pre] Message was edited by: Ksharp ... View more

Marius that's very good! Using catx() eliminates the leading delimiter caused by cat(), so eliminates the need to test for first. Applying that and the array approach greatly simplifies my DoW [pre]data temp2 ; array arr_d(2) $50 arr_good arr_bad ; do until( last.id ); * sometimes referred to as a DoW loop ; set temp ; by id ; arr_d(source)=catx( ',', arr_d(source), val ) ; end ; run;[/pre]no need to clear the arr_bad and good because no need to retain them, nor is there any need for explicit output because each data step iteration deals with just one ID value. ... View more

Check SAS/ACCESS DOC and PASS-through facility using the CONNECTION parameter as part of your SELECT. Scott Barry SBBWorks, Inc. Suggested Google advanced search argument, this topic / post: proc sql nested query oracle site:sas.com ... View more

KSharp, Thank you for your post. I corrected the issue you mention in your post and finally have it working. Thank you for your help Jerry ... View more

Scott, Thank you again for your help. The _infile_ with the input function makes sense but what i'm having a hard time with is knowing how to grab the text. I know that under this row "def: NUM WIDTH:5 DECIMALS:5" there are two blank rows then my data starts there and every row after that till another blank row is hit. Am I able to do that with this logic? Since I don't know what text is going to be there I can only know where it will start based on the blank rows. Does this make sense or am I making it more difficult then it needs to be. Thanks for the help ... View more