cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
ChuksManuel
‎06-17-2023
  • 220 Posts
  • 59 Likes Given
  • 0 Solutions
  • 1 Likes Received

Re: Stringing

by Pyrite | Level 9 in SAS Programming
‎06-06-2019 03:20 PM
‎06-06-2019 03:20 PM
Thanks Cynthia,   Here's a datastep to create a dataset one.   data one; input GEND BMI AGE STRESS1 STRESS2 STRESS3 STRESS4 STRESS5 STRESS6 STRESS7 STRESS8 STRESS9 STRESS10 STRESS11 STRESCOR cursmoke exsmoke primstnd Lia injury iD; datalines; 0 25.8272 56 2 4 3 2 1 2 2 2 3 2 2 32 1 0 0 1.93 0 905 0 22.3154 24 2 4 3 2 2 3 2 4 4 2 2 37 1 0 1 0.10 0 906 1 25.0594 38 4 4 4 4 1 2 2 2 3 2 3 39 1 0 1 0.45 0 907 0 24.8092 29 3 4 3 3 2 2 2 2 2 3 2 34 1 0 1 0.10 0 908 1 . 41 3 4 4 4 2 3 4 4 4 3 2 47 1 0 1 1.36 1 909 1 33.2816 44 1 4 2 1 2 3 2 3 3 2 2 32 0 0 1 1.94 0 910 0 27.5490 35 3 4 4 4 2 3 4 2 2 2 2 39 1 0 1 0.10 0 911 0 22.3779 28 4 4 4 2 3 4 4 3 3 2 2 45 1 0 1 0.10 0 912 0 29.9534 55 1 4 2 2 2 2 3 2 3 2 2 32 1 0 1 0.10 0 913 0 36.3158 62 2 2 2 3 3 3 3 2 3 3 2 35 0 1 1 1.55 0 914 0 23.2635 55 2 2 3 2 1 2 2 2 2 2 2 28 0 1 0 1.78 0 915 0 22.7483 24 3 4 3 3 3 4 3 3 3 2 2 40 0 0 0 0.10 0 916 0 28.4810 63 3 2 3 3 2 2 2 2 2 2 2 31 1 0 0 1.78 0 917 0 24.1292 63 2 3 2 3 3 3 3 3 3 3 2 38 1 0 1 0.10 0 918 0 29.6495 55 3 4 3 4 1 4 4 4 3 2 1 42 0 1 1 0.10 0 919 1 32.5565 27 2 3 3 3 3 2 3 3 3 2 2 36 0 0 1 0.10 0 920 0 31.4002 42 2 4 2 3 2 2 3 4 3 3 2 41 0 1 1 0.10 0 921 0 22.2987 46 2 3 3 2 2 2 2 3 3 3 2 34 0 0 1 0.10 0 922 1 32.7711 55 2 4 2 2 3 1 4 4 4 3 4 43 0 1 1 0.10 0 923 1 20.9825 55 2 3 3 2 2 3 2 2 2 3 2 32 1 0 1 0.10 0 924 0 25.0881 22 2 4 3 3 3 1 2 3 3 2 2 35 1 0 1 0.10 0 925 0 29.2947 65 1 4 1 2 3 2 1 3 2 1 1 27 1 0 1 0.10 0 926 1 31.8854 56 3 3 3 3 3 3 2 3 2 2 2 36 0 0 0 0.10 0 927 0 28.2456 50 2 3 2 3 3 2 3 3 3 3 2 36 1 0 1 2.53 0 928 1 40.2707 56 3 4 3 3 2 3 2 3 2 2 2 34 0 0 1 0.10 0 929 0 30.4683 47 3 3 3 3 2 3 2 3 3 3 2 36 0 1 1 0.10 0 930 1 . 41 2 4 2 2 2 2 2 4 4 3 3 41 1 0 1 0.74 0 933 0 23.6749 45 3 4 2 3 2 2 2 4 4 1 3 38 1 0 1 0.10 0 934 1 36.3158 51 2 4 1 2 2 2 3 4 4 4 4 41 0 0 0 0.10 1 935 0 33.3604 50 2 3 2 1 3 2 1 3 3 2 2 31 1 0 0 0.36 0 936 ; run;   I am trying to string out the 11 stress variables. I am trying to use Testcode and Testname to do this. I crosschecked using proc contents and proc print for the first 10 observations but it's wrong. ... View more

