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: 
robertrao
‎09-17-2019
  • 1,046 Posts
  • 82 Likes Given
  • 0 Solutions
  • 5 Likes Received

Date logic

by Quartz | Level 8 in SAS Programming
‎09-17-2019 09:06 AM
‎09-17-2019 09:06 AM
Hello,   I have 2 tables as shown. Table 2 has duplicates. While joining the tables using left join, we want to pull from table 2 any dates >= the date for the ID from table T1 as well as dates within 7 days prior. Can someone help with the logic?   TABLE T1 ID   dischargeDT 101  08/01/2019   TABLE T2 ID    DATE 101  06/16/2019 101  07/25/2019 101  08/01/2019 101  09/05/2019   RESULT   ID   discharged      DATE 101  08/01/2019   07/25/2019 ---7 days prior to 08/01/2019 101  08/01/2019   08/01/2019 --on the same day as 08/01/2019 101  08/01/2019   09/05/2019--anything after 08/01/2019   Thanks       ... View more

Re: if then else

by Quartz | Level 8 in SAS Programming
‎01-24-2019 11:47 AM
‎01-24-2019 11:47 AM
Thanks Reeza,   It finally worked. I had some RUN statements in between the statements and forgot to remove them !!!! This statement worked!!!   IF (PalS_N/19 > .50) THEN PalS = SUM(PAL1,PAL2,PAL3,PAL4, B1, PAL5, C2, O2, PAL6, PAL7, Br7, PAL8, PAL9,PAL10, Sp21, PAL12, L1, PAL13, PAL14)*19/(PalS_N); ELSE PalS =SUM(PAL1,PAL2,PAL3,PAL4, B1, PAL5, C2, O2, PAL6, PAL7, Br7, PAL8, PAL9,PAL10, Sp21, PAL12, L1, PAL13, PAL14);   ... View more

Re: if then else

by Quartz | Level 8 in SAS Programming
‎01-24-2019 11:29 AM
‎01-24-2019 11:29 AM
Thanks Reeza for the reply.   If it equals 0.5 then it is to be included in the less than or equal to category (PalS_N/19 <= .50).   The following is the error   ERROR 180-322: Statement is not valid or it is used out of proper order. ... View more

if then else

by Quartz | Level 8 in SAS Programming
‎01-24-2019 11:14 AM
‎01-24-2019 11:14 AM
Hello,   I am trying to write a logic and have been getting an error. "statement is not valid or it is used out of proper order" Could you help me figure out the mistake in these statements   data want; set have; IF (PalS_N/19 > .50) THEN PalS = SUM(PAL1,PAL2,PAL3,PAL4, B1, PAL5, C2, O2, PAL6, PAL7, Br7, PAL8, PAL9,PAL10, Sp21, PAL12, L1, PAL13, PAL14)*19/(PalS_N); ELSE IF (PalS_N/19 < .50) THEN PalS =SUM(PAL1,PAL2,PAL3,PAL4, B1, PAL5, C2, O2, PAL6, PAL7, Br7, PAL8, PAL9,PAL10, Sp21, PAL12, L1, PAL13, PAL14); run; run; ... View more

SAS subtraction

by Quartz | Level 8 in SAS Programming
‎01-24-2019 03:32 AM
‎01-24-2019 03:32 AM
  Hello,    I have columns in Excel which have blank values. After importing to SAS they all now have a dot as shown below in the "have "dataset. Now the requirement is to subtract all these variables from 4 as shown. After performing the calculation to my surprise i still have missing values instead of 4. Did i miss anything?     data have PAL1 PAL2 PAL3 PAL4   .           .     .         . run;     data Want; set have; paL1_=4-pal1; pal2_=4-pal2; pal3_=4-Pal3; pal4_=4-pal4;   run;   Thank you   ... View more

PROC LOGISTIC

by Quartz | Level 8 in Statistical Procedures
‎11-08-2017 07:45 AM
‎11-08-2017 07:45 AM
Hello,   I have values like shown below and each row corresponds to the values of a single hospital. and I am trying to make a ROC chart using Proc Logistic. Unfortunately I get the statistics table but not the ROC curve Please help me to figure where the mistake was made. Thank you     HAVE   expectdMortality   CASE-MIX-INDEX    Hospital 2.91                              2.04                           1 2.57                               2.03                          2 1.60                              1.46                           3       ods graphics on; proc logistic data=HAVE plots=roc; model expectdMortality = CASE-MIX-INDEX; run; ods graphics off; ... View more

DATE IN sql

by Quartz | Level 8 in SAS Procedures
‎06-13-2017 05:10 AM
‎06-13-2017 05:10 AM
Hello,   I have a SQL date '2016-01-31'. How can i extract month and year together in TSQL,   Example: i WANT LIKE BELOW   01-2016     THANKS ... View more

Re: format

by Quartz | Level 8 in SAS Programming
‎05-23-2017 04:40 AM
‎05-23-2017 04:40 AM
Thanks again. Actually I need to do more than that. I had the same thing posted a few days ago and i got good response/help. i am doing the :   count of missing/Total records*100 ... View more

Re: format

by Quartz | Level 8 in SAS Programming
‎05-23-2017 04:17 AM
‎05-23-2017 04:17 AM
Thanks Kurt. I think we need to use the following:Is that true when i want to get the total number of records later?   data want; set have; if daystoadmit = . then daystoadmit = 1; else daystoadmit =0; run; ... View more

