About manya92

manya92 · ‎07-05-2018

in this code :- what is INTO:npatients trimmed nobs trimmed for ? i dont know what trimmed means in this case %macro patient_obs() ; %global nobs npatients ; proc sql noprint; select count(enrolid) format=32. , count(N) format=32. into :npatients trimmed , :nobs trimmed from &syslast. ; quit ; %put Dataset &syslast. has &nobs. observations and &npatients. patients ; %mend patient_obs;

manya92 · ‎07-05-2018

I used that and thats how the macro resolved :- OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 options mprint ; 74 %macro ocodes ; 75 76 proc sql ; 77 create table _01_otbale2 as 78 %do i = 1 %to 4 ; 79 select distinct enrolid, dx&i. as code 80 from derived._01_itable ; 81 %if &i. le 4 %then %do ; 82 union; 83 %end ; 84 %end ; 85 ; 86 quit; 87 88 %mend ocodes ; 89 %ocodes;/*2617763*/ MPRINT(OCODES): proc sql ; MPRINT(OCODES): create table _01_otbale2 as select distinct enrolid, dx1 as code from derived._01_itable ; NOTE: Table WORK._01_OTBALE2 created, with 675137 rows and 2 columns. NOTE: Line generated by the invoked macro "OCODES". 89 union; _____ 180 MPRINT(OCODES): union; ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. MPRINT(OCODES): select distinct enrolid, dx2 as code from derived._01_itable ; NOTE: Statement not executed due to NOEXEC option. NOTE: Line generated by the invoked macro "OCODES". 89 union; _____ 180 MPRINT(OCODES): union; ERROR 180-322: Statement is not valid or it is used out of proper order. MPRINT(OCODES): select distinct enrolid, dx3 as code from derived._01_itable ; NOTE: Statement not executed due to NOEXEC option. NOTE: Line generated by the invoked macro "OCODES". 89 union; _____ 180 MPRINT(OCODES): union; ERROR 180-322: Statement is not valid or it is used out of proper order. MPRINT(OCODES): select distinct enrolid, dx4 as code from derived._01_itable ; NOTE: Statement not executed due to NOEXEC option. NOTE: Line generated by the invoked macro "OCODES". 89 union; _____ 180 MPRINT(OCODES): union; ERROR 180-322: Statement is not valid or it is used out of proper order. MPRINT(OCODES): ; MPRINT(OCODES): quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.22 seconds cpu time 0.34 seconds 90 91 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 104

manya92 · ‎07-05-2018