Stringing

by Pyrite | Level 9 in SAS Programming
‎06-06-2019 01:16 PM
‎06-06-2019 01:16 PM
Hello, I want to string 11 stress variables in this order Role Overload (RO) Role Insufficiency (RI) Role Ambiguity (RA) Role Boundary (RB) Responsibility (R) Physical Environment (PE) Vocational Strain (VS) Psychological Strain (PSY) Physical Strain (PHS) Recreation (RE) Rational/Cognitive Coping (RC) Below is my code, it could not run. Here's a shot of my data    code; Proc format ; value testcodefm 1='Gend' 2='BMI' 3='Age' 4='Role Overload (RO)' 5='Role Insufficiency (RI)' 6='Role Ambiguity (RA) ' 7='Role Boundary (RB) ' 8='Responsibility (R) ' 9='Physical Environment (PE)' 10='Vocational Strain (VS)' 11='Psychological Strain (PSY) ' 12='Physical Strain (PHS) ' 13='Recreation (RE)' 14='Rational/Cognitive Coping (RC)' 15='strescor' 16='cursmoke' 17='exsmoke' 18='primstnd' 19='injury' 20='Id' ; data two; set one; array ya gend bmi age stress1 stress2 stress3 stress4 stress5 stress6 stress7 stress8 stress9 stress10 stress11 strescor cursmoke exsmoke primstnd lia injury id ; do over ya ; tc = _I_ ; tn = put(tc,testcodefm.) ; value = ya; output; end; proc print data =two (obs=10) ; run; ... View more

Re: Do loop and arrays

by Pyrite | Level 9 in SAS Programming
‎06-06-2019 11:23 AM
‎06-06-2019 11:23 AM
Thank you!  ... View more

Re: Do loop and arrays

by Pyrite | Level 9 in SAS Programming
‎06-06-2019 11:22 AM
‎06-06-2019 11:22 AM
Thank you. That gave me another perspective on how to do the task. ... View more

Do loop and arrays

by Pyrite | Level 9 in SAS Programming
‎06-06-2019 10:06 AM
‎06-06-2019 10:06 AM
 Hello guys,   I have a data for 11 stress variables. Each item had 4 possible responses (1-4) with “4” indicating the worse stress. I am trying to write a code to print out all subjects who selected "4" for atleast 6 of the 11 items. The part in bold is where i've struggled to do. Any correction will be appreciated.   data one; set mike; array stress stress1-stress11; count=0; do over stress; if stress = 4 then count= count+1; end; proc print; var stress1-stress11 count; where count >=6; run;   Thanks ... View more

Where statement in proc print

by Pyrite | Level 9 in SAS Programming
‎05-30-2019 11:41 AM
‎05-30-2019 11:41 AM
Hello programmers,   I believe this is a minor problem but i can't seem to get my head around it. I obtained a count from an array and i am trying to use the where statement in the proc print to print only observations with a count of atleast 1 (count is atleast 1 if the patient weighs 230lb). Here are my codes: data four; set one; array weight wt1-wt10; count=0; do over weight; if weight gt 230 then count = count +1; end; proc print; var school wt1-wt10; where wt1=1 and wt2=1 and wt3=1 and wt4=1 and wt5=1 and wt6=1 and wt7=1 and wt8=1 and wt9=1 and wt10=1; run;   The first part of the code  ran but for some reasons, i can't get to print what i specified using proc print. Any help will be appreciated.     ... View more

Re: initializing a flag

by Pyrite | Level 9 in SAS Programming
‎05-29-2019 10:03 PM
‎05-29-2019 10:03 PM
This is an inital code that i've written. data three; set tmp1.lesson2emergencyvisits; array cpt $ cpt1-cpt10; a_one=0; a_two=0; a_three=0; a_four=0; a_five=0; do over cpt; if cpt= '99281' then flag= a_one+1; if cpt = '99282' then flag2 = a_two+1; if cpt = '99283' then flag3 = a_three+1; if cpt = '99284' then flag4= a_four+1; if cpt = '99285' then flag5 = a_five+1; end; run; proc freq data= three; table flag; run; proc freq data=three; table flag1*flag2*flag3*flag4*flag5/list; run;   I am trying to create a flag and then  to get all the observations in each flag.   ... View more

