Hi everyone,      Is there a code or related option to get all macro parameters from a macro？     Just like, someone told me that such a macro(%gen) can be used.     Actually this macro has 2 macro parameters, %gen(in=,out=) .     but I don't how to use it and how many parameters in it, so is there a macro or code or option can help me to put all macro parameters in log?     Just like %gen(in=,out=) be print in log.     Thanks!     ... View more

Hi all,   Why I run the data B, the log report " Missing values were generated as a result of performing an operation on missing value"   But the log of data C is clean.   I want to use the data B with the clean log. Thanks.  data a; a="20DEC2019:00:00:00.000"dt;output; a=.;output; format a DATETIME22.3; run; data b; set a; c=ifc(a ne .,put(datepart(a),date9.),''); run; data c; set a ; if a ne . then c=put(datepart(a),date9.); else c=''; run;   ... View more

Hi all,   what I have : data WORK.SUPPCM; infile datalines dsd truncover; input USUBJID $ 1 IDVARVAL $ 3-4 QNAM $ 6-9 QVAL :$200.; label USUBJID="Unique Subject Identifier" IDVARVAL="Identifying Variable Value" QNAM="Qualifier Variable Name" QVAL="Data Value"; datalines; a 1 ATC AAA a 1 ATC3 BBB a 10 ATC OLISM a 10 ATC3 GASTRO a 11 ATC CSYSTEM a 11 ATC3 SFFECTS a 12 ATC VARIOUS a 13 ATC ALISM a 13 ATC3 DRESOPHAGERD a 2 ATC ANTNTS a 2 ATC3 ANTIMES a 3 ATC ANTINEOPLLATING AGENTS a 3 ATC3 OTHASTS a 4 ATC ANTINGENTS a 4 ATC3 ANTIMITES a 5 ATC CARDEM b 1 ATC FF b 1 ATC3 DDFAS b 10 ATC OLIFASFSM b 10 ATC3 GASFTRO b 11 ATC CSYASTEM b 11 ATC3 SFFSDECTS b 12 ATC VAFRIOUS b 13 ATC ALISM b 13 ATC3 DRFESOPHAGERD b 14 ATC ALIFSM b 14 ATC3 DRFDESOPHAGERD b 2 ATC ANTNSDFTS b 2 ATC3 ANTIMES b 3 ATC ANTINEOPLLATING AGENTS b 3 ATC3 OTHASDSTS b 4 ATC ANTIFNGENTS b 4 ATC3 ANTIMITES b 5 ATC CARDSDEM b 5 ATC3 CARDSDEM b 6 ATC fssdf b 6 ATC3 FSDFD ;;;; run; data WORK.CM; infile datalines dsd truncover; input USUBJID $ 1 CMSEQ; label USUBJID="Unique Subject Identifier" CMSEQ="Sequence Number"; datalines; a 1 a 2 a 3 a 4 a 5 a 6 a 7 a 8 a 9 a 10 a 11 a 12 a 13 b 1 b 2 b 3 b 4 b 5 b 6 b 7 b 8 b 9 b 10 b 11 b 12 b 13 b 14 b 15 b 16 ;;;; run; and my code is as below: data cm1; if _n_=1 then do; dcl hash h(); h.definekey('usubjid','cmseq'); h.definedata('usubjid','cmseq','atc','atc3'); h.definedone(); end; do until(last.idvarval); set suppcm; by usubjid idvarval; if qnam='ATC' then atc=qval; if qnam='ATC3' then atc3=qval; end; cmseq=input(idvarval,best.); h.add(); set cm; call missing(atc,atc3); rc=h.find(); keep usubjid cmseq atc atc3 ; run; What puzzled me is that atc and atc3 are all missing when cmseq=2,3,4,5,6,7,8,9.     Is something wrong with my code？Please help me. Thanks. ... View more

