About sasban

sasban · ‎02-26-2018

@Reeza- Thank you! I'll try.

sasban · ‎02-26-2018

I'm trying to make a project which can run for data of different time periods- say 1. 12/01/2015 to 11/30/2016, 2. 06/01/2016 to 05/31/2017, 3. 12/01/2016 to 11/30/2017, 4. 06/01/2017 to 05/31/2018 and record final output of each time period. Any suggestions from the community would be of great help.

sasban · ‎02-06-2018

Thank you! Solved!!

sasban · ‎02-06-2018

Thank you for your suggestions. Just doing first left join also have same problem. I tried with the code you provided, again same result.

sasban · ‎02-06-2018

While joining table (soapnotes) to variables from database, I'm getting multiple rows (observation) blank. Any suggestions, please? proc sql; create table q.get_mem_no0 as select a.*,b.document as doc_wh , b.lob, b.member , b.first_dos, c.recip_no as recipno from q.soapnotes a left join am.MASTER_CLAIM b on a.document = b.document left join am.MEMBERS c on b.member = c.mem_no ; quit;

sasban · ‎10-25-2017

@mkeintz, I did following and did proc report with other variables. But could not calculate total. Proc import datafile="/folders/myshortcuts/Myfolders/SAS Exercise/DM_Exercise1.xls" Out=Q1 Dbms=XLS replace; run; proc sort data=Q1 nodupkey; by usubjid; run; data Q1a; set Q1 (keep=agegr1 sex age race ethnic trt01pn pltcnt); run; proc freq data=Q1a noprint; tables trt01pn*agegr1/missing outpct out=Q1afreq_agegr1; run; data Q1afreqper_agegr1; set Q1afreq_agegr1; length value $25; value=put(count, 4.)!!' ('!!put(pct_row,4.1)!!'%)'; run; proc sort data=Q1afreqper_agegr1; by agegr1; run; proc transpose data=Q1afreqper_agegr1 out=Q1atrans_agegr1; by agegr1; var value; ID trt01pn; run; data labelagegr1; label="Age Categorization (%)"; run; data agegr1label; length label $25; set labelagegr1 Q1atrans_agegr1; keep label _0 _1 _2; if _n_>1 then select; when (agegr1='<65') label="<65"; when (agegr1='>=65') label=">=65"; otherwise; end; run;

sasban · ‎10-25-2017

@error_prone, I'm looking for output like in proc report (below), Can I get that output through proc means (below)? Proc import datafile="/folders/myshortcuts/Myfolders/SAS Exercise/EFF_Exercise.xls" Out=AE Dbms=XLS replace; run; data AEsmall; set AE (keep=avisitn avisitn_1 trt01p aval); run; Proc sort data=AEsmall out=AEready; by avisitn; run; Proc means data=AEready N mean stderr maxdec=3; var aval; class avisitn avisitn_1 trt01p; ods output summary=AE1; run; data viral_load; set AE1; format aval_mean_se $50.; drop NObs aval_mean aval_stderr; aval_mean_se=put(aval_mean, 5.3)!!' ('!!put(aval_stderr, 5.3)!!')'; run; Proc report data=viral_load out=TableQ7; title1 'Table 1:'; title2 'Summary of Viral Load Over Time'; title3 'ITT Population'; column avisitn trt01p aval_N aval_mean_se; define avisitn/group 'Test day (Week)'; define trt01p/group 'Treatment'; define aval_N/group 'N'; define aval_mean_se/display 'Unadjusted Mean (SE)'; run;

sasban · ‎10-25-2017

@mkeintz, Yes, It is like this: Treatment A Treatment B Total Sex M 50 (10%) 100 (20%) 500 (100%) F Race White Asian . .

sasban · ‎10-23-2017

@ballardw- My data is clean already. My problem here is the proper use of proc freq, proc transpose... things are required in proper order.

sasban · ‎10-23-2017

I need to create a demographic summary table. Since I'm doing this for the first time, I'm looking for the reference that describes creating table with continuous and categorical variables explicitly (possibly with step by step coding). Any suggestions please?

sasban · ‎10-23-2017

Acct_ID Name Birthday Sex State Cust_Type Product Balance Last_Tran_Date 1001 John 1/1/1962 M CA Gold Checking 1000 9/1/2015 1002 Mary 1-Feb F CA Silver Saving 2000 10/1/2015 1003 Peter 3/1/1982 M NY Gold Loan 3000 10/3/2016 1004 Mary 4/1/1992 F NY Silver Checking 4000 9/17/2016 1005 Linda 5/1/1994 F WA Gold Saving 5000 1006 Susan 6/1/1997 F WA Gold Loan 1000 9/15/2016 1007 Sam 7/1/1999 M CA Gold Checking 2000 2/1/2016 1008 Thomas 8/1/1962 M CA Silver Checking 3000 7/1/2016 1009 Linda 9/1/1982 F NY Silver Saving 4000 From the data above, I need to create a table as attached using macros. I'm learning an efficient use of macro. Any suggestion would be a great help.

sasban · ‎10-23-2017

Thank you Reeza!

sasban · ‎10-23-2017

Could you please change my username to sasban. Please let me know if it is not available.

sasban · ‎10-23-2017

I need to get an output as attached from a data set. I tried using Proc means and Proc report, but didn't help. Any suggestions please?

sasban · ‎10-19-2017

I'm trying trying to sort: Week 2, Week 12, Week 16, Week 8, Week 4 in ascending order of week number, but could not get the order. Any suggestions please?

Online Status	Offline
Date Last Visited	‎03-29-2018 11:22 AM

Re: Automation-SAS Enterprise Guide

Automation-SAS Enterprise Guide

Re: Left join- missing rows from left table

Re: Left join- missing rows from left table

Left join- missing rows from left table

Re: Demographic table creation

Re: Can we open proc means output in proc report?

Re: Demographic table creation

Re: Demographic table creation

Demographic table creation

Re: Can we open proc means output in proc report?

Re: Can we open proc means output in proc report?

Re: Can we open proc means output in proc report?

Re: Can we open proc means output in proc report?

Re: Macro question

Re: Automation-SAS Enterprise Guide

Automation-SAS Enterprise Guide

Re: Left join- missing rows from left table

Re: Left join- missing rows from left table

Left join- missing rows from left table

Re: Demographic table creation

Re: Can we open proc means output in proc report?

Re: Demographic table creation

Re: Demographic table creation

Demographic table creation

Macro question

Re: Can we open proc means output in proc report?

Re: How do you change your community UserName

Re: Can we open proc means output in proc report?

Sort a variable with two works