About SAS-PD

SAS-PD · ‎05-01-2025

Hi Tom, Thank you very much for all your help and suggestions! This code worked too as per my current requirement I was able to solve with your and dxaio2017 's help 🙂

SAS-PD · ‎05-01-2025

Hi dxaio2017, Thank you very much for all your help! I appreciate your time and efforts. This code worked 🙂

SAS-PD · ‎04-24-2025

Hello dxiao2017 , Thank you very much for looking into this. While creating vdfmtchg, I am getting below error now ... NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 64:7 NOTE: Invalid argument to function INPUT at line 64 column 18. ------------------------------------- could it be due to some dates has uu or u or (alphabets) in char dates? If so, how do I solve this? Thanks for following up!

SAS-PD · ‎04-23-2025

Thanks for explaining all the scenarios. Is there a way to check those DAT variables only? That way I will only have all character dates to find min and max? Also, how do I create CHARLIST and NUMLIST macro variable?

SAS-PD · ‎04-23-2025

Thank you, Tom! I changed the code to take dates that are ending with DAT as per requirement and those happens to be character string dates (example 4/26/2023). what changes to be made in code to convert all those character dates to resolve the error?

SAS-PD · ‎04-22-2025

Thank you for all the explanation. now, I am getting Invalid numeric data, testDAT='6/6/2023' error All my dates are char $24.

SAS-PD · ‎04-22-2025

Thanks again! Your code works with test data, however while using my datasets it is giving ERROR: BY variables are not properly sorted on data set Could you please guide?

SAS-PD · ‎04-21-2025

Thank you, Tom! I apologize...I think I gave wrong sample datasets as date variables name is not static. I am trying to find min and max of the date per subject from all datasets in a library where variable ends with 'DAT' in one library, I have 50+ datasets that has 120+ date variables named with 'DAT' Among all those 120+ dates I need to find out min and max of the date per subject

SAS-PD · ‎04-18-2025

Hello, I am trying to find min and max of the date per subject from all datasets in a library I have created I have created DateVariables dataset using proc content to list all date variables from table1 and table2. *Want1; *I would like to list all dates available for the subject in entire library; /*subjID date11 date12 date13 date21 ...(all dates available)*/ subjID date11 date12 date13 date21 --------------------------------------------------------------------------- subj1 01/01/21 01/01/22 01/01/23 02/02/02 subj2 02/01/21 02/01/22 02/01/23 *want2; *find min and max of the date by subjID ; subjID date_min date_max ------------------------------------------------------------ subj1 02/02/02 01/01/23 subj2 02/01/21 02/01/23 data d_test.table1; infile datalines ; input subjID $ ar5 $ var6 $ date11: ddmmyy10. date12: ddmmyy10. date13: ddmmyy10.; format date11 mmddyy10. date12 mmddyy10. date13 mmddyy10.; datalines; subj1 xxx sy 01/01/21 01/01/22 01/01/23 subj2 xttx ry 02/01/21 02/01/22 02/01/23 ; run; data d_test.table2; infile datalines ; input subjID $ var3 $ date21: ddmmyy10.; format date21 mmddyy10.; datalines; subj1 xx 02/02/02 subj2 z . ; run; *list all date variables from table1 and table2; data d_test.DateVariables; infile datalines ; input table $ varname $ ; datalines; table1 date11 table1 date12 table1 date13 table2 date21 table3 date31 table3 date32 table3 date33 table3 date34 ; run; Thanks for your guidance!

SAS-PD · ‎09-06-2024