%macro icodes ; 403 404 proc sql ; 405 create table _01_itable2 as 406 %do i = 1 %to 14 ; 407 select distinct enrolid, dx&i. as code 408 from derived._01_itable 409 %if &i. le 14 %then %do ; 410 union 411 %end ; 412 %end ; 413 ; 414 quit; 415 416 %mend icodes ; 417 %icodes;/*7716186*/ NOTE: Line generated by the invoked macro "ICODES". 417 ; _ 22 76 ERROR 22-322: Syntax error, expecting one of the following: (, ALL, CORR, CORRESPONDING, SELECT. ERROR 76-322: Syntax error, statement will be ignored. How to solve this kind of an error

manya92 · ‎07-05-2018

Thank You

manya92 · ‎07-05-2018

Even when i wrote this :- , it says OBS variable not found in &syslast. %macro patient_obs() ; %global nobs npatients ; proc sql noprint; select count(distinct enrolid) format=32. , count(obs) format=32. into :npatients trimmed , :nobs trimmed from &syslast. ; quit ; %put Dataset &syslast. has &nobs. observations and &npatients. patients ; %mend patient_obs;

manya92 · ‎07-05-2018

So when i run this MACROS theres no error but when i call this MACROS to give me the number of patients and observations it gives me this error :- 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 %patient_obs ; ERROR: The following columns were not found in the contributing tables: N. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds Dataset WORK._01_ELIG has observations and patients 74 75 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 88 Also, this is what is the code for which the above error appeared :- data derived._01_cohort1 ; set _01_age ; run ;/*12316*/ %patient_obs ;

manya92 · ‎07-05-2018

Please read this in continuation with the previous text Now i wish to create a similar macros that will print the number of distinct patients for me and the numebr of observations so i can see if my dataset is unique p by patient id or not For eg. something like this :- %macro obs ; proc sql ; select count(enrolid), count(obs) from &syslast. ; quit ; %mend obs ; %obs;

manya92 · ‎07-05-2018

I made a MACROS earlier like below : %macro print ; proc print data = &syslast. (obs=10) ; run ; %mend print ; %print ; So whenever i want to print a dataset i simply CALL THE MACROS %print;

manya92 · ‎07-05-2018

For eg, i have different datasets , some of whihc are one row per patient and some are multiple rows per patient. Now instead of writing the whole code like :- proc sql ; select count(enrolid), count(obs) from have ; quit ; i wish to make a MACROS that i have to just call to print this for me each time i want to see the number instead of having to type all that code.

manya92 · ‎07-05-2018

how to do that ? I'd like to see how to do it both by my code (macros) and proc transpose

manya92 · ‎07-05-2018

how to create a macros that counts patient number and observation number for each dataset ? For eg. this is what i made , but it doesnt work %macro willthismacrowork(yn) ; proc sql ; select count(enrolid) , count(obs) from &syslast. ; quit ; %put yn ; %mend willthismacrowork(yn=yes) ; %willthismacrowork ;

manya92 · ‎07-05-2018

%macro icodes ; proc sql ; create table _01_itable2 as %do i = 1 %to 14 ; select distinct enrolid, dx&i. as code from derived._01_itable %if i <14 %then %do ; union %end ; %end ; ; quit; %mend icodes ; %icodes; Whats wrong with this code ? SAS is giving me this error :- NOTE: Line generated by the invoked macro "ICODES". 129 select distinct enrolid, dx&i. as code from derived._01_itable ________ ____ 78 22 76 ERROR 78-322: Expecting a ','.

manya92 · ‎07-02-2018

This is the exclusion crtieria Any patient who had a serious or opportunistic infection within 30 days prior to the index date. 1.1 Infections resulting in hospitalization: any disease/condition listed in the final outcome definition that was coded in any of the 15 diagnosis fields of an inpatient admission claim. Or Infections resulting in administration of intravenous antibiotics: any disease/condition listed in the final outcome definition that was coded in any of the 9 diagnosis fields of an outpatient services claim and which was treated with an intravenous antibiotic as defined by specific Healthcare Common Procedure Coding System code or a National Drug code. Intravenous antibiotic therapy could not be more than 7 days before or 7 days after the infection diagnosis. 001 002 003 004 005 006 007 008 009 010-018 Tuberculosis* 010 011 012 013 014 015 016 017 018 020-027 Zoonotic bacterial diseases 020 021 022 023 024 025 026 027 030-041 Other bacterial diseases 030 031 032 033 034 035 036 037 038 039 040 041 042 Human Immunodeficiency Virus 042 045-049 Poliomyelitis/other non-arthropod viral diseases of CNS* 045 046 047 048 049 050-057 Viral diseases accompanied by exanthem 050 051 052 053 054 055 056 057 060-066 Arthropod-borne viral diseases 060 061 062 063 064 065 066 070-079 Other diseases due to viruses & chlamydiae 070 071 072 073 074 075 076 077 078 079 080-088 Rickettsioses & other arthropod-borne diseases 080 081 082 083 084 085 086 087 088 090-099 Syphilis & other venereal diseases* 090 091 092 093 094 095 096 097 098 099 100-104 Other spirochetal diseases 100 101 102 103 104 110-118 Mycoses* 110 111 112 114 115 116 117 118 120-129 Helminthiases 120 121 122 123 124 125 126 127 128 129 130-136 Other infectious & parasitic diseases 130 131 132 133 134 135 136 137-139 Late effects of infectious & parasitic diseases 137 138 139 254.1 255.8 323.x 324.x 357.0 380.1 382.0 382.9 383.x 384.0 384.1 421.x 422.x 424.9 447.2 457.2 460 461.x 462 463 464.x 465.x 466.x 472 473.x 474.0 475 476.x 480 481 482 483 484 485 486 487.1 487.8 490 491.2 510.x 511.1 513.x 519.1 519.2 522.5 522.7 523.3 528.3 528.5 529.0 540-542 550.0 551.x 566 567.x 569.5 572 572.0 572.1 574.0 574.1 574.3 574.4 575.0 575.1 576.1 590.x 595.x 597.0 597.8 599.0 603.1 604.x 607.1 607.2 614.x 615.0 615.9 616.x 680.x 681.x 682.x 684 685.0 686.x 711.0 711.9 728.0 729.4 730.x 785.4 788.7 790.7 790.8 996.6 998.5 999.3 I need to look for all these codes as they are the for infection conditions requiring hospitalization or IV antibiotics. how can i do this ? I have my cohort with one row per patient called cohort1

manya92 · ‎07-02-2018

If i have to look for 139 codes from 001-139 which can have sub categories , how can i achieve this by simple SAS coding ? or using %str. Also my code list includes ICD9 codes which are not in sequence , for Eg. 254.1, 255.8, 323.x etc. and i want to look for both 001-139 and the second list of random not sequenced codes using simple SAS coding ?

manya92 · ‎07-02-2018

%macro demo; %let ccnames=Myocardial infarction*Congestive heart failure*Peripheral vascular disease*Cerebrovascular disease*Dementia*Chronic pulmonary disease*Rheumatic disease*Peptic ulcer disease*Mild liver disease*Diabetes without chronic complication*Diabetes with chronic complication*Hemiplegia or paraplegia*Renal disease*Any malignancy*Moderate or severe liver disease*Metastatic solid tumor*AIDS/HIV; %let cc1 = %str('I21','I22','I252','410','412'); %let cc2 = %str('I099','I110','I130','I132','I255','I420','I425','I426','I427','I428','I429','I43','I50','P290','39891','40201','40211','40291','40401','40403','40411','40413','40491','40493','4254','4255','4256','4257','4258','4259','428'); %let cc3 = %str('I70','I71','I731','I738','I739','I771','I790','I792','K551','K558','K559','Z958','Z959','0930','4373','440','441','4431','4432','4433','4434','4435','4436','4437','4438','4439','4471','5571','5579','V434'); %do i=1 %to 17; %let ccname=%scan(&ccnames., &i., *); proc sql; create table _15_cohort_cc&i. as select distinct enrolid, "&ccname." AS cc&i. from derived._15_diagtable a inner join derived._15_firstproc b on a.enrolid=b.enrolid and a.code in: (&&cc&i.) and b.first-180<=a.svcdate<=b.first order by enrolid; quit; %end; what is this code doing ? i do not understand macros that well, any help is appreciated

Online Status	Offline
Date Last Visited	‎10-05-2018 01:32 PM

Re: first date

first date

macro

libname

Re: Error 24-2

Error 24-2

Re: macro error

macro error

SAS error proc sql union

find codelist

Re: macro error

Re: macros

Re: macros

Re: The SAS Supervisor

Macro debugging - error in macro code

Re: macros

Re: macros

Re: macros

Re: macros

Re: macros

Re: macros

Re: SAS MACROS

macros

SAS MACROS

Re: macros

Re: macros

macros