About urban58

urban58 · ‎08-09-2022

Thanks for all your help with the code and the caution explanation - much appreciated!

urban58 · ‎08-08-2022

your code is just great ballardw, it answered my question exactly - sorry for the late response. Is there a way I can display the %s so the largest is 1st, etc. Maggie

urban58 · ‎08-08-2022

a report would be great

urban58 · ‎08-05-2022

Thank you ballardw, I will use this code on my data and ask if I don't understand something or accept as the solution your response. Maggie

urban58 · ‎08-05-2022

Thanks PaigeMiller for your reply. The data has variables brain heart liver stomack llung lkidney lovary rlung rkidney rovary ucolon lcolon llung, rlung need to be put as lung, same for lkidney, rkidney, etc. How do do that before calculating the frequencies? Thanks, Maggie

urban58 · ‎08-05-2022

Hello SAS community, I have a large dataset with lots of variables - see a sample below Data have; input id brain heart liver stomack llung lkidney lovary rlung rkidney rovary ucolon lcolon; cards ; 1 1 0 1 0 1 0 0 0 1 0 1 1 2 0 0 0 1 0 1 0 0 0 1 0 1 3 0 1 0 0 1 0 1 1 1 0 0 0 4 0 0 0 0 0 1 0 0 0 0 0 1 5 1 1 1 1 1 1 1 1 1 1 1 1 6 0 0 1 0 0 0 0 0 1 0 1 1 7 0 0 1 1 0 0 0 0 0 0 0 0 8 1 1 1 1 0 0 0 1 1 1 0 1 9 0 1 0 1 0 0 0 0 0 0 0 0 10 0 0 0 0 1 1 1 1 0 1 1 0 ; run; desired output Body part % with XXX=1 Brain Heart Liver Stomack Lung Kidney Ovary Colon Appreciate any help! Maggie

urban58 · ‎07-14-2022

It is much simpler - thank you and it works beautifully with my actual dataset. Much appreciated! Margaret

urban58 · ‎07-14-2022

I have a SAS dataset with a non formatted "visit" variable that I want to make numeric but keep the character information proc format; value $visit 1 ="1:offsite" 2 ="2:hospital" 3 ="3:remote" .='.'; run; data have; input id 1 visit $ 2-10; datalines; 1 hospital 2 offsite 3 hospital 4 remote 5 6 hospital 7 remote 8 hospital ; run; data want; set have; if visit='offsite' then visit=1; else if visit='hospital' then visit=2; else if visit='remote' then visit=3; else visit=.; format visit $visit.; run; proc freq data=want; tables visit / list ; run; output visit Frequency Percent Cumulative Frequency Cumulative Percent . 1 12.50 1 12.50 1 1 12.50 2 25.00 2 4 50.00 6 75.00 3 2 25.00 8 100.00 Instead I would like to see visit Frequency Percent Cumulative Frequency Cumulative Percent . 1 12.50 1 12.50 1:offsite 1 12.50 2 25.00 2:hospital 4 50.00 6 75.00 3:remote 2 25.00 8 100.00 I will get the output I want if I do this and remove proc format - is this the only way I can do it? I would like to have visit as a numeric variable data want;length visit $10; set have; if visit='offsite' then visit="1:offsite"; else if visit='hospital' then visit="2:hospital"; else if visit='remote' then visit="3:remote"; else visit=.; format visit $visit.; run; Would appreciate any help. Margaret

urban58 · ‎06-27-2022

Thank you Paige for your reply which of course would have been the correct way to do it starting out. Margaret

urban58 · ‎06-27-2022

Thank you Tom for you quick comprehensive reply. I like your answer as I don't have to make changes to other variables I've created from these timestamps and it works beautifully. Also thanks for thinking of the rounding function as that was my next thought when I saw the output! Really appreciate it. Margaret

urban58 · ‎06-27-2022

Hello SAS community, I'm trying to find the minutes between 2 timestamps (both character variables) in a large SAS dataset I received, e.g. id starttime endtime 1 2021-10-27 10:11:01 2021-10-27 10:19:33 I know intck function can do it but all the examples I see have date in a date9 format mins_between = intck('minute',starttime,endtime); but I just get Character values have been converted to numeric values at the places given by: (Line):(Column). 171:31 171:46 NOTE: Invalid numeric data, starttime='2021-10-27 10:11:01' , at line 171 column 31. NOTE: Invalid numeric data, endtime='2021-10-27 10:19:33' , at line 171 column 46. Can someone please help! Thanks, Margaret

urban58 · ‎07-19-2021

Hello SAS community, I have the following data and would like to be able to track project tasks and deliverables by analyst. What is the best way to structure the data and how do I do it? task variables deliverable variables id repeat_instrument repeat_instance project_id project_status task_start_date analyst task_status task_complete deliverable submission_status 1 AP-0001 5 1 task 1 9/10/2018 Chen, M 3 2 1 task 2 7/29/2020 Paul, D 3 2 2 AP-0002 1 2 task 1 2/6/2019 Sun Y 3 2 2 task 2 6/7/2019 Cody, B 1 2 2 task 3 6/26/2019 Cody, B 3 2 2 task 4 11/20/2019 Cody, B 3 2 2 task 5 11/20/2019 Cody, B 3 2 2 task 6 11/21/2019 Cody, B 3 2 2 task 7 11/21/2019 Cody, B 3 2 2 deliverable 1 1 2 2 deliverable 2 1 1 3 AP-0004 1 4 AP-0005 3 4 task 1 11/23/2020 Rawl, B 3 2 4 deliverable 1 9 Thanks, Maggie

urban58 · ‎07-18-2021

So, what would be a better way to structure data like this for for counting, modeling, just about any analysis or graphing?

urban58 · ‎03-04-2021

Sorry my explanation is not clear. 99 means the subject would not do the test(s) when trial data for test1 and/or test2 is missing (no value) the subject could be ineligible, tester did not do the test or something else I need to report frequencies of subjects who have tests with 10's and 99's (so far if 1 test trial =10/99 then all trial data for that test is the same) Test1 - see example wanted output testm1 Frequency Cumulative Frequency . 1 1 0='0-<10' 10 11 1='10 1 12 2='99' 1 13 For want2 - analysis (means, mean comparisons by tester, etc.), I need to Make 99’s missing Be able to do a sensitivity analysis by including/excluding subjects with tests= 10 Maybe this? proc means; where testm1=0;* excludes 10’s; proc means; where testm1=1;* includes 10’s; does that help?

urban58 · ‎03-03-2021

Except when tracking 99's (investigators want to know frequencies), it will be treated as missing

Online Status	Offline
Date Last Visited	‎10-01-2025 03:01 PM

Re: format variable with same value

format variable with same value

Re: format when recoding

format when recoding

Re: input comma separated row data for one variable

input comma separated row data for one variable

Re: concatenate 2 character vars where there are multiple choices for ...

Re: concatenate 2 character vars where there are multiple choices for ...

concatenate 2 character vars where there are multiple choices for each

Re: how to add content to new variables in a macro list

Re: proc means output in descending and ascending order

Re: proc means output in descending and ascending order

format missing

Re: calculate frequencies

Re: calculate frequencies

Re: calculate frequencies

Re: calculate frequencies

Re: calculate frequencies

calculate frequencies

Re: format character variable

format character variable

Re: calculate minute difference between 2 timestamps (character variab...

Re: calculate minute difference between 2 timestamps (character variab...

calculate minute difference between 2 timestamps (character variables)

how I structure this data

Re: SAS Retain

Re: How do I track missing vs values that mean missing

Re: How do I track missing vs values that mean missing