Hello, Thank you!! Proc transpose worked 🙂 just got the request updated-- I would like to get all other variables present in the dataset like result, unit, range etc. along with the SubjectID and test name. All corresponding lab variables are labeled as Result1-13, Unit1-13, Range1-13 like Lab1-13 data Lab; infile datalines; input Subjid $ Lab1 Lab2 Lab3 Lab4 Lab5 Lab6 Lab7 Lab8 Lab9 Lab10 Lab11 Lab12 Lab13 Result1 Result2 Result3 Result4 Result5 Result6 Result7 Result8 Result9 Result10 Result11 Result12 Result13 ; datalines; Subj1 1 3 3 1 1 1 1 2 . 1 1 1 1 01 02 03 04 05 06 07 08 . 010 011 012 013 Subj2 1 1 1 1 1 1 1 1 1 1 1 . 3 011 012 013 014 015 016 017 018 019 0110 0111 . 0113 ; run; Get ALL respective variables like result, unit, range etc. for the records with Any Lab from 1 to 13 has value 3 Data Want; Subject Lab Name Lab Result Lab Units etc.. -------------------------------------------------- Subj1 Lab2 02 Subj1 Lab3 03 Subj2 Lab13 0113

SAS-PD · ‎09-05-2024

Hello, I have 13 different labs for each subject; I need to list all lab test name as a list for each where value is 3 data Lab; infile datalines; input Subjid $ Lab1 Lab2 Lab3 Lab4 Lab5 Lab6 Lab7 Lab8 Lab9 Lab10 Lab11 Lab12 Lab13 ; datalines; Subj1 1 3 3 1 1 1 1 2 . 1 1 1 1 Subj2 1 1 1 1 1 1 1 1 1 1 1 . 3 ; run; Get records with Any Lab from 1 to 13 has value 3 data lab_1; set Lab ; where (Lab1 = 3 OR Lab2 = 3 OR Lab3 = 3 OR Lab4 = 3 OR Lab5 = 3 OR Lab6 = 3 OR Lab7 = 3 OR Lab8 = 3 OR Lab9 = 3 OR Lab10 = 3 OR Lab11 = 3 OR Lab12 = 3 OR Lab13 = 3 ); run; Need help to display Lab Name as separate records if value = 3 Data Want; Subject Lab Name ---------------------- Subj1 Lab2 Subj1 Lab3 Subj2 Lab13 Thanks,

SAS-PD · ‎06-12-2024

Thank you very much, Mazi It worked like a charm 🙂 Appreciate your time and efforts!

SAS-PD · ‎06-11-2024

Hi, could you please help me with define an array over the date variables and run a check in a loop ?

SAS-PD · ‎06-11-2024

Hi Mazi, may I please have the updated version?

SAS-PD · ‎06-10-2024

Is there a way to use dataset name and date variable from proc contents data = d_test._all_ out=content; run; data content1; set content; where format = 'MMDDYY' and name ^= 'EDIT_DATE'; keep libname memname name label n; n+1; run;

Online Status	Offline
Date Last Visited	‎05-05-2025 12:54 PM

Re: find min and max of the date per subject in entire library

Re: find min and max of the date per subject in entire library

Re: find min and max of the date per subject in entire library

Re: find min and max of the date per subject in entire library

Re: find min and max of the date per subject in entire library

Re: find min and max of the date per subject in entire library

Re: find min and max of the date per subject in entire library

Re: find min and max of the date per subject in entire library

find min and max of the date per subject in entire library

Re: display separate record for each condition that is satisfied

Re: find min and max of the date per subject in entire library

find min and max of the date per subject in entire library

Re: find min and max of the date per subject in entire library

Re: fetch each subjects corresponding records from multiple datasets i...

Re: find min and max of the date per subject in entire library

Re: find min and max of the date per subject in entire library

Re: find min and max of the date per subject in entire library

Re: find min and max of the date per subject in entire library

Re: find min and max of the date per subject in entire library

Re: find min and max of the date per subject in entire library

Re: find min and max of the date per subject in entire library

Re: find min and max of the date per subject in entire library

find min and max of the date per subject in entire library

Re: display separate record for each condition that is satisfied

display separate record for each condition that is satisfied

Re: fetch each subjects corresponding records from multiple datasets i...

Re: fetch each subjects corresponding records from multiple datasets i...

Re: fetch each subjects corresponding records from multiple datasets i...

Re: fetch each subjects corresponding records from multiple datasets i...