Hi , I am calculating Processing , start time and count of nid and wanted to get them into dataset sas %let Rcc = 66; %let ty=p; %let datetime_start = %sysfunc(TIME()); %let START_TIME_WITHV&&Rcc = %sysfunc(datetime(),datetime14.); %put &&START_TIME_WITHV&Rcc; data scores; infile datalines truncover; input nid $ 1-12 score2 17-20 score1 27-30; datalines; Riley 1132 987 Henderson 1015 1102 ; %let END_TIME_WITH_V&&Rcc= %sysfunc(datetime(),datetime14.); %put &&END_TIME_WITH_V&Rcc; %let PROCESSING_TIMEV&&Rcc= %sysevalf(%sysfunc(TIME())-&datetime_start.); %put &&PROCESSING_TIMEV&Rcc; proc contents data= scores out=ty_contents; run; proc sql noprint; select name into :score_t_&&Rcc from ty_contents where prxmatch("s/nid//i",name); select count(distinct &&score_t_&Rcc) into :s_cnt&&Rcc from scores(keep=&&score_t_&Rcc); quit; %put &&score_t_&Rcc &&s_cnt&Rcc; /*count , start time and processing time variables into dataset */ data test5; Date = SYMGET('START_TIME_WITHV&&Rcc'); length count&&Rcc_pp 3; length V&&Rcc_Runtime 8; count&&Rcc_pp = SYMGET('s_cnt&&Rcc'); V&&Rcc_time=SYMGET('PROCESSING_TIMEV&Rcc'); format V&&Rcc_time TIME11.2; run; How to get Date into test5 and also , how to get count into dataset , how to get processing time into test5 dataset Can anyone please help Thanks
... View more