topic Re: FLAG ALL THE RECORDS OF A SUBJECT WITH THE VALUE IF ATLEAST ONE VALUE IN A VARIABLE IS NON MISSI in SAS Programming

FLAG ALL THE RECORDS OF A SUBJECT WITH THE VALUE IF ATLEAST ONE VALUE IN A VARIABLE IS NON MISSING!!

sandhya88 — Thu, 02 Mar 2023 12:13:35 GMT

DATA HAVEDATA WANT

In the above images the data that i have is on the left side in a table where only few records are having CRITFl populated for the ID.

The image on the right is what i want to achieve populating the value of critfl across all the records of the ID.

Any Suggestions are grateful.

TIA

Re: FLAG ALL THE RECORDS OF A SUBJECT WITH THE VALUE IF ATLEAST ONE VALUE IN A VARIABLE IS NON MISSI

PaigeMiller — Thu, 02 Mar 2023 12:45:04 GMT

What happens if the ID has both Y and N? What happens if the ID has neither Y nor N?

Please do not type in ALL CAPITALS.

Please provide example data as SAS data step code, which you can type in yourself or you can get by following these instructions (and not via screen captures or via file attachments). We cannot write code to read screen captures.

Re: FLAG ALL THE RECORDS OF A SUBJECT WITH THE VALUE IF ATLEAST ONE VALUE IN A VARIABLE IS NON MISSI

sandhya88 — Thu, 02 Mar 2023 13:55:52 GMT

Data have;
input ID$ PARAMCD$ RESULT BASERSLT CRITFL$;
datelines;
004	ALT	       0.03	 0.03	
004	ALT	       0.06	 0.03	
004	AST	       0.03	 0.03	
004	CHOL      0.03	 0.03	
004	4HCHOL	  0.03	 0.03	
004	ALT	      0.12	 0.03        Y
004	LIPA	  0.09	 0.09	
005	ALT   	  0.03	 0.03	
005	AST	      0.06	 0.04	
005	CHOL	  0.03	 0.03	
005	4HCHOL	  0.03	 0.03	
005	ALT	      0.06   0.03	     N
005	LIPA	  0.12	 0.12	
;
Data want;
input ID$ PARAMCD$ RESULT BASERSLT CRITFL$;
datelines;
004	ALT	      0.03	 0.03	Y
004	ALT	      0.06	 0.03	Y
004	AST	      0.03	 0.03	Y
004	CHOL      0.03	 0.03	Y
004	4HCHOL	  0.03 0.03	Y
004	ALT	        0.12	  0.03   Y
004	LIPA	  0.09	 0.09	Y
005	ALT   	  0.03	 0.03	N
005	AST	      0.06	 0.04	N
005	CHOL	  0.03	 0.03   N	
005	4HCHOL	  0.03	 0.03   N	
005	ALT	      0.06   0.03	N
005	LIPA	  0.12	 0.12	N;



1.CRITFL for the ID will have either "Y" or "N" and not a combination and hence if at least one record of ID has a "Y" or "N" or even "" i want to see that being retained to all the other records of the ID.


Hope this is a bit helpful and apologies for the attachments.

Thanks