About Aidaan_10

Aidaan_10 · ‎06-12-2023

Thanks Tom...this worked.

Aidaan_10 · ‎06-12-2023

Hi, I am trying to round multiple variables from below dataset B. Dataset A is my reference dataset with rounding requirements for decimal places. Below in this dummy data I have less number of variables but in real data there are many variables, the following code works as expected for less variables but for lot of variables I am getting the below error: ERROR: The length of the value of the macro variable LGT_MACRO (65540) exceeds the maximum length (65534). The value has been truncated to 65534 characters. Can someone please help me fixing the above error. Example datasets are below /*Dataset A:*/ /*If not an integer then round to number of decimal places from Var1 column*/ data a; informat var1 $50. length $10. var2 $200.; infile datalines delimiter=','; input var1 length var2 ; datalines; NotAvailable,8,Subject NotAvailable,8,Site NotAvailable,$200,Visit integer,8,Age 0.0001,8,Score1 integer,8,Score2 NotAvailable,$200,Date 0.00001,8,Score_3 NotAvailable,$200,I_am_the_longest_variable_Test_3 ; run; /*dataset B:*/ data b; informat Visit $200. Date $200. I_am_the_longest_variable_Test_3 $200.; infile datalines delimiter=','; input Subject Site Visit Age Score1 Score2 Date Score_3 I_am_the_longest_variable_Test_3 ; datalines; 1234,001,Day1,55,344.70452025162167,4,2023-06-08 15:37,4.5707963267948966,ABCD 2456,002,Day5,45,100.12342025162167,3,2023-06-09 15:37,3.1234907586284892,WXYZ 3456,003,Day1,60,94.38627492995121,2,2023-06-10 15:37,5.7398282916662683,ABCD 7890,001,Day5,52,92.28219778353588,1,2023-06-08 15:37,3.749207747474,WXYZ 1111,002,Day1,70,124.6789456782671,3,2023-06-09 15:37,4.172819191919191,ABCD 1567,003,Day1,59,125.4796290763492,5,2023-06-10 15:37,1.272383939999,WXYZ ; run; data a1; set a; if index(length,'$')>0 or UPCASE(var1)='NOTAVAILABLE' then ; else if UPCASE(var1)='INTEGER' then Rnd_var=0; else If UPCASE(var1)='0.0001' then Rnd_var=0.0001; else If UPCASE(var1)='0.00001' then Rnd_var=0.00001; else If UPCASE(var1)='NOTAVAILABLE' then Rnd_var=.; run; data sample_formats; set a1; format length_macr0 $100. ; if index(length,'$')> 0 or UPCASE(var1) in ('NOTAVAILABLE') then length_macr0=''; else length_macr0=cat(compress(var2),'=','round(',compress(var2),',',compress(rnd_var),')') ; run; proc sql; select length_macr0 into :lgt_macro separated by ";" from sample_formats where length_macr0 is not missing ; %put length_macr0; data test; set b; &lgt_macro. ; run;

Aidaan_10 · ‎01-15-2022

Thanks a ton Patrick, this is what I wanted. I was trying to achieve this via so many lag statements and flagging variables and all but this is great. Thanks again.

Aidaan_10 · ‎01-14-2022

Apologies for posting the data in that manner. And Yes, you are right the logic is too complex then mentioned above the 16FEB2021 previous date record is the eligible record and the records after that are ineligible and the next eligible record will be the 24FEB2021 so basically we are not looking for just previous record date but we are looking for the eligible records previous date for next current record.

Aidaan_10 · ‎01-14-2022

I tried to get the prior previous_Date from the valid eligible record.

Aidaan_10 · ‎01-14-2022