Hi all，   I'm writing a piece of code about hash. Detail please see as below.   data cm1; if _n_=1 then do; dcl hash h(); h.definekey('usubjid','cmseq'); h.definedata('usubjid','cmseq','atc','atc3'); h.definedone(); end; do until(last.idvarval); set suppcm; by usubjid idvarval; if qnam='ATC' then atc=qval; if qnam='ATC3' then atc3=qval; end; cmseq=input(idvarval,best.); h.add(); set cm; if h.check()=0 then a=1; call missing(atc,atc3); rc=h.find(); keep usubjid cmseq atc atc3 a; run;     What makes me amazed is that cmseq=2-9 is always missing，but the data is exist when 2<=cmseq<=9.     When I use h.output() to output hash object，it real exist:     Is there something wrong with my code？   The structure of SUPPCM is as follows:   Thanks.   What I have：   data WORK.SUPPCM; infile datalines dsd truncover; input USUBJID $ 1 IDVARVAL $ 3-4 QNAM $ 6-9 QVAL :$200.; label USUBJID="Unique Subject Identifier" IDVARVAL="Identifying Variable Value" QNAM="Qualifier Variable Name" QVAL="Data Value"; datalines; 1 1 ATC ANTINEOPLASTIC AND IMMUNOMODULATING AGENTS 1 1 ATC3 OTHER ANTINEOPLASTIC AGENTS 1 10 ATC ALIMENTARY TRACT AND METABOLISM 1 10 ATC3 DRUGS FOR PEPTIC ULCER AND GASTRO-OESOPHAGEAL REFLUX DISEASE (GORD) 1 11 ATC CARDIOVASCULAR SYSTEM 1 11 ATC3 SELECTIVE CALCIUM CHANNEL BLOCKERS WITH MAINLY VASCULAR EFFECTS 1 12 ATC VARIOUS 1 13 ATC ALIMENTARY TRACT AND METABOLISM 1 13 ATC3 DRUGS FOR PEPTIC ULCER AND GASTRO-OESOPHAGEAL REFLUX DISEASE (GORD) 1 14 ATC CARDIOVASCULAR SYSTEM 1 14 ATC3 SELECTIVE CALCIUM CHANNEL BLOCKERS WITH MAINLY VASCULAR EFFECTS 1 15 ATC VARIOUS 1 16 ATC VARIOUS 1 17 ATC VARIOUS 1 18 ATC VARIOUS 1 2 ATC ANTINEOPLASTIC AND IMMUNOMODULATING AGENTS 1 2 ATC3 ANTIMETABOLITES 1 3 ATC ANTINEOPLASTIC AND IMMUNOMODULATING AGENTS 1 3 ATC3 OTHER ANTINEOPLASTIC AGENTS 1 4 ATC ANTINEOPLASTIC AND IMMUNOMODULATING AGENTS 1 4 ATC3 ANTIMETABOLITES 1 5 ATC CARDIOVASCULAR SYSTEM 1 5 ATC3 SELECTIVE CALCIUM CHANNEL BLOCKERS WITH MAINLY VASCULAR EFFECTS 1 6 ATC ALIMENTARY TRACT AND METABOLISM 1 6 ATC3 DRUGS FOR PEPTIC ULCER AND GASTRO-OESOPHAGEAL REFLUX DISEASE (GORD) 1 7 ATC RESPIRATORY SYSTEM 1 7 ATC3 EXPECTORANTS, EXCL. COMBINATIONS WITH COUGH SUPPRESSANTS 1 8 ATC RESPIRATORY SYSTEM 1 8 ATC3 EXPECTORANTS, EXCL. COMBINATIONS WITH COUGH SUPPRESSANTS 1 9 ATC ANTIINFECTIVES FOR SYSTEMIC USE 1 9 ATC3 OTHER ANTIBACTERIALS ;;;; run; data WORK.CM; infile datalines dsd truncover; input USUBJID $ 1 CMSEQ; label USUBJID="Unique Subject Identifier" CMSEQ="Sequence Number"; datalines; 1 1 1 2 1 3 1 4 1 5 1 6 1 7 1 8 1 9 1 10 1 11 1 12 1 13 1 14 1 15 1 16 1 17 1 18 1 19 ;;;; run; data WORK.SUPPCM; infile datalines dsd truncover; input USUBJID:$30. IDVARVAL:$40. QNAM:$8. QVAL:$200.; label USUBJID="Unique Subject Identifier" IDVARVAL="Identifying Variable Value" QNAM="Qualifier Variable Name" QVAL="Data Value"; datalines; 1 1 ATC ANTINEOPLASTIC AND IMMUNOMODULATING AGENTS 1 1 ATC3 OTHER ANTINEOPLASTIC AGENTS 1 10 ATC ALIMENTARY TRACT AND METABOLISM 1 10 ATC3 DRUGS FOR PEPTIC ULCER AND GASTRO-OESOPHAGEAL REFLUX DISEASE (GORD) 1 11 ATC CARDIOVASCULAR SYSTEM 1 11 ATC3 SELECTIVE CALCIUM CHANNEL BLOCKERS WITH MAINLY VASCULAR EFFECTS 1 12 ATC VARIOUS 1 13 ATC ALIMENTARY TRACT AND METABOLISM 1 13 ATC3 DRUGS FOR PEPTIC ULCER AND GASTRO-OESOPHAGEAL REFLUX DISEASE (GORD) 1 14 ATC CARDIOVASCULAR SYSTEM 1 14 ATC3 SELECTIVE CALCIUM CHANNEL BLOCKERS WITH MAINLY VASCULAR EFFECTS 1 15 ATC VARIOUS 1 16 ATC VARIOUS 1 17 ATC VARIOUS 1 18 ATC VARIOUS 1 2 ATC ANTINEOPLASTIC AND IMMUNOMODULATING AGENTS 1 2 ATC3 ANTIMETABOLITES 1 3 ATC ANTINEOPLASTIC AND IMMUNOMODULATING AGENTS 1 3 ATC3 OTHER ANTINEOPLASTIC AGENTS 1 4 ATC ANTINEOPLASTIC AND IMMUNOMODULATING AGENTS 1 4 ATC3 ANTIMETABOLITES 1 5 ATC CARDIOVASCULAR SYSTEM 1 5 ATC3 SELECTIVE CALCIUM CHANNEL BLOCKERS WITH MAINLY VASCULAR EFFECTS 1 6 ATC ALIMENTARY TRACT AND METABOLISM 1 6 ATC3 DRUGS FOR PEPTIC ULCER AND GASTRO-OESOPHAGEAL REFLUX DISEASE (GORD) 1 7 ATC RESPIRATORY SYSTEM 1 7 ATC3 EXPECTORANTS, EXCL. COMBINATIONS WITH COUGH SUPPRESSANTS 1 8 ATC RESPIRATORY SYSTEM 1 8 ATC3 EXPECTORANTS, EXCL. COMBINATIONS WITH COUGH SUPPRESSANTS 1 9 ATC ANTIINFECTIVES FOR SYSTEMIC USE 1 9 ATC3 OTHER ANTIBACTERIALS ;;;; run; data WORK.CM; infile datalines dsd truncover; input USUBJID:$30. CMSEQ:BEST.; format CMSEQ BEST.; label USUBJID="Unique Subject Identifier" CMSEQ="Sequence Number"; datalines; 1 1 1 2 1 3 1 4 1 5 1 6 1 7 1 8 1 9 1 10 1 11 1 12 1 13 1 14 1 15 1 16 1 17 1 18 1 19 ;;;; run;     ... View more