SAS Support Communities

asuman · ‎09-26-2021

Thanks Paige and Shmuel.

asuman · ‎09-25-2021

Hi Kurt, My question is that if in table t1 we have 20 more columns then in table t2 we have to define match rate for those 20 columns also.And if we use different tables, then every time we have to make changes in match rate formula as per new columns. so i am asking is there any way we can automate such a way like match rate will be calculated based on the columns in table t1.

asuman · ‎09-25-2021

data t1; input year volume diff_pr prob forb; cards; 2018 204010 2380 4898 5740 2019 208765 4678 7659 9862 2020 279868 7654 8762 8257 2021 215678 8721 9821 7627 ; run; data t2; set t1; match_rate_1 = (volume-diff_pr)/volume; match_rate_2 = (volume-prob)/volume; match_rate_3 = (volume-forb)/volume; run; How can we automate the way match_rate is calculated.

asuman · ‎09-16-2021

When we use proc compare ,then we get a report in results tab,so under variables with unequal values we have a summary of variables(I have also highlighted in bold).From that highlighted summary i want to create a data set which with variable and ndif column only. Thanks you.

asuman · ‎09-16-2021

Values Comparison Summary Number of Variables Compared with All Observations Equal: 0. Number of Variables Compared with Some Observations Unequal: 1. Total Number of Values which Compare Unequal: 389124. All Variables Compared have Unequal Values Variable Type Len Label Ndif MaxDif Receipt CHAR 13 Recipt Number389124 When we use proc compare ,then we get a report in results tab,so under variables with unequal values we have a summary of variables(I have also highlighted in bold). From that highlighted summary i want to create a data set which with variable and ndif column only. Thanks you.

asuman · ‎06-05-2021

SAS (Statistical Analysis System) is widely utilized in clinical trial data analysis in pharmaceutical, Bio-Technology, and clinical research organizations. The utilization of SAS in clinical researches has given unbelievable results in past years. SAS can help healthcare professionals to meet their business goals, generate great revenue, enhance strategic performance management, and most importantly control costs. Role of SAS in Pharma Industry The major role of SAS in Pharma Analytics mainly focusses on generating the TLF’s or TLG’s. The CDISC standards like SDTM and ADAM which are used to standardize and to analyze the clinical trial data and the generation of reports can be only done by using Clinical SAS since the FDA accepts only SAS reports. The department of BIO- Statistics is using clinical SAS for writing the SDTM and ADAM specifications and in the creation of SAP (Statistical Analysis Plan). CDM team is using SAS to perform data analysis before loading the data into certain databases. Analysis with clean data and validating the clinical trial data will reduce the pain on the FDA to have a good overview of the clinical reports. Hence most CRO’s are preferring clinical SAS as the best tool to use for its safety and efficiency when compared with other software tools. SAS is leader in Pharma industries.

asuman · ‎05-19-2021

For better understanding ,kindly provide the desired o/p also.But this might help you. data test; input customer & $200.; cards; Cho0012 (Industrial filling station T/A Caltex mogoboshane) cho0013 (Choppies complex supermarket) SPA0107 (K.A.W ENTERPRISES (PTY) LTD T/A SPAR MOGODITSHANE) ; run; data test1(drop=a b); length a $200. c $200.; set test; a=compress(scan(customer,2, '('),')'); b=compress(scan(customer,3,'('),')'); c=catx('',a,b); run;

asuman · ‎05-14-2021

I did not get your question clearly but this might help you: %let x=temp; %let n=3; %let x3=result; %let temp3 = result2; %put &x&n; %put &&x&n; %put &&&x&n; The scanner reads from left to right. &x&n : Macro variable X resolves first to temp and then N resolves to 3. Output : temp3 &&x&n : Two ampersands (&&) resolves to one ampersand (&) and scanner continues and then N resolves to 3 and then &x3 resolves to result. Output : result &&&x&n : First two ampersands (&&) resolves to & and then X resolves to temp and then N resolves to 3. In last, &temp3 resolves to result2. Output : result2

asuman · ‎05-11-2021

data test; input id trans_date; informat trans_date ddmmyy10.; format trans_date ddmmyy10.; cards; 1 23-11-2021 2 20-10-2021 3 15-08-2021 4 29-04-2021 8 10-03-2021 9 15-05-2021 10 12-03-2021 11 03-06-2021 2 15-08-2021 3 15-08-2021 4 16-01-2021 ; run; data test; set test; quater=qtr(trans_date); run;

asuman · ‎05-11-2021

data test; input date; cards; 11052021 ; run; data test1; set test; format newdate date10.; newdate = input(put(date,8.),ddmmyy8.); run;

asuman · ‎12-03-2019

Thanks Tom,This is what i was looking for.

asuman · ‎12-03-2019

Suppose there is a table and in table ,a column named state has 28 different values.I want to call 5 states names, for this i want to write a single macro which will call those 5 states. Kindly help.

asuman · ‎07-24-2019

Thank you for making subject line more effective,i will take care this in future.

asuman · ‎07-24-2019

Thanks TOM.It's Working

asuman · ‎07-24-2019

data b; y=datetime(); format y datetime21.; want=intnx('dtmonth',y,2)+'02:10:06't; format want datetime21.; run; results: y=24JUL2019:21:42:04 want=01SEP2019:02:10:06 it's not the correct answer.Need assistance

Online Status	Offline
Date Last Visited	‎01-03-2024 08:11 AM

SAS Support Communities

Re: Macros

Re: Macros

Macros

Re: proc compare

proc compare

Re: SAS Clinical Trials and Pharmaceuticals

Re: Scanning words with different length

Re: what does && means in a macro in SAS?

Re: transaction by quater

Re: date format

Re: Macros

Re: SAS Clinical Trials and Pharmaceuticals

Re: what does && means in a macro in SAS?

Re: Macros

Re: Macros

Macros

Re: proc compare

proc compare

Re: SAS Clinical Trials and Pharmaceuticals

Re: Scanning words with different length

Re: what does && means in a macro in SAS?

Re: transaction by quater

Re: date format

Re: sas macros

sas macros

Re: How to increment datetime variables

Re: date

Re: date

Follow Us

What is...