first. and last. are only generated for variables in the "by" list. Try this: data int; set old; int_day = datepart(Transaction_Date); run; proc sort data=int; by Acc_Nr Transaction_Date; run; data wanted (drop=int_day); set int; by Acc_Nr int_date; if first.int_date; run;
... View more
How about doing it the other way around, by counting workdays? IF DLVR_STRT_DTS = . THEN C= 'N/A'; ELSE DO; SELECT (REGION); WHEN ('Americas') DO; check = 0; do iter_date = DATEPART(ORD_ENTRY_DATE) to DATEPART(DLVR_STRT_DTS); if (WEEKDAY(iter_date) not IN (1,7) and INPUT(PUT(iter_date,AMERHOL.),9.) ne 1 then check = check + 1; * count the actual number of workdays; end; IF check le 3 THEN C = 'MADE'; ELSE C = 'MISS'; END;
... View more
Just one thing: you might consider to mark one of the answers as correct so that your initial question ist listed as "answered". Likewise for helpful posts.
... View more
Do this: data wang; set have; format time_numeric time8.; time_numeric = input(substr(time,1,2) !! ':' !! substr(time,3,2) !! ':' !! substr(time,5,2),time8.); run;
... View more
Do this: data want; set have; by id; retain product; if first.id then product = 1; product = product * return; if last.id then output; run;
... View more
Determine how large your data set is (physically) (sum of size of vars * number of records) Depending on that, you might consider exporting the data to a flat file and sort that externally (linux). In my own experience I have to say that SAS performance in z/OS is surprisingly bad, after migrating to a 2-CPU pSeries (with AIX) we noticed that it ran circles around the MF. Also keep in mind that SAS generates a utility file while sorting, and then writes the sorted data back. You should make sure that the source and target of the sort are not located where your WORK library is (or the place where the UTILLOC system option points to). From your description I thing that you are heavily I/O bound, that's why the trick with dividing the data set did not make a difference.
... View more
The first @ in the input statement positions the cursor at column 1; The second, trailing(!) @ tells SAS to keep the contents of the input buffer and not read a new line. The input statement without the trailing @ switches to the next line of the infile after reading
... View more
In CD34_NUM = input(CD34, comma21.2); replace the format with comma21. The format works like that: - read in all numeric digits as a natural number - if there is a number X after the dot in the format, divide by 10^X Your numbers were converted as 1.00, 2.50, 3.50 respectively instead of 100, 250, 350
... View more
If at first you just want to make sure that you read everything that's in a line, try the following: %let maxrl=500; * or any number that is appropriate; data infile1; infile"xxxx" lrecl=&maxrl truncover; input whole_line $&maxrl.; run;
... View more
If your SAS is installed on a UNIX, the error message will include the process number of the locking process. ps -fp processnumber will give you the user's ID.
... View more
1. What DBailey said, it depends a lot on the definition of your columns. 2. Anytime you have a SAS data set with long(er) char columns that are mostly filled with blanks, use the compress=yes data set option. The compute overhead is rather small and always offset by the reduced I/O load. With long text fields, the compression ratio can reach > 95% :smileyalert:
... View more
Hi! If you try to open every file (of an unknown number of files) by itself, you may run out of available file handles (limit depending on the operating system). In cases like this, I prefer to concatenate all the files with the help of the OS so I only have to read one file in SAS. (eg UNIX "cat xxxx* > xxxx.concat"). But then, I have the blessing of running SAS on a Unix instead of Windows.
... View more
The NAME of a fileref must not be longer than 8 characters. If you will look closely, you will see that the filename statement generates an error (invalid logical name).
... View more
If the range of input values is a) numeric with constant intervals and b) rather small, you could do the following: data xxx (drop=lookup); set yyy; retain lookup 'First Second Third Fourth Fifth Sixth SeventhEighth Ninth Tenth '; Wordnumber = substr(lookup,(number-1)*7+1,7); run; Adjust the formula in the substr() to your actual needs.
... View more
