Hi  i have a employee level transactions data which shows type of transaction and the date of the transaction that the employee did i have one more data which has the employee job information( the table is shown below ) , i have to calculate the job code tenure of the employee  The logic to calculate the job code tenure is like this : lets say the employee did transactions on 13th and 16th july-2020 then against the 16th july i have to mark CA as the job code and the tenure will be (16july-15-jul) ,and this is because on 16th july the date less then 16th july is 15th july , and the job code was CA. for 13th july i have to mark LA as the job code and the tenure will be (13th july- 13 Jan) , and this is because on 13th july the date less then 13th july is 13 jun , and the job code was LA which started from 13-jan-19 Please note that job code CA is repeated after the LA , we shouldn't consider these while calculating the tenure for 15th july.   i have also attached the below table in Excel format.   EMP_ID Job_cd cre_dt 1 CA 15-Jul-20 1 LA 13-Jun-20 1 LA 12-Jun-20 1 LA 02-May-20 1 LA 13-Jan-19 1 CA 12-Dec-19 1 CA 11-Oct-19 1 DA 01-Jan-18 1 DA 01-Jun-18 1 DA 15-Nov-18 ... View more

I have a data set like below , here Y is Yes and N means No   data have; infile cards dlm='09'x; input a$ b$; cards; N Y N Y N Y N Y N Y N Y N Y N Y N Y N Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y N Y N Y N Y N Y N Y N Y N ; run;   i have to create a summary like below for the counts of a and b   Row Labels B No B Yes Grand Total A no   10 10 A Yes 7 7 14 Grand Total 7 17 24 the Numbers present in the want table is the count of Y and N of the Have dataset , the number present in each cell is determined like below :   Here A no and B No is if A and b couloumn both are N A no B yes means column A is N and column B is Y A yes B No means column A is Y and column B is N  A Yes B Yes means both column A  and Column B is Y ... View more

Hi  I have a table like below (as table Have) , we want a table (like want)   first i have to select the highest servnum for a cntnum (which is 6564 for cntnum 153787)    now the cate for the highest cntnum  is 5 ,  so in the final output we have to select all the lines where the cate is less than equal to 5 (i.e 5,4,3,2 for this case)   NOTE: the cate 5 is repeated here for cntnum 153787 in that case we need to select the line where the servnum is the highest  (that is we need to select the first row)   data have cntnum servnum linenum cate 153787 6564 6563 5 153787 6563 6390 4 153787 6562 6561 6 153787 6561 5934 5 153787 6560 6559 6 153787 6559 4532 5 153787 6558 1430 6 153787 6557 3768 5 153787 6556 6555 6 153787 6555 6554 5 153787 6554 6553 4 153787 6553 6552 3 153787 6552 1 2 256434 198 197 3 256434 197 1 2 256434 195 194 5 256434 194 193 4 256434 193 192 3 256434 192 1 2   data want  cntnum servnum linenum cate 153787 6564 6563 5 153787 6563 6390 4 153787 6553 6552 3 153787 6552 1 2 256434 198 197 3 256434 197 1 2           ... View more

Hi i am trying to create multiple table from a dataset , so in the data statement i have mentioned all those table name (macro variable table_name)    i have pasted the log file which is showing some syntax error , please help me to resolve the issue      23 GOPTIONS ACCESSIBLE; SYMBOLGEN: Macro variable TABLE_NAME resolves to ATLANTA BRECKSVILLE CHICAGO CLEVELAND COLUMBUS DETROIT MIDDLEBRG_HTS MOUNT_VERNON PHILA PHILADELPHIA SYLVANIA TOLEDO 24 data &table_name.; 25 set multiple_table; 26 do i=1 to &count.; SYMBOLGEN: Macro variable COUNT resolves to 12 27 if ProviderCity = cat('"',scan(&var_names.,i,","),'"') then output scan(&output_name.,i,","); SYMBOLGEN: Macro variable VAR_NAMES resolves to "ATLANTA,BRECKSVILLE,CHICAGO,CLEVELAND,COLUMBUS,DETROIT,MIDDLEBRG HTS,MOUNT VERNON,PHILA,PHILADELPHIA,SYLVANIA,TOLEDO" SYMBOLGEN: Macro variable OUTPUT_NAME resolves to "ATLANTA,BRECKSVILLE,CHICAGO,CLEVELAND,COLUMBUS,DETROIT,MIDDLEBRG_HTS,MOUNT_VERNON,PHILA,PHILADELPHIA,SYLVANIA,TOLEDO" 27 if ProviderCity = cat('"',scan(&var_names.,i,","),'"') then output scan(&output_name.,i,","); _ 22 ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, ;, RC, _DATA_, _LAST_, _NULL_. 27 if ProviderCity = cat('"',scan(&var_names.,i,","),'"') then output scan(&output_name.,i,","); _ 76 ERROR 76-322: Syntax error, statement will be ignored. 28 end; 29 run;   ... View more

Hi    i have a data set like below , i want to count the number of One (1) present in each variable    Data have; infile cards dlm= '09'x; input Var1-var7; cards; 0 0 0 0 1 1 1 0 0 0 0 0 1 1 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 1 0 1 0 1 0 0 0 0 0 0 0 1 0 0 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 0 0 0 1 1 1 0 0 1 1 0 0 0 0 0 0 0 0 0 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 1 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 1 0 0 0 1 1 0 0 0 ; run;     Final output should be like below    Var_name count Var1 3 Var2 3 Var3 5 Var4 5 Var5 4 Var6 7 Var7 4 ... View more