Log below. Project Log turned on at 5/29/2014 12:58:14 PM Log for "Program" run at 5/29/2014 12:58:30 PM on SASCSGPrdb 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='Program'; 4 %LET _CLIENTPROJECTPATH=''; 5 %LET _CLIENTPROJECTNAME=''; 6 %LET _SASPROGRAMFILE=; 7 8 ODS _ALL_ CLOSE; 9 OPTIONS DEV=ACTIVEX; 10 GOPTIONS XPIXELS=0 YPIXELS=0; 11 FILENAME EGSR TEMP; 12 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR STYLE=HtmlBlue 12 ! STYLESHEET=(URL="file:///C:/Program%20Files/SAS%209.3.0%20(SAS%20BI%20Solutions)/x86/SASEnterpriseGuide/5.1/Styles/HtmlBl 12 ! ue.css") NOGTITLE NOGFOOTNOTE GPATH=&sasworklocation ENCODING=UTF8 options(rolap="on"); NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR 13 14 GOPTIONS ACCESSIBLE; 15 proc import 16 datafile="&path./&sysuserid/&custrun./asgnroletypid.csv" 17 out=asgnroletypid dbms=csv; 18 run; NOTE: Import cancelled. Output dataset WORK.ASGNROLETYPID already exists. Specify REPLACE option to overwrite it. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 31.15k OS Memory 21032.00k Timestamp 05/29/2014 12:58:27 PM Page Faults 0 Page Reclaims 2 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 19 20 proc sql; 21 select compress("'"||roletypid||"'") into :roletypid separated by "," 22 from asgnroletypid 23 ; 24 quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 704.68k OS Memory 21544.00k Timestamp 05/29/2014 12:58:27 PM Page Faults 0 Page Reclaims 126 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 25 %put role &roletypid.; role 'MD','RMD','MDS','PH','PHC','PHCMP','CMP' 26 proc sql; 27 create table tmphsc1 as 28 select * 29 from tmphsc 30 /* WHERE actv_chgusr_role IN ('MD','RMD','MDS','PH','PHC','PHCMP','CMP')*/ 31 WHERE actv_chgusr_role IN (&roletypid.) 32 and mbr_id = 16991 33 ; NOTE: Table WORK.TMPHSC1 created, with 0 rows and 16 columns. 34 run; NOTE: PROC SQL statements are executed immediately; The RUN statement has no effect. 35 36 GOPTIONS NOACCESSIBLE; 37 %LET _CLIENTTASKLABEL=; 38 %LET _CLIENTPROJECTPATH=; 39 %LET _CLIENTPROJECTNAME=; 40 %LET _SASPROGRAMFILE=; 41 42 ;*';*";*/;quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.03 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 568.18k OS Memory 21544.00k Timestamp 05/29/2014 12:58:27 PM Page Faults 10 Page Reclaims 35 Page Swaps 0 Voluntary Context Switches 15 Involuntary Context Switches 1 Block Input Operations 0 Block Output Operations 0 42 ! run; 43 ODS _ALL_ CLOSE; 44 45 46 QUIT; RUN; 47 Log for "Program" run at 5/29/2014 1:00:35 PM on SASCSGPrdb 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='Program'; 4 %LET _CLIENTPROJECTPATH=''; 5 %LET _CLIENTPROJECTNAME=''; 6 %LET _SASPROGRAMFILE=; 7 8 ODS _ALL_ CLOSE; 9 OPTIONS DEV=ACTIVEX; 10 GOPTIONS XPIXELS=0 YPIXELS=0; 11 FILENAME EGSR TEMP; 12 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR STYLE=HtmlBlue 12 ! STYLESHEET=(URL="file:///C:/Program%20Files/SAS%209.3.0%20(SAS%20BI%20Solutions)/x86/SASEnterpriseGuide/5.1/Styles/HtmlBl 12 ! ue.css") NOGTITLE NOGFOOTNOTE GPATH=&sasworklocation ENCODING=UTF8 options(rolap="on"); NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR 13 14 GOPTIONS ACCESSIBLE; 15 proc import 16 datafile="&path./&sysuserid/&custrun./asgnroletypid.csv" 17 out=asgnroletypid9 dbms=csv; 18 run; NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to WORK.PARMS.PARMS.SLIST. 19 /********************************************************************** 20 * PRODUCT: SAS 21 * VERSION: 9.3 22 * CREATOR: External File Interface 23 * DATE: 29MAY14 24 * DESC: Generated SAS Datastep Code 25 * TEMPLATE SOURCE: (None Specified.) 26 ***********************************************************************/ 27 data WORK.ASGNROLETYPID9 ; 28 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */ 29 infile '/sasprdb/optum/rad/users/ddonah6/medtime2touch/asgnroletypid.csv' delimiter = ',' MISSOVER DSD lrecl=32767 29 ! firstobs=2 ; 30 informat roletypid $6. ; 31 format roletypid $6. ; 32 input 33 roletypid $ 34 ; 35 if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */ 36 run; NOTE: The infile '/sasprdb/optum/rad/users/ddonah6/medtime2touch/asgnroletypid.csv' is: Filename=/sasprdb/optum/rad/users/ddonah6/medtime2touch/asgnroletypid.csv, Owner Name=ddonah6,Group Name=ioprad, Access Permission=rw-r--r--, Last Modified=Wed May 28 15:36:51 2014, File Size (bytes)=46 NOTE: 7 records were read from the infile '/sasprdb/optum/rad/users/ddonah6/medtime2touch/asgnroletypid.csv'. The minimum record length was 3. The maximum record length was 6. NOTE: The data set WORK.ASGNROLETYPID9 has 7 observations and 1 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 6219.29k OS Memory 24372.00k Timestamp 05/29/2014 01:00:31 PM Page Faults 0 Page Reclaims 74 Page Swaps 0 Voluntary Context Switches 16 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 7 rows created in WORK.ASGNROLETYPID9 from /sasprdb/optum/rad/users/ddonah6/medtime2touch/asgnroletypid.csv. NOTE: WORK.ASGNROLETYPID9 data set was successfully created. NOTE: The data set WORK.ASGNROLETYPID9 has 7 observations and 1 variables. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.09 seconds user cpu time 0.03 seconds system cpu time 0.01 seconds memory 6219.29k OS Memory 24372.00k Timestamp 05/29/2014 01:00:31 PM Page Faults 9 Page Reclaims 779 Page Swaps 0 Voluntary Context Switches 61 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 37 38 proc sql; 39 select compress("'"||roletypid||"'") into :roletypid separated by "," 40 from asgnroletypid9 41 ; 42 quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 705.31k OS Memory 22312.00k Timestamp 05/29/2014 01:00:31 PM Page Faults 0 Page Reclaims 28 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 43 %put role &roletypid.; role 'MD','RMD','MDS','PH','PHC','PHCMP','CMP' 44 proc sql; 45 create table tmphsc1 as 46 select * 47 from tmphsc 48 /* WHERE actv_chgusr_role IN ('MD','RMD','MDS','PH','PHC','PHCMP','CMP')*/ 49 WHERE actv_chgusr_role IN (&roletypid.) 50 and mbr_id = 16991 51 ; NOTE: Table WORK.TMPHSC1 created, with 0 rows and 16 columns. 52 run; NOTE: PROC SQL statements are executed immediately; The RUN statement has no effect. 53 54 GOPTIONS NOACCESSIBLE; 55 %LET _CLIENTTASKLABEL=; 56 %LET _CLIENTPROJECTPATH=; 57 %LET _CLIENTPROJECTNAME=; 58 %LET _SASPROGRAMFILE=; 59 60 ;*';*";*/;quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.03 seconds user cpu time 0.00 seconds system cpu time 0.01 seconds memory 567.59k OS Memory 22312.00k Timestamp 05/29/2014 01:00:31 PM Page Faults 9 Page Reclaims 23 Page Swaps 0 Voluntary Context Switches 16 Involuntary Context Switches 1 Block Input Operations 0 Block Output Operations 0 60 ! run; 61 ODS _ALL_ CLOSE; 62 63 64 QUIT; RUN; 65
... View more
