About ranikeka

ranikeka · ‎11-04-2021

Thank you, yes but it’s takes lot of time to program everything and proc compare. So I am looking for much faster way I can sum it my work.

ranikeka · ‎11-04-2021

Thank you for reply This is internal QC to use codes and cross check data.

ranikeka · ‎11-03-2021

Hi I am doing QC on clinical sas ADAM datasets like ADSL ADAE Etc ..for which I need a help. Infact I am using Proc freq and basic Sql statements to cross check data to find errors. I am not able to find all of the critical errors which is a big problem. Does anybody provide some programs to cross check data perfectly ? I am really in need of help and I would be very grateful if you could help me out. Thanks a lot.

ranikeka · ‎03-30-2021

Thank you so much 😊 there’s a lot of information.

ranikeka · ‎03-29-2021

Hi I started working on qc of tables and graphs. I know proc freq will give the numbers and frequency. But how to bring the table output as per the mock shell. Can you please give me some papers or codes that could help and understand the process. Thanks

ranikeka · ‎03-24-2021

Thank you 🙏

ranikeka · ‎03-24-2021

Thanks 🙏

ranikeka · ‎03-16-2021

Hi I am using proc sql method for percentage calculation to generate table. First column group A and second column with group B and third column with total of A and B. The following error comes up could you please help how to solve this issue. Proc sql; Create table bytra as select 100*round(pt1/ys,0.01) as bytrapct, 100*round(pt2/ys,0.01) as bytrapct, 100*round(pt1/123, 0.01) as bytrapct, From file1; Quit; Invalid or missing arguments to the round function have caused the function to return a missing value. Many thanks for all the help.

ranikeka · ‎12-15-2020

Many Thanks can i use same code for below one as well sheet1 abc def ghi 1 a a1 2 b a2 3 c a3 4 d a4 sheet 2 jkl mno pqr xxxx rrrr tttt vvvvv hhhh tttt nnnnn ggg gg sssss bbb jj eeeee ccc kk tttt hhhh nnn tttt hhhh nnn tttt hhhh nnn fffff tttt uuuu pppp qqqq eeee tttt ggg tttt lll ppp iii I want to combine two above sheets like following abc def ghi jkl mno pqr 1 a a1 xxxx rrrr tttt 1 a a1 vvvvv hhhh tttt 1 a a1 nnnnn ggg gg 1 a a1 sssss bbb jj 1 a a1 eeeee ccc kk 2 b a2 tttt hhhh nnn 2 b a2 tttt hhhh nnn 2 b a2 tttt hhhh nnn 3 c a3 fffff tttt uuuu 3 c a3 pppp qqqq eeee 3 c a3 tttt ggg tttt 3 c a3 lll ppp iii

ranikeka · ‎12-15-2020

HI Thanks for the suggestion. I dont have same variable names thats the problem. Here is my sample file to understand better. Any help appreciated. sheet 1 abc def ghi 1 a a1 2 b a2 3 c a3 4 d a4 sheet 2 abc def ghi jkl mno pqr 1 a a1 xxxx rrrr tttt 1 a a1 vvvvv hhhh tttt 1 a a1 nnnnn ggg gg 1 a a1 sssss bbb jj 1 a a1 eeeee ccc kk 2 b a2 tttt hhhh nnn 2 b a2 tttt hhhh nnn 2 b a2 tttt hhhh nnn 3 c a3 fffff tttt uuuu 3 c a3 pppp qqqq eeee 3 c a3 tttt ggg tttt 3 c a3 lll ppp iii

ranikeka · ‎12-07-2020

Hi I have sheet 1 and sheet 2 in excel file. I want sheet 1 main info to corresponding observations in sheet 2. I have created datasets in sas and need to combine. So I have used merge but the main info isn’t have corresponding values in sheet2? For example: Sheet 1 - one observation corresponds to 40 etc.. observations in sheet 2. And so on Like this I have numerous excel files which I combined into single dataset. Could you please help with me this. Thanks

ranikeka · ‎11-30-2020

I have imported more than 100 excelfiles to sas using macro. While appending, gives warning: Variables has different lengths on base and data files. More in data. How would I do correct this as my data is truncating. Please help me out Thanks

ranikeka · ‎11-27-2020

Hi My data truncated while appending multiple data sets and also changing data structure Could you please help me out how to retrieve complete data in variables. Thanks Happy thanksgiving day

ranikeka · ‎11-26-2020

Thanks a lot.

ranikeka · ‎11-26-2020

Great and many thanks 🙏

Online Status	Offline
Date Last Visited	‎11-10-2021 11:31 AM

Re: QC clinical ADAM datasets

Re: QC clinical ADAM datasets

QC clinical ADAM datasets

Re: QC tables and graphs

QC tables and graphs

Re: Proc sql error

Re: Proc sql error

Proc sql error

Re: Combining

Re: Combining

Re: QC clinical ADAM datasets

Re: QC clinical ADAM datasets

QC clinical ADAM datasets

Re: QC tables and graphs

QC tables and graphs

Re: Proc sql error

Re: Proc sql error

Proc sql error

Re: Combining

Re: Combining

Combining

Re: Data truncated while appending multiple data sets ?

Data truncated while appending multiple data sets ?

Re: Export multiple SAS datasets to one excel file in multiple sheets.

Re: Export multiple SAS datasets to one excel file in multiple sheets.