@ivarenho wrote:
I tried the code as you wrote it and It worked well except for the error regarding the CSV file:
ERROR: Physical file does not exist, S:\ \workshop\EPG1V2\data\storm_final.csv.
When you get an ERROR like this while trying to create a file, you either specified a directory path that does not exist, or where you do not have write permission.
... View more
If all your combinations of
studyid site subjid
are unique, then
first.subjid
will always be true, and the whole condition always false. Your empty result dataset proves that all combinations are unique and you have no duplicates.
Multiple entries for a given subjid are obviously contained in different studies/sites.
... View more
When reading text files, don‘t waste your time with PROC IMPORT. Write the DATA step yourself, according to the documentation of the file. You‘ll get much cleaner and easier to maintain code, and have the full flexibility if DATA step coding at your hand. The accepted solution will make it impossible to correctly read numeric values, including dates and times.
... View more
The usual mistake that causes the "physical file does not exist" message comes from trying to read a local (residing on your PC) file in the remote (running on a server) SAS session. You must upload the file to the On Demand server first (Studio can do this) and then use the path on the server in your code. You can get the complete path through the properties of the file by right-clicking on it in the file navigation tab of SAS Studio.
... View more
You can log on to the server‘s commandline and use the ps command (or the Windows equivalent) to display the process status; by filtering for your username you can find your SAS session. As admin, I provided a web page which ran such a command and displayed the top 10 processes in terms of CPU consumption, so it was easier for the SAS users to see if they had accidentally created a runaway process.
... View more
How users authenticate is configured in the metadata server through the authentication domain(s). The default authentication domain is usually configured to check against the underlying operating system's authentication system. When users are configured to such an AD, SAS user == OS user. Different AD's can use other sources, e.g. LDAP-based.
When users authenticate to a SAS service is recorded in the metadata server logs.
... View more
You write that you want to flag whole ID's, but then you have the flags set only for particular observations within an ID.
Please describe in detail for every observation in your result dataset why the flag is set as it is.
Post this in a new answer, do not modify your original post! This is needed so it's easier to follow the flow of discussion.
... View more
Save to a CSV file and read that with a DATA step. Both the "real" and character datetime values will appear in the same format, so you can read them with the E8601DT informat.
Disclaimer: I tested the "save to csv" with LibreOffice on a Mac, but I sincerely hope MS Excel will do the same.
... View more
