Hi, I hope anyone could help me out with the following. I want to read multiple files (from 1 till 30), placed in 1 dir, with the use of macro's (best way to do this I think). But... my version of the program only generates errors (by the way; I haven't looked yet for a solution to go over the 10, so I'll use i=1 to 9). It doesn't recognize the filename with the &i in it...: %macro import_files; %do i=1 %to 9; PROC IMPORT DATAFILE= 'L:\8th\TEST REQUESTS\03 Graphs\Financieel_AB_401_Day_0&i_09_2009.csv' OUT= work.AB_401_&i DBMS=DLM REPLACE; DELIMITER='3B'x; GETNAMES=YES; DATAROW=2; RUN; %end; %mend; %import_files ... View more

Hi, I've created a (SAS) SQL query, but this generate a warning ("Function LEFT requires at most 1 argument(s). The extra one(s) will be ignored."). In Management Studio the query (this part) works great, but not in SAS. Can anyone see the problem? The 'faulty' part: WHEN LEFT(MAX(Addr.ZipCode),3) IN ('101', '102') OR MAX(Addr.ProvinceName) IN ('Berlin', 'Brandenburg') THEN 'E' WHEN MAX(Addr.ProvinceName) IN ('Baden', 'Hamburg') THEN 'W' END AS RM_EW Thanks for your answer!! Message was edited by: Wouter Message was edited by: Wouter ... View more

I learned it a year ago at my SAS Base course, but right now, I don't remember anymore... If anyone could help me? I've got a dataset with ID numbers, accompanied by dates (so several ID numbers are the same). Only the first of some ID numbers is flagged with FLAG=1. Now I want all the flagged numbers to have a FLAG=1 for all of them. See below a sample: ID Date Flag 1 01-01-2008 1 1 03-01-2008 0 1 05-01-2008 0 2 06-04-2008 0 2 10-04-2008 0 3 01-01-2008 1 3 01-02-2008 0 3 01-08-2008 0 4 01-01-2008 0 5 11-01-2008 0 5 12-01-2008 0 So I want for ID 1 and 3 a Flag=1 for all their presences. I tried something like: if first.id then do; retain FLAG; if last.id then do; FLAG=1;end;end; But this doesn't work. Anyone an idea? Thanks in advance! Message was edited by: Wouter Message was edited by: Wouter ... View more

Hi, Within 2 weeks, I've got the Base exam. After reading a lot (don't have access to the actual SAS right now, so I can't find out this question for myself), I want to know what will happen with the following code if there are more statements between the IF statement and the RUN statement: Data XX.YY Input ... If tolerance="D"; TotalTime=(Timemin*60)+timesec; run; Will all statements after the IF statement only execute when tolerance="D", or does the IF statement only applies to the variable assignment (Totaltime)? To put it another way, what is the value of TEST when running this code when tolerance="A": Data XX.YY Input ... If tolerance="D"; TotalTime=(Timemin*60)+timesec; TEST=6; run; Thanks in advance! ... View more

Hi all! Should be a simple task, but I don't get the code right... I want to know (and FLAG) if a record contains a 1 time number or if there are other records with the same number. So I've got a dataset like: 1 text 2 text 2 text 3 text 4 text 4 text 4 text I want to create a 'FLAG', so I know a number appears more than once in the dataset. The outcome should be something like: 1 text 0 2 text 1 2 text 1 3 text 0 4 text 1 4 text 1 4 text 1 Can anyone help me with this? Thanks!! ... View more