About Sathish_jammy

Sathish_jammy · ‎07-16-2018

Hi community, I'm looking a decimal value for the month column. For Year value i got the exact one. I have a trouble with the dd_m (month) column. While using INTCK func i got a month value but without a decimal. Please suggest me to solve it. data eee; input dateonset mmddyy10.; cards; 02/19/2004 01/20/2003 05/10/2003 05/21/2003 12/24/2002 05/20/2003 ; data dur1; set eee; tday = today(); dur_d = tday - dateonset; dd_m = intck('month',dateonset,tday); /**dd_m = dur_d / 12;****(Wrong value)***/ dd_y = dur_d / 365.25; format dd_y 4.1 dd_m 4.1 tday dateonset mmddyy10.; run; proc print; run;

Sathish_jammy · ‎07-13-2018

Thank u so much! @Kurt_Bremser @Shmuel

Sathish_jammy · ‎07-13-2018

If i use 'kd' in compress then it delete '.' punctuation in (1.5, 2.5, 1.0) so the value should like (15 , 25, 10) I need value in decimal as same as in my dataset.

Sathish_jammy · ‎07-13-2018

data have; input abc $; cards; 1.0 MG 0.25# *1 2.5 UG run; data want; set have; a1 = compress(abc,'#*','s','a'); run; I need only the numeric value. while using the compress func an ERROR occurred: The COMPRESS function call has too many arguments. Please suggest me any methods to solve.

Sathish_jammy · ‎07-04-2018

