I have the following data, How I can create the multiple records based on the horizontal data , depening on the time variables. thank you for your help.
Assumptions:
1. if all four time vairables avaialble then need two records with startdate time and stopdate time depending the on the time
Example first and second rows. only difference between first and second row is column D and E have same time
2. when "restarttime" missing consider the "intermediatestopTime as "restarttime"( and vice versa) and create two records.
3. when "intermediatestoptime" and "restartime" missing then create one record for "stopdatetime" and "startdatetime".
data have;
format date date9. starttime time8. intermediatestoptime time8. restarttime time8. finalstoptime time8.;
do i = 1 to 4;
usubjid = "00-01";
date = '01OCT2024'd;
/* Generate different times for each record */
starttime = '12:20:00't + (i-1)*600; /* Increment start time by 10 minutes each iteration */
intermediatestoptime = starttime + 600; /* Intermediate stop time is 10 minutes after start time */
restarttime = intermediatestoptime + 600; /* Restart time is 10 minutes after intermediate stop time */
finalstoptime = restarttime + 600; /* Final stop time is 10 minutes after restart time */
output;
end;
drop i;
run;
data have1;
set have;
if _n_ =2 then restarttime = '12:40:00't;
if _n_ =3 then restarttime = '';
if _n_ =4 then do; restarttime = '';intermediatestoptime='';end;
run;
... View more
Hi, I am new to SAS. I want to create a geo-map displaying frequency of occurrences of something. but it should be able to access countries, states and cities in the map. I tried with geo-hierarchy. But after creating the geo map, it was not drillable to states and cities. Only displaying country info on the map. Help me if you know how to do this. Appreciate your help.
... View more
Obs months 1 2 2 2 3 6 4 2 I want to merge the dataset above with other datasets based on value of months variable. For example, I want to merge two months of data for the first record, two months of data for the second record, 6 months of data for the third record, and 2 months of records for the fourth record. Is there a systematic way of doing it? I was thinking about creating a variable based on the months variable and create a loop within a macro to achieve it.
... View more
Dear expert,
I would like to check if there are compatibility issues found in RHEL. We have a different SAS9M5 system that runs on RHEL6 and 8.
We use the same set of setenv.yaml but found that there are errors in running applicationUsage on the RH8 one. No problem was found on the RH6 one.
The error is that "The specified SAS configuration directory does not appear to contain an accessible Object Spawner logs directory".
We already checked the directory and file permission is working fine.
Any idea if you have?
... View more
I am struggling to manage files in SAS OnDemand for Academics. Among other things, I am getting a message telling me I have reached the storage limit. In an effort to free up space I have started to delete files, folders and datasets.
Do I have to delete every single file one by one? Is there a way to delete a folder that is not empty?
Is there is a trash bin I need to empty? I deleted many datasets and I'm still getting the same error message ("Your home directory is full. ".
Is there a way to determine the size of a folder or file? I'd like to find the largest folders and start there.
How can I determine how much space is currently being utilized?
Thanks.
... View more