Hello. As Mr. Barry mentioned this question has been discussed many times. There is one of these discussions: http://support.sas.com/forums/message.jspa?messageID=51742#51742 > http://support.sas.com/forums/message.jspa?messageID=51742#51742 Message was edited by: Oleg_L ... View more

Hello. You may find this thread useful. http://support.sas.com/forums/thread.jspa?messageID=35783诇 > http://support.sas.com/forums/thread.jspa?messageID=35783诇 ... View more

Hello. Try this code. [pre] proc sort data=temp; by csid descending cost; run; data temp2; retain n 0; set temp; by csid descending cost; if first.csid then n=1; else n=n+1; if n le 2; run; [/pre] ... View more

To set the limit add limit= statement before load statement. limit=1000000; ... View more

Hello. The code below is one of possible ways. [pre] DATA Table_1; infile cards; input t1 $10.; cards; AMATA STEC PTTEP ; data Table_2; infile cards; input t2 $10. ; match=1; cards; AMAT STEC PTTE IVL ; proc sql noprint; create table t3 as select table_1.t1, table_2.t2, table_2.match from table_1 left join table_2 on upcase(table_1.t1) contains upcase(trim(table_2.t2)); quit; [/pre] ... View more

You should not use decimals in your informat. Input x 6.; With decimals value 65 is read as 0.65 Message was edited by: Oleg_L ... View more

You may find this thread useful http://support.sas.com/forums/thread.jspa?threadID=13198&tstart=45 > http://support.sas.com/forums/thread.jspa?threadID=13198&tstart=45 ... View more

Try to replace " if not missing(ship_to_party) then output;" with "output;" or another guess is to add option "ignoredoseof" to the infile statement. But I'm not sure. infile dummy1 firstobs=2 dlm='09'x ls=32000 truncover dsd filevar=fname end=eof ignoredoseof ; ... View more

-> PS: While im at it, i've gotten Oleg method to work (Thanks!) - and that causes me a new problem. If i have a variable thats a string of text like "wea-abo_29-01-2011.txt" can SAS recognize the date in the text, and translate it into a sas date like 29JAN2011? Add before the line " if not missing(ship_to_party) then output;" next code: date=input(substr(left(myfiles),9,10),ddmmyy10.); Oleg. ... View more

The code below is a solution from this forum poster "Data _null_". http://support.sas.com/forums/thread.jspa?messageID=51217접 > http://support.sas.com/forums/thread.jspa?messageID=51217접 [pre] data a; retain dlm ' '; infile cards truncover dsd dlm=dlm; input @; end = length(_infile_)+1; do j = 1 to 2; end = find(_infile_,dlm,-(end-1)); end; start = find(_infile_,dlm,1); length = end-start-1; input pid :8. name $varying50. length +1 age :8. race :$10.; keep pid name age race; cards; 101 rakesh kumar 34 asian 102 hari 29 african ; [/pre] Message was edited by: Oleg_L Message was edited by: Oleg_L Message was edited by: Oleg_L ... View more

I'm also having a difficulties with your sample data. The variable name in the first row consists of two parts, but in the second row the second part is missing. Don't you miss something? Does your actual data as inconsistent as you post it? [pre] data abc; infile cards missover; input pid fname :$30. sname :$30. age race :$10.; cards; 101 rakesh kumar 34 asian 102 hari Sname_is_missing 29 african ; [/pre] ... View more