/*in the list of Cards - first one is exact word, followup are have typo err.*/ data CATEGORY; input MODE :$20; cards; A.VELOCITY A.VALOSITY A.VELOCIY B.HYDROCHLORIC B.HYDRRACLORIK B.HYDROCLOKIK C.GEOMETRY C.GEMENTRY run; /* the above dataset is just for an example */ /* I have a table in SQL with same kind of problem, As now just keep on eye with cards */ proc sql; update CATEGORY set Column2 = 'physics' where MODE =* 'A.VELOCITY'; run; proc sql; update CATEGORY set Column2 = 'chemistry' where MODE =* 'B.HYDROCLORIC'; run; proc sql; update CATEGORY set Column2 = 'maths' where MODE =* 'C.GEOMENTRY'; run; /*Is there any effective way to resolve this than some other methods in SAS */ /*I don't care about the initial (A. B. C.) but i need to focus on methods(velocity geometry hydrochloric) MY MAJOR CONCERN ON CATEGORIZING "TYPO ERR"

Sathish_jammy · ‎07-02-2018

data aaa; input a b c d e; cards; ca gv ca rr ds ds ss ds ca ca ds gv ca rr ca gv ca ds rr ds run; Output Should be like a b c d e ca 1 1 2 1 2 gv 1 2 0 0 0 rr 0 0 0 3 0 ds 2 0 2 0 2 ss 0 1 0 0 0 Please share the code to resolve this kind of stuff.

Sathish_jammy · ‎07-02-2018

Hi, I'm a basic learner in sas, col1 col2 col3 ACE inhibitors 33 7 1 angiotensin receptor blockers 1 0 0 Diuretic 1 5 1 aldosterone antagonists/Diuretic 1 0 0 alpha blockers 2 0 0 angiotensin receptor blockers 49 23 11 angiotensin receptor blockers/ACE inhibitors 1 0 0 angiotensin receptor blockers/Diuretic 9 16 1 antacids 1 0 0 anthelmintic drug 2 1 0 Antibiotics 6 18 3 anticonvulsant 2 0 0 I'm looking for the count of all generic name in each column. how do i get this. Please help me to solve.

Sathish_jammy · ‎06-29-2018

i tried up whith this condition. But the 89 series are come up as null ... Why? data cre_epi; set creatin7; if epi_1 ge 90 then epi_1_stage =1; if epi_1 ge 60 and epi_1 le 89 then epi_1_stage =2; if epi_1 ge 30 and epi_1 le 59 then epi_1_stage =3; if epi_1 ge 15 and epi_1 le 29 then epi_1_stage =4; if epi_1 lt 15 then epi_1_stage =5; if epi_1 =. then epi_1_stage =.; if epi_5 ge 90 then epi_5_stage =1; if epi_5 ge 60 and epi_5 le 89 then epi_5_stage =2; if epi_5 ge 30 and epi_5 le 59 then epi_5_stage =3; if epi_5 ge 15 and epi_5 le 29 then epi_5_stage =4; if epi_5 lt 15 then epi_5_stage =5; if epi_5 =. then epi_5_stage =.; run; mno epi_1 epi_5 epi_1_stage epi_5_stage 124438 75.387 89.875 2 . 124412 82.071 82.071 2 2 112956 89.944 . . .

Sathish_jammy · ‎06-28-2018

Hi Friends, I want to calculate the EPI value in my table (EPI_Creatinine) by using the formula of CKD-EPI Creatinine = A × (Scr/B)C × 0.993age (C and age - PowerOf ^) Note : Scr = creatinie column. For example : (Female who Scr <=0.7) 144 * (Cre/0.7)^-0.329 * 0.993^age(column) Like wise it differ from each category. Hope you guys understand. I want to categorize it by Gender with the specified value. You want me to be more honest, I have no idea about it how to calulate in SAS. Please help me to solve(code) any one of the category.

Sathish_jammy · ‎06-28-2018

Thanks for your guidance. Your code works well. ( RENAMED - LIBNAME proj_s as Projs ) This is the code i used to connect with database. libname projs odbc noprompt= "Driver=SQL Server;Server=192.168.1.3;Database=Project;UID=IT;PWD=***;"; As you said data source doesn't support the ALTER STATEMENT means, In further i need new columns in this table. Then how do i proceed with alter statement.

Sathish_jammy · ‎06-28-2018

Hi, Can any one please assist me to solve the given code. proc sql; create table proj_s.ddrug_samp as select mno,ddrug11,ddrug12,ddrug13 from proj_s.durat1yr_fbs_yr; quit; OUTPUT : Done proc sql; alter table proj_s.ddrug_samp add ddrugx char(10); quit; ERROR: 35 proc sql; 36 alter table proj_s.ddrug_samp add ddrugx char(10); ERROR: The HEADER/VARIABLE UPDATE function is not supported by the ODBC engine. ERROR: View PROJ_S.ddrug_samp cannot be altered. NOTE: The SAS System stopped processing this step because of errors.

Sathish_jammy · ‎06-23-2018

You are really awesome!... @FreelanceReinh Thank you so much...

Sathish_jammy · ‎06-23-2018

Thank u so much! it works well... But how do i get the mean difference & STD difference ,as well p-value for each 3 tertiles. Could u please help me again.

Sathish_jammy · ‎06-22-2018

Hi, I have values (1 to 300) in a column i want to find the mean and std of 33.33rd percentile for that values. How do i solve that. please help me!...

Sathish_jammy · ‎06-22-2018

My table consist of patient informations such as their test results, measurements etc... from that I just want to calculate the tertile mean and std for the given columns in the table like Hope u understand now.... Weight follw1_weight 94.75 95.1 77.1 76.1 127 126.7 69.7 69.6 81.4 82.3 92.8 91 84.1 82.8 84.9 83 85.6 82.5 101.2 98.9 72.25 70.8 79.5 80.5 77 75.3 101.8 96.5 84 81.6 89.7 86 115.7 115.7 102.3 97.4 82.4 75.9 87.9 80.9 59.7 55 71.05 71.4 95.7 96 78.2 79.6 79.5 76.1 71.5 70.8 102 101.6 80 76.5 88.9 88.7 78.2 74.75 89.2 90 78.9 78.9 86.1 84.1 76.4 75 88.3 86 82.15 81.3 93.8 92.05 79.2 79.2 66 64.8 95.2 95.4 82.7 81.2 87.5 80.7 106.4 105.3 85.7 85.6 84.1 84.4 114.4 113.4 66.2 66.2 99.9 94.7 68.3 68 75.5 71.65 87 86.9 75.2 68.7 89.3 86.2 88 85.8 81.5 79.9 72.05 72.2 105.4 102.9 68.3 68.7 82.9 86.4 96.3 93.2 83.2 81.9 79.9 89.8 88.7 89.3 97.4 91.6 89.8 88 85 85.8 84.1 78.1 90 88.5 92.1 93.65 119.2 115.2 111.8 96 98.5 102.1 83.4 86.1 92.7 93.3 103.2 105.9 76.3 76.8 104.2 102.1 97.7 94.05 78.6 76.1 108 100.9 62.55 60.85 94 94 99.2 96.8 93.2 92.3 76.65 74.85 82.6 81.7 91.4 88.3 80.9 76.35 99.9 102 114 114.8 104.8 102.9 105.9 101.4 107.3 103.8 63.1 62.8 72.7 69 58.5 57.2 88.7 85.5 86.55 89.2 84.4 81 122.7 120.4 95.35 88.1 91.2 87.5 100 92.5 86.9 57.8 88 84.1 99.2 92.75 73.2 73.75 74.7 73.2 80.3 80.55 73.8 72.5 70.2 69.8 72.7 71.7 83.6 81.1 83.3 82 95.6 93.3 91.1 93 67.3 64.6 117.3 116.5 59.5 58 94.65 89.8 75 74.8 91.65 88.2 102.4 101.2 89.1 84.5 97.9 93.95 110.6 110.6 65.15 64.75 83.85 81.05 88.5 86.3 100.8 98 78.2 71.9 89.85 92.2 91.1 86.2 84.2 78.5 91.1 90.3 76.7 75.3 78.2 75.9 67.55 68 81.1 82.7 72.7 70.2 76.45 74 89.8 85.7 69.2 66.8 76.6 75.4 87.9 86.6 72.55 70.4 86.8 85.6 97 94.1 77.3 76.7 82.4 83.7 79.55 79.25 89.6 90 103.2 95.6 72.1 66.7 89.5 90.6 83.4 83.06 115.9 114.6 123.2 122.1 81.6 80.2 84.9 87.6 87.95 88.75 95.5 95.6 93.6 90.4 84.3 82.35 73.5 70.9 111.3 109 116.5 112.2 75.3 69.9 72.8 71.05 82.6 80.5 69.65 66.5 95.4 95.2 77.15 75.75 75.8 73.45 84.1 82.1 94 89.6 89.7 89.5 86.2 85 93.2 89.5 86.7 86.2 100.5 96.7 89.5 87.8 70.7 64.95

Online Status	Offline
Date Last Visited	‎07-17-2024 12:27 PM

Re: Converting the CTE recursive query to SAS logic

Converting the CTE recursive query to SAS logic

Re: Generate an automatic email after the sql query condition

Generate an automatic email after the sql query condition

Migrate SAS codes to BQ

Values shrink while import the csv file

How to calculate with n of the dataset

Concat the data in single cell

Re: Extract the values from the text for calculation

Extract the values from the text for calculation

Re: Generate an automatic email after the sql query condition

Re: Generate an automatic email after the sql query condition

Re: Generate an automatic email after the sql query condition

Re: Migrate SAS codes to BQ

Re: Values shrink while import the csv file

How do I get the Odds ratio in Fisher Exact Test

Re: remove all special characters

Re: Questions about base certification

Re: Merging row text by ID

Re: Count the number of times a ky appeared individually

Month value with decial -Date function

Re: Compress func has too many arguments

Re: Compress func has too many arguments

Compress func has too many arguments

How to categorize the typo err value apart from WHERE clause

Re: Proc Freq

Proc Freq

If condition error

CKD-EPI Creatinine in sas

Re: Altering column in PROC SQL

Altering column in PROC SQL

Re: Percentile using mean

Re: Percentile using mean

Percentile using mean

Re: Tertile in SAS mean