Hi, I have attached some example input and output datasets. So here the Start_date for ids's done after the first one must be later than the previous_date. If Start_date for the current record is before or equal to the previous previous_date, I need to remove the record. Then I need to create a sequence number for each record within ID, where Counter resets for each new ID. After the first record I need to look to the previous date from second record onwards and create a sequence. Taking EFG ID as an example : the record with start_date 10DEC2021 wont be an eligible record because the previous_date for previous record is 12dec2021 so the current records start date(10dec2021) is before the previous records previous date thus this record is excluded. And for 13DEC2021 startdate record it will be eligible record whereas 16DEC2021 wont be eligible record as the date of previous eligible record previous_date(16DEC2021) is equal to this current records start_date. I tried using lag and counting the rows but with lag its an lengthy procedure to count all previous rows. Input dataset: ID Start_date Previous_date ABC 03AUG2020 08AUG2020 ABC 11AUG2020 12AUG2020 ABC 03NOV2020 05NOV2020 ABC 09NOV2020 16FEB2021 ABC 20NOV2020 24NOV2020 ABC 07DEC2020 13DEC2020 ABC 17DEC2020 24DEC2020 ABC 25JAN2021 29JAN2021 ABC 24FEB2021 15MAR2021 ABC 18MAR2021 22MAR2021 ABC 12APR2021 15APR2021 ABC 14APR2021 16APR2021 ABC 20APR2021 28APR2021 ABC 19MAY2021 26MAY2021 EFG 08MAR2021 10MAR2021 EFG 08APR2021 15APR2021 EFG 30APR2021 06MAY2021 EFG 18MAY2021 25MAY2021 EFG 20AUG2021 23AUG2021 EFG 08SEP2021 10SEP2021 EFG 06OCT2021 07OCT2021 EFG 22NOV2021 23NOV2021 EFG 07DEC2021 12DEC2021 EFG 10DEC2021 13DEC2021 EFG 13DEC2021 16DEC2021 EFG 16DEC2021 21DEC2021 ; The output should be ID Start_date Previous_date Seq ABC 03AUG2020 08AUG2020 1 ABC 11AUG2020 12AUG2020 2 ABC 03NOV2020 05NOV2020 3 ABC 09NOV2020 16FEB2021 4 ABC 24FEB2021 15MAR2021 5 ABC 18MAR2021 22MAR2021 6 ABC 12APR2021 15APR2021 7 ABC 20APR2021 28APR2021 8 ABC 19MAY2021 26MAY2021 9 EFG 08MAR2021 10MAR2021 1 EFG 08APR2021 15APR2021 2 EFG 30APR2021 06MAY2021 3 EFG 18MAY2021 25MAY2021 4 EFG 20AUG2021 23AUG2021 5 EFG 08SEP2021 10SEP2021 6 EFG 06OCT2021 07OCT2021 7 EFG 22NOV2021 23NOV2021 8 EFG 07DEC2021 12DEC2021 9 EFG 13DEC2021 16DEC2021 10 ; Any help is greatly appreciated. Thanks In Advance.

Aidaan_10 · ‎03-11-2020

Hi, I have an csv excel file with lot of columns. I need to import this file and when I import it not all variables are imported as expected...that's because some of the columns length exceeds more than 32 characters...So suppose this example variable has a name valid_sas_long_variablenumber_one with length of 33 and then there is another similar variable called valid_sas_longvariablenumber1 with length of 28 so in my imported dataset the other longer length variable is getting overwritten and sas is considering only one variable valid_sas_longvariablenumber1. Is there a work around for this one. Can someone please help. I have numerous variables like this. Thanks, Rasikha

Aidaan_10 · ‎10-01-2019

Sorry Reeza*

Aidaan_10 · ‎10-01-2019

Hi Raeza, Here is my sample code which I tried.. proc template; define statgraph seriesplot ; begingraph ; dynamic yvar Ymin Ymax Yinc ref thk ; layout overlay / xaxisopts=(type=discrete display=(ticks tickvalues line) ) yaxisopts=(griddisplay=on linearopts=(viewmin=Ymin viewmax=Ymax tickvaluesequence=(start=Ymin end=Ymax increment=Yinc))) ; layout gridded / rows=1 order=columnmajor border=false autoalign=(top); endlayout ; referenceline y=ref / datatransparency=.80 lineattrs=(thickness=thk) ; seriesplot x=visit y=yvar/ group=paramcd groupdisplay=cluster clusterwidth=.5 name="seriesplot1" ; scatterplot x=visit y=yvar / group=paramcd groupdisplay=cluster clusterwidth=.5 name="scatterplot1" ; layout gridded / rows=1 order=columnmajor border=false autoalign=(bottom); endlayout ; mergedlegend "seriesplot1" "scatterplot1" ; endlayout; endgraph; end ; run; proc sgrender data=mydata template=seriesplot; dynamic yvar='col1' Ymin=-2 Ymax=+5 Yinc=0.5 ref=100 thk=109 ; where col1 > . ; run;

