Why are you using PROC IMPORT to read a file that does not have column headers and which has only 19 variables? Just write your own data step to read it. Then you can set the NAMES, TYPES, LENGTHS for the variables and tell SAS which INFORMAT to use when reading those numbers that are using commas where periods are expected. Looks like the first 5 variables are identifiers so read them as character strings. If you want to force SAS to treat commas as meaning a decimal point use the COMMAX informat. 1561 data test; 1562 infile 'c:\downloads\test.txt' dlm='09'x dsd truncover firstobs=1 ; 1563 length VAR1 $3 VAR2 $6 VAR3 $6 VAR4 $2 VAR5 $6 VAR6-VAR19 8; 1564 informat VAR6-VAR19 commax.; 1565 input VAR1 -- VAR19 ; 1566 if _n_=1 then list; 1567 run; NOTE: A byte-order mark in the file "c:\downloads\test.txt" (for fileref "#LN00140") indicates that the data is encoded in "utf-8". This encoding will be used to process the file. NOTE: The infile 'c:\downloads\test.txt' is: Filename=c:\downloads\test.txt, RECFM=V,LRECL=131068,File Size (bytes)=116, Last Modified=10 février 2022 11 h 29, Create Time=10 février 2022 11 h 29 RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0 1 CHAR NOR.202001.689432.CC.K01_VG.1.2018,36.2018,36.2018,36.1257,93.0,00.0,00.1717,29.664,09.0,00.0,00.0,0 ZONE 4450333333033333304404335540303333233033332330333323303333233032330323303333233033323303233032330323 NUMR EF2920200196894329339B01F679192018C3692018C3692018C3691257C9390C0090C0091717C299664C0990C0090C0090C0 101 0.0,00.0,00 111 ZONE 30323303233 NUMR 090C0090C00 NOTE: 1 record was read from the infile 'c:\downloads\test.txt'. The minimum record length was 111. The maximum record length was 111. NOTE: The data set WORK.TEST has 1 observations and 19 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.01 seconds 1568 1569 data _null_; 1570 set test (obs=1); 1571 put (_all_) (=/); 1572 run; VAR1=NOR VAR2=202001 VAR3=689432 VAR4=CC VAR5=K01_VG VAR6=1 VAR7=2018.36 VAR8=2018.36 VAR9=2018.36 VAR10=1257.93 VAR11=0 VAR12=0 VAR13=1717.29 VAR14=664.09 VAR15=0 VAR16=0 VAR17=0 VAR18=0 VAR19=0 NOTE: There were 1 observations read from the data set WORK.TEST. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds   ... View more

Using PROC SUMMARY and a DATA step: data Applicationcampaigns; input Campaignname $ APPLICATIONCAMPAIGNS_SRGT_ID; datalines; A 2 A 4 B 7 C 1 C 5 C 6 ; proc summary data=Applicationcampaigns nway; class campaignname; var applicationcampaigns_srgt_id; output out=sum (drop=_type_ rename=(_freq_=NBROFCAMPAIGNS)) min()=; run; proc sort data=sum; by applicationcampaigns_srgt_id; run; data want; set sum; CampaignNumber = _n_; keep Campaignname NBROFCAMPAIGNS CampaignNumber; run; Note that this is based on the data I had to make up; if you want code that works with your data, post it as a data step with datalines, like I did. ... View more

So if you only want those three variables and filter on A, my code would need an additional KEEP= dataset option: data want; set b (keep=id date amount); /* big dataset */ if _n_ = 1 then do; declare hash a (dataset:"a"); /* small dataset */ a.definekey("id"); a.definedone(); end; if a.check() = 0; /* found an entry */ run; ... View more

See this: data want; set test; by contractnbr month; if first.contractnbr then amount_outstanding = amount; else amount_outstanding + amount; if last.month; drop date amount; run; ... View more

Hi @Kiteulf,   Your DO loop suggests that you anticipate the possibility of more than one match per value of aj_text. In this case just correct the regular expression to  /4\d{6}/ and the second argument of the PRXPOSN function to 0.    Then from, say, aj_text='3.14159265358979323846264338327950288419716939937510582097494459230781640628620899862803482534211706' you would obtain cmaenum 4159265 4626433 4197169 4944592 4062862 4825342 ... View more

set Temp2.DK_PANDE3_SME_&s_&j; This resolves to &s_1 when &j = 1. There is no macro variable by that name.   To tell SAS that &s is a macro variable by itself, and the macro variable name does not continue with _&j, you must use a dot to indicate the end of the macro variable name.   set Temp2.DK_PANDE3_SME_&s._&j; ... View more