format

by Quartz | Level 8 in SAS Programming
‎05-23-2017 03:58 AM
‎05-23-2017 03:58 AM
hello,   I have a numeric field called DAYSTOADMIT(contains values like 0, 1 ,33, 24 etc etc) I am trying to apply formats to assign 1 to those that have a missing value by assigning them a value of 1 so i can summarize later using tabulate. . I used the following format and from the resultant dataset when i say "where DAYSTOADMIT ne 0" I AM GETTING 0 pulled up . It is surprising to me.. can someone explain why this is happening???     Proc format library=work; invalue ADMIT . = 1 other=0 ; run;   data want; set have; informat DAYSTOADMIT Admit.; run; ... View more

Re: PROC TABULATE

by Quartz | Level 8 in ODS and Base Reporting
‎05-19-2017 05:52 PM
‎05-19-2017 05:52 PM
I see. How about using Proc Report instead of tabulate. Can be acheived?   Thanks ... View more

Re: PROC TABULATE

by Quartz | Level 8 in ODS and Base Reporting
‎05-19-2017 05:09 PM
‎05-19-2017 05:09 PM
Thanks Ballard...   I need it for multiple variables... That example dataset i provided was a mistake. Can your code be expanded to accomodate for multiple variable ?   Thanks ... View more

Re: PROC TABULATE

by Quartz | Level 8 in ODS and Base Reporting
‎05-19-2017 04:51 PM
‎05-19-2017 04:51 PM
Hello,   I am sorry for the confusion. A and B should have been MEAS A and MEAS B respectively.(forgot to change the old code which was suggested by Ballard and Art yesterday). Shortly after I posted the question I figured out from the article that all the stats have to be in braces to split the results for each of the values under class variable. http://support.sas.com/resources/papers/proceedings11/173-2011.pdf   Lastly, i could not start with this yesterday since I was asked to split the report after I started working on it..   Hope you will understand..Also I am working on other tools these days so lost the little knowledge I learnt   Thanks     ... View more

Re: PROC TABULATE

by Quartz | Level 8 in ODS and Base Reporting
‎05-19-2017 04:36 PM
‎05-19-2017 04:36 PM
data temp; input meas$ source$ surgery; datalines; MEAS_A hosp1 1 MEAS_A hosp1 1 MEAS_A hosp1 1 MEAS_A hosp1 1 MEAS_A hosp1 1 MEAS_A hosp1 1 MEAS_A hosp1 1 MEAS_A hosp1 1 MEAS_A hosp2 0 MEAS_A hosp2 1 MEAS_A hosp2 1 MEAS_A hosp2 1 MEAS_A hosp2 1 MEAS_A hosp2 1 MEAS_A hosp2 1 MEAS_A hosp2 1 MEAS_A hosp2 1 MEAS_A hosp2 1 MEAS_A hosp2 1 MEAS_A hosp2 1 MEAS_A hosp2 1 MEAS_A hosp2 1 MEAS_A hosp2 1 MEAS_A hosp2 1 MEAS_A hosp2 1 MEAS_A hosp2 1 MEAS_A hosp2 1 MEAS_B hosp1 1 MEAS_B hosp1 0 MEAS_B hosp1 0 　 　 MEAS_B hosp2 1 MEAS_B hosp2 1 MEAS_B hosp2 0 MEAS_B hosp2 0 MEAS_B hosp2 0 MEAS_B hosp2 0 MEAS_B hosp2 0 MEAS_B hosp2 0 MEAS_B hosp2 0 MEAS_B hosp2 0 MEAS_B hosp2 0 MEAS_B hosp2 0 MEAS_B hosp2 0 MEAS_B hosp2 0 MEAS_B hosp2 0 MEAS_B hosp2 0 MEAS_B hosp2 0 MEAS_B hosp2 0 MEAS_B hosp2 0 MEAS_B hosp2 0 MEAS_B hosp2 0 MEAS_B hosp2 0 MEAS_B hosp2 0 MEAS_B hosp2 0 MEAS_B hosp2 0 MEAS_B hosp2 0 MEAS_B hosp2 0 MEAS_B hosp2 0 ; run;           I want the output like shown below:What changes do i need to make to the PROC TABULATE code:   Proc tabulate data=have; class source; var A B ; table (A B ) *source, sum= n= mean= ; run;     OUTPUT:                            hosp1                                                  hosp2                      sum N   mean(%)                           Sum N      Mean(%) MEAS A        8    8     8/8*100=100%                 18   19      18/19*100=94.74% MEASB         1     3    1/3*100=33.3%                2     28      2/28*100=7.14%      Overall          9     11   9/11*100= 81.81%        20   47    20/47*100=42.55%   ... View more

PROC TABULATE

by Quartz | Level 8 in ODS and Base Reporting
‎05-19-2017 03:01 PM
‎05-19-2017 03:01 PM
    I want the output like shown below:What changes do i need to make to the PROC TABULATE code:   Proc tabulate data=have; class source; var A B C D E; table (A B C D E ) *source, sum= n= mean= ; run;     OUTPUT:                            Source1                   Source2                  sum N mean              Sum N Mean A B C D E Overall --- --- -----                    ---    ---    -----       ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-17-2019 02:41 PM
Likes given to
View All
Likes from
Quick links