initializing a flag

by Pyrite | Level 9 in SAS Programming
‎05-29-2019 08:45 PM
‎05-29-2019 08:45 PM
Hello experts,   I have 10 Cpt codes for emergency visits (cpt1-cpt10). And the ER visit codes are from 99281, 99282, 99283, 99284 and 99285 (in increasing order of patient severity)... I want to find out how many of each of these ER visit codes there are in the dataset. Do i need to use an array and initialize a flag statement? My a subset of my data looks like this   Thanks ... View more

Re: Do loop and mod fuction

by Pyrite | Level 9 in SAS Programming
‎05-23-2019 09:46 PM
‎05-23-2019 09:46 PM
Thank you that worked. ... View more

Re: Do loop and mod fuction

by Pyrite | Level 9 in SAS Programming
‎05-23-2019 09:09 PM
‎05-23-2019 09:09 PM
That's the part i've been struggling with. Any help is appreciated. ... View more

Re: Do loop and mod fuction

by Pyrite | Level 9 in SAS Programming
‎05-23-2019 09:09 PM
‎05-23-2019 09:09 PM
Thanks. I was trying to get the prime numbers between 4 and 300. The code wasn't giving me that.   ... View more

Do loop and mod fuction

by Pyrite | Level 9 in SAS Programming
‎05-23-2019 08:32 PM
‎05-23-2019 08:32 PM
Hello,   I've been trying to write a code to answer this practice question in SAS but i haven't had success. Use a do loop, the mod function and an if-statement to put out all prime numbers between 4 and 300.  Consider a prime number to be any number greater than 3 that is not divisible by 2, 3, 5 or 7.       Here are my codes data one; Do K=4 to 300; if mod(k,2)=0 then output; If mod(k,3)=0 then output; if mod(k,5)=0 then output; if mod(k,7)=0 then output; End; Proc print; run; I had a problem in the results. Please can anyone review these to let me know how best i can modify or get the prime numbers between 4 and 300.   Thanks ... View more

Re: How to convert specific coded categorical data to numerical data

by Pyrite | Level 9 in SAS Programming
‎03-07-2019 05:39 AM
‎03-07-2019 05:39 AM
Thank you. It did not run. ... View more

Re: How to convert specific coded categorical data to numerical data

by Pyrite | Level 9 in SAS Programming
‎03-07-2019 05:32 AM
‎03-07-2019 05:32 AM
None of the solutions worked. Thank you for trying guys i will keep working on it. ... View more

How to convert specific coded categorical data to numerical data

by Pyrite | Level 9 in SAS Programming
‎03-07-2019 04:20 AM
‎03-07-2019 04:20 AM
Hello guys,   I am trying to standardize food questionaire scores in such a way that every level or category corresponds to number of times/ day in my data set. For example, i want number 0 in my dataset to be converted to 0, 1 to 1/30, 2 to 1/15, 3 to 1/7 etc. I tried to write a SAS micro for it. Here's my code   %macro convert_var(var_in,var_out); if &var_in. = 0 then &var_out. = 0; if &var_in. = 1 then &var_out. = 1/30; if &var_in. = 2 then &var_out. = 2/30; if &var_in. = 3 then &var_out. = 1/7; if &var_in. = 4 then &var_out. = 3/7; if &var_in. = 5 then &var_out. = 6/7; if &var_in. = 6 then &var_out. = 1; if &var_in. = 7 then &var_out. = 2.5; if &var_in. = 8 then &var_out. = 4.5; if &var_in. = 9 then &var_out. = 7; %mend; data work.fooddata; %convert_var(T1,i_T1) %convert_var(T2,i_T2) %convert_var(T3,i_T3) %convert_var(T4,i_T4) run;   I ran this code for the first 4 variables that i wanted to convert and it gave me this as my dataset. Note the intial content (before i ran the code) and final content of my dataset(after i ran the code).    I will be glad to get help on how to modify my code....or can this be done with a do loop? Please any help will be appreciated! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎06-17-2023 02:15 PM
Likes given to
Likes from
View All
Quick links