MACRO GET ATTR: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
Die Seite wurde neu angelegt: „Kategorie:zazy %MACRO GET_ATTR(dsn=,source=,attrib=) / store des = "Get attribute from SAS Variable"; %LOCAL name; %LET name = GET_ATTR; '''%IF &DSN…“ |
KKeine Bearbeitungszusammenfassung |
||
| (5 dazwischenliegende Versionen desselben Benutzers werden nicht angezeigt) | |||
| Zeile 1: | Zeile 1: | ||
[[Kategorie:zazy]] | [[Kategorie:zazy]] | ||
{{SeitenNavigation1 | |||
|links=xx_left.png | |||
|rechts=xx_right.png | |||
|hoch=FRAKTAL_MACRO_ARCHITECTURE.png | |||
|zurück=MACRO TWO BOBO | |||
|vorwärts=MACRO GRP DESC | |||
|übersicht=Info Modules (from Phase-III Macro System) | |||
}} | |||
[[Datei:FRAKTAL_MACRO_ARCHITECTURE.png|200px|thumb]] | |||
== Type == | |||
'''Info module''' from [[Phase-III Macro System]] based on '''''[[Fraktal SAS Programming|Fractal System Architecture]]'''''. | |||
==Source== | |||
%MACRO GET_ATTR(dsn=,source=,attrib=) / store des = "Get attribute from SAS Variable"; | %MACRO GET_ATTR(dsn=,source=,attrib=) / store des = "Get attribute from SAS Variable"; | ||
| Zeile 5: | Zeile 21: | ||
%LOCAL name; | %LOCAL name; | ||
%LET name = GET_ATTR; | %LET name = GET_ATTR; | ||
'''%IF &DSN ne and &SOURCE ne and &ATTRIB ne %THEN %DO;''' | '''%IF &DSN. ne and &SOURCE. ne and &ATTRIB. ne %THEN %DO;''' | ||
'''%IF %INDEX(&DSN,.) eq 0 %THEN %DO;''' | '''%IF %INDEX(&DSN.,.) eq 0 %THEN %DO;''' | ||
%LET dsn=WORK.&DSN; | %LET dsn=WORK.&DSN.; | ||
'''%END;''' | '''%END;''' | ||
''proc datasets nolist lib = %SCAN(&DSN,1);'' | ''proc datasets nolist lib = %SCAN(&DSN.,1);'' | ||
''contents noprint data = %SCAN(&DSN,2)(keep=&SOURCE) out = work.tmp_data(keep=&ATTRIB);'' | ''contents noprint data = %SCAN(&DSN.,2)(keep=&SOURCE.) out = work.tmp_data(keep = &ATTRIB.);'' | ||
''run;'' | ''run;'' | ||
''quit;'' | ''quit;'' | ||
''proc sql noprint;'' | ''proc sql noprint;'' | ||
''select &ATTRIB'' | ''select &ATTRIB.'' | ||
'' into :&ATTRIB'' | '' into :&ATTRIB.'' | ||
'' from work.tmp_data'' | '' from work.tmp_data'' | ||
'';'' | '';'' | ||
'''%IF %UPCASE(&ATTRIB) ne LABEL %THEN %DO;''' | '''%IF %UPCASE(&ATTRIB.) ne LABEL %THEN %DO;''' | ||
%LET &ATTRIB = &&&ATTRIB; | %LET &ATTRIB. = &&&ATTRIB.; | ||
'''%END;''' | '''%END;''' | ||
''quit;'' | ''quit;'' | ||
%PUT &NAME._MESSAGE: Temporary SAS dataset WORK.TMP_DATA created ; | %PUT &NAME._MESSAGE: Temporary SAS dataset WORK.TMP_DATA created ; | ||
%PUT &NAME._MESSAGE: Field %UPCASE(&SOURCE) in dataset %UPCASE(&DSN) has &ATTRIB = %BQUOTE(&&&ATTRIB.). ; | %PUT &NAME._MESSAGE: Field %UPCASE(&SOURCE.) in dataset %UPCASE(&DSN.) has &ATTRIB. = %BQUOTE(&&&ATTRIB.). ; | ||
%PUT &NAME._MESSAGE: Information stored into Local Macrovariable of calling environment: ; | %PUT &NAME._MESSAGE: Information stored into Local Macrovariable of calling environment: ; | ||
%PUT &NAME._MESSAGE: &ATTRIB=%BQUOTE(&&&ATTRIB); | %PUT &NAME._MESSAGE: &ATTRIB. = %BQUOTE(&&&ATTRIB.); | ||
%PUT ; | %PUT ; | ||
'''%END;''' | '''%END;''' | ||
| Zeile 34: | Zeile 50: | ||
%PUT &NAME._STATUS: Global Macrovariable(s) not available. ; | %PUT &NAME._STATUS: Global Macrovariable(s) not available. ; | ||
%PUT ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^; | %PUT ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^; | ||
%GEN_MAIL(name=&NAME,rc=1); | %GEN_MAIL(name = &NAME.,rc = 1); | ||
'''%END;''' | '''%END;''' | ||
%MEND GET_ATTR; | %MEND GET_ATTR; | ||
Aktuelle Version vom 5. März 2014, 21:03 Uhr
|
|
|
|
Type
Info module from Phase-III Macro System based on Fractal System Architecture.
Source
%MACRO GET_ATTR(dsn=,source=,attrib=) / store des = "Get attribute from SAS Variable";
%LOCAL name; %LET name = GET_ATTR; %IF &DSN. ne and &SOURCE. ne and &ATTRIB. ne %THEN %DO; %IF %INDEX(&DSN.,.) eq 0 %THEN %DO; %LET dsn=WORK.&DSN.; %END; proc datasets nolist lib = %SCAN(&DSN.,1); contents noprint data = %SCAN(&DSN.,2)(keep=&SOURCE.) out = work.tmp_data(keep = &ATTRIB.); run; quit; proc sql noprint; select &ATTRIB. into :&ATTRIB. from work.tmp_data ; %IF %UPCASE(&ATTRIB.) ne LABEL %THEN %DO; %LET &ATTRIB. = &&&ATTRIB.; %END; quit; %PUT &NAME._MESSAGE: Temporary SAS dataset WORK.TMP_DATA created ; %PUT &NAME._MESSAGE: Field %UPCASE(&SOURCE.) in dataset %UPCASE(&DSN.) has &ATTRIB. = %BQUOTE(&&&ATTRIB.). ; %PUT &NAME._MESSAGE: Information stored into Local Macrovariable of calling environment: ; %PUT &NAME._MESSAGE: &ATTRIB. = %BQUOTE(&&&ATTRIB.); %PUT ; %END; %ELSE %DO; %PUT vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv; %PUT &NAME._ERROR: Missing Keyword Parameter(s).; %PUT &NAME._STATUS: Macro processing abended. ; %PUT &NAME._STATUS: Global Macrovariable(s) not available. ; %PUT ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^; %GEN_MAIL(name = &NAME.,rc = 1); %END;
%MEND GET_ATTR;