Aidaan_10 · ‎09-28-2019

Hi All, I have limited knowledge about SAS Graph/plots and I am stuck at one of the exercise's for the same. Using proc template and SGrender I have created a series and scatter plot for patient's BP over visit (for the patient with whom the selected visit is associated) and computed relative to the user defined comparator visit. In this plot, X axis displays Visit's. Y axis display BP. 1) How do I Create this USER DEFINED comparator visit? 2) There should be an asterisk next to the name of the selected visit...I tried doing it using proc format and assigning an asterik in the format to the visit but this cant be done... as with different run the visit of interest might change.. 3) I also want to apply shading to the plot as per the range's.How do I do this?? Any help will be greatly appreciated. THANKS

Aidaan_10 · ‎09-23-2019

new_var=vvalue(old_var) worked very well. Thank you so much

Aidaan_10 · ‎09-23-2019

Hi, I have a date variable with the value as '7/30/2019 14:43' and I want to convert it into a character variable keeping the same format how do I do this? Any help will be greatly appreciated. Thanks,

Aidaan_10 · ‎03-03-2019

Hi Patrick visit or study date is not considered...I just need the results for baseline calculations.

Aidaan_10 · ‎03-03-2019

Any help please

Aidaan_10 · ‎02-26-2019

My expected final output would be like for study XYZ( third study): STUDYID SUBJID TEST VISIT RESULT XYZ 1 ABC DAY1 5678(Final result from study1 ABC) XYZ 1 ABC DAY2 32457 XYZ 1 ABC DAY3 32457(Day2 result is being populated here) XYZ 1 ABC WEEK1 32457(Day2 result is being populated here) XYZ 1 ABC WEEK2 13845 XYZ 1 ABC WEEK3 13845(WEEK2 result is being populated here) XYZ 1 ABC WEEK4 13845(WEEK2 result is being populated here) XYZ 1 ABC EW 45890 If suppose DAY1 is missing result in study3 we go back to study2 study RWA( second study): STUDYID SUBJID TEST VISIT RESULT RWA 1 ABC DAY1 missing RWA 1 ABC DAY2 32457 RWA 1 ABC DAY3 12456 RWA 1 ABC WEEK1 3456 RWA 1 ABC WEEK2 13845 RWA 1 ABC WEEK3 1.12 RWA 1 ABC WEEK4 0.00 RWA 1 ABC EW 45890 So If the result is still missing for DAY1 from second study we go back to First study(ABC) for the result. study ABC( First study): STUDYID SUBJID TEST VISIT RESULT ABC 1 ABC DAY1 5678 ABC 1 ABC DAY2 32457 ABC 1 ABC DAY3 12456 ABC 1 ABC WEEK1 3456 ABC 1 ABC WEEK2 13845 ABC 1 ABC WEEK3 1.12 ABC 1 ABC WEEK4 0.00 ABC 1 ABC EW 45890

Online Status	Offline
Date Last Visited	‎07-01-2023 11:50 AM

Re: SAS Macro error

SAS Macro error

Re: Looking back to get eligible records

Re: Looking back to get eligible records

Re: Looking back to get eligible records

Looking back to get eligible records

Longer variable name...more than 32 characters.

Re: SAS Graphs/Plots

Re: SAS Graphs/Plots

SAS Graphs/Plots

Re: SAS Macro error

SAS Macro error

Re: Looking back to get eligible records

Re: Looking back to get eligible records

Re: Looking back to get eligible records

Looking back to get eligible records

Longer variable name...more than 32 characters.

Re: SAS Graphs/Plots

Re: SAS Graphs/Plots

SAS Graphs/Plots

Re: converting date to character string keeping same format

converting date to character string keeping same format

Re: Looking back to get records...

Re: Looking back to get records...

Re: Baseline calculation...