PS 32 bytes is a hard, physical limit. It is the length reserved for names in the header structure of .sas7bdat files and anywhere else in the SAS language.
... View more
Looks like you somehow managed to create a link to itself in the directory. You will need the assistance of SAS technical support for this.
... View more
Do you want export a SAS dataset to something that Excel can read (csv or xslx, your post is ambiguous), or do you need to create a SAS dataset from wn Excel-compatible source (csv or xlsx, see above)?
Please provide more specific information, including details about your SAS setup (single PC or client/server, which user interface).
... View more
Do a full self join and filter:
data have;
input address $40.;
datalines;
Lot B Plan 1234
PID 004-411-439 Lot B Plan 1234
;
proc sql;
create table want as
select
a.address as address_a,
b.address as address_b
from
have a, have b
where
index(a.address,strip(b.address)) > 0 and a.address ne address_b
;
quit;
... View more
CATS removes trailing blanks from all arguments, even if they are string constants. You can use the CAT function instead, as the blanks between the dataset names and the semicolons won't matter.
... View more
The tools for process monitoring are different across different operating systems, so it is important to know which operating system your SAS server is implemented on.
... View more
Apart from what's been said already, I see a big security issue here. No "ordinary" user should be able to write to the SASApp directory, only the SAS installation user. If other users have write permission there, they can change or destroy your SAS configuration. I strongly recommend you review (or have reviewed) the setup.
... View more
Enterprise Guide is a Windows-only "fat client". It must be downloaded and installed separately.
If your course includes working with EG, your course notes will tell you how to install it.
... View more
Since cleanwork requires to be run by root, I would also set root as the owner of the directory and give write permission only to the user (drwxr-xr-x). Otherwise other users would be able to remove log files from there and/or write garbage there.
... View more
Show what you have already tried and where your problems are. Note: SAS date values are counts of days, so the 1000-day and 15-day intervals are simple to build.
... View more
