05-25-2021
loishaggard
Fluorite | Level 6
Member since
06-07-2019
- 9 Posts
- 0 Likes Given
- 0 Solutions
- 1 Likes Received
-
Latest posts by loishaggard
Subject Views Posted 1250 05-25-2021 07:12 PM 1279 05-25-2021 06:05 PM 1310 05-25-2021 04:19 PM 1327 05-25-2021 03:58 PM 1710 12-09-2020 12:35 PM 1836 12-08-2020 07:06 PM 1867 12-08-2020 06:43 PM 665 08-16-2020 09:11 PM 716 08-16-2020 07:53 PM -
Activity Feed for loishaggard
- Got a Like for Re: Syntax incorrect?. 05-25-2021 07:23 PM
- Posted Re: Syntax incorrect? on SAS Programming. 05-25-2021 07:12 PM
- Posted Re: Syntax incorrect? on SAS Programming. 05-25-2021 06:05 PM
- Posted Re: Syntax incorrect? on SAS Programming. 05-25-2021 04:19 PM
- Posted Syntax incorrect? on SAS Programming. 05-25-2021 03:58 PM
- Posted Re: Filter records after a certain date found on another record on SAS Programming. 12-09-2020 12:35 PM
- Posted Re: Filter records after a certain date found on another record on SAS Programming. 12-08-2020 07:06 PM
- Posted Filter records after a certain date found on another record on SAS Programming. 12-08-2020 06:43 PM
- Posted Re: filter by dates within by-group? on SAS Programming. 08-16-2020 09:11 PM
- Posted filter by dates within by-group? on SAS Programming. 08-16-2020 07:53 PM
-
My Liked Posts
Subject Likes Posted 1 05-25-2021 07:12 PM
05-26-2021
03:50 PM
!= is gibberish. You can use ^= or ~= (or if you are on a mainframe the actual not character) or not =
397 data test;
398 set sashelp.class ;
399 where age ~= 13;
400 run;
NOTE: There were 16 observations read from the data set SASHELP.CLASS.
WHERE age not = 13;
NOTE: The data set WORK.TEST has 16 observations and 5 variables.
But I am not sure why SAS macro is not throwing an error on that expression.
To the macro processor %EVAL() function the ! is just the last character in the string to the left of the equal sign.
Why not have the program that is evaluating the %name% syntax just test the value and then conditionally generate the SAS code instead of trying to use the SAS macro processor?
... View more
12-09-2020
12:35 PM
Thanks so much, everyone, But so far, no go. The mkeintz novinosrin solutions deleted appropriate records for any patient who had had a positive test, and also all records for patients who had not had any positive test. Those latter records need to be maintained in the dataset. The hhinohar solution yielded a dataset with 33 records with missing values for every variable on every record. There was a problem reading in PATIENT_ID. I'll look more into it. The solution, using the data provided, should delete the 18 records marked with "delete," yielding a dataset with 82 records. It should maintain all the records for patient ID that never had a positive result, as well as the records with the positive results, and the records for patients with a positive result for which the specimen was collected before the date of the positive result. Thanks again for you efforts!
... View more