Try this code. You may want to edit variables informat. [pre] %macro cfin10(input=d:\dep\input\2009, out=obordop2009); /* read files in directory INPUT */ %let dir=%str(dir %")&input.%str(\%" /A-D/B/ON); data &out (compress=yes drop=filevar); length filevar $256. command $256. fname $256.; command = symget('dir'); infile dummy0 pipe filevar=command truncover; input myfiles $100.; fname=quote(upcase(cats("&input",'\',myfiles))); infile dummy1 firstobs=2 dlm='09'x ls=32000 truncover dsd filevar=fname end=eof ; informat ship_to_party $10. publication $5. edition $2. oplagskat $10. subscr_valid_from ddmmyy10. bill_freq $10. pmethod $10. r_code $10. ordernr $9. fremtidig_aktiv $10. fornavn $50. efternavn $70. vej $70. husnr $10. husnr_suppl $5. etage $1. side $10. postnr 17. by $50. land $2. tlf 17. bp_kat $1. orgnavn1 $50. orgnavn2 $50. orgnavn3 $50. orgnavn4 $10. EMail $50. Marketing_campaign $10. ship_robinson $10. sold_to_party $10. sold_fornavn $50. sold_efternavn $50. sold_vej $50. sold_husnr 17. sold_husnr_suppl $1. sold_etage $1. sold_side $1. sold_postnr 17. sold_by $50. sold_land $2. sold_tlf 17. sold_bp_kat $1. sold_orgnavn1 $50. sold_orgnavn2 $50. sold_orgnavn3 $50. sold_postbox $50. sold_email $50. sold_robinson $50. samme $2. tom_variabel2 $10. del_end $10. endreason $10. matriculationdate $10. suspension_from $10. suspension_to $10. Suspension_reason $10. Delivery_type $1. pricegroup $10. ; do while(not eof); input ship_to_party publication edition oplagskat subscr_valid_from bill_freq pmethod r_code ordernr fremtidig_aktiv fornavn efternavn vej husnr husnr_suppl etage side postnr by land tlf bp_kat orgnavn1 orgnavn2 orgnavn3 orgnavn4 EMail Marketing_campaign ship_robinson sold_to_party sold_fornavn sold_efternavn sold_vej sold_husnr sold_husnr_suppl sold_etage sold_side sold_postnr sold_by sold_land sold_tlf sold_bp_kat sold_orgnavn1 sold_orgnavn2 sold_orgnavn3 sold_postbox sold_email sold_robinson samme tom_variabel2 del_end endreason matriculationdate suspension_from suspension_to Suspension_reason Delivery_type pricegroup ; if not missing(ship_to_party) then output; end; run; %mend cfin10; %cfin10(input=d:\work\morv, out=tmorville); [/pre] Message was edited by: Oleg_L Message was edited by: Oleg_L Message was edited by: Oleg_L ... View more

I can suggest you another way. See code below. I don't know your data structure. You did not provide the data here. You should edit "dlm=", "firstobs=", path to your files and "informat" and "input" according to the information in your text files. [pre] data test ; length filename $256.; infile 'd:\mbm\2009\D20091106\input\*.txt' firstobs=3 dlm=';' ls=32000 truncover dsd eov=eov filename=filename; informat account $20. ss_naim $100. var1-var5 $1. ss_ostd 17. ss_ostc 17. ost_ccy 17. country $50. iso $3. client $100. k_client $12. client_t $1. inn $char12. reg $char30. isin $char20. cb $char30.; input @; if eov then do ; input /; eov = 0 ; end; input account ss_naim var1-var5 ss_ostd ss_ostc ost_ccy country iso client k_client client_t inn reg isin cb ; file=filename; run; [/pre] ... View more

Hello. Try this macro. It works on Windows. Edit some marked lines of code. [pre] %macro cfin10(input=d:\dep\input\2009, out=obordop2009); /* read files in directory INPUT */ %let dir=%str(dir %")&input.%str(\%" /A-D/B/ON); data &out ; length filevar $256. command $256. ; command = symget('dir'); infile dummy0 pipe filevar=command truncover; input myfiles $100.; fname=quote(upcase(cats("&input",'\',myfiles))); /* Edit below line of code - delimiter and firstobs */ infile dummy1 firstobs=2 dlm=';' ls=32000 truncover dsd filevar=fname end=eof; /* edit below line of code according to your data structure (fields) */ informat account $20. ss_naim $100. var1-var5 $1. ss_ostd 17. ss_ostc 17. ost_ccy 17. country $50. iso $3. client $100. k_client $12. client_t $1. inn $char12. reg $char30. isin $char20. cb $char30.; do while(not eof); /* edit below line of code according to your data structure (fields) */ input account ss_naim var1-var5 ss_ostd ss_ostc ost_ccy country iso client k_client client_t inn reg isin cb ; end; run; %mend cfin10; [/pre] Message was edited by: Oleg_L ... View more

One of many ways. [pre] data table1; infile cards; input var1 $ var2; cards; a 1 b 2 c 3 d 4 ; data table2; infile cards; input var1 $ var2; cards; b 5 c 6 ; proc sql noprint; create table table1 as select a.var1, coalesce(b.var2,a.var2) as var2 from table1 as a left join table2 as b on a.var1=b.var1; quit; [/pre] ... View more