it worked in the previous code if type='num' then put ' ' name '=9999;'; else if type='char' then do; put @3 name '= cats("TEST", _n_) ;'; end; if last.memname then put 'run;' ; run; GOT output like 'T' in masked column instead of 'TEST_n_' if the column length is 1 ... View more

@Patrick The code throws an error in fields having length as 1, for example Gender is one field to be masked with lengh 1 and type character it has values like M, F or U. but the code not masking it leaving blank values in it. and produces a Warning as below: WARNING: In a call to the CATS function, the buffer allocated for the result was not long enough to contain the concatenation of all the arguments. The correct result would contain 5 characters, but the actual result might either be truncated to 1 character(s) or be completely blank, depending on the calling environment. The following note indicates the left-most argument that caused truncation. NOTE: Argument 1 to function CATS('TEST',1) at line 163 column 18 is invalid.     ... View more

Thanks Patrick working good 🙂 ... View more

@Patrick  Again i got a blocker here in some Columns which we are masking has no values or null, but the code is masking that value as well eg obs First name Masked First name/ Current output Desired output 1 John Test1 Test1 2 Andrew Test2 Test2 3   Test3   4 Milton Test4 Test3 5   Test5   6   Test6   7 Mark Test7 Test4 8   Test8   9 Rosy Test9 Test5   Obs 3, 5, 6, 8 are blank values in the original dataset so it should be left blank in final dataset as well as given in last column of the above table. i.e blank values in the column should be left as it is it should not be masked in both cases either it is character or number (both cases) Can you please help on this. ... View more

Works Good Thanks Patrick 🙂 ... View more

HI @Patrick,   Hope you are fine and safe,   in the program i changed some lines like below, if type='num' then put ' ' name '=9999;'; else if type='char' then do; put " rl = 'TEST';"; put @3 name ' = rl||Strip(_N_);'; end; if last.memname then put 'run;' ; in the above program it is creating a new column (rl) with records like "Test" in the final dataset,   why i changed code is i need character data to be masked with Test1,Test2,Test3....and so on for the field which is character datatype, example: i am going to mask SURNAME field its Character datatype and my desired output is below,   But what is the problem is i am getting a new field 'rl' is added in the final dataset,   Could you please help me to change the code Thanks   ... View more

added the line it working now Thanks.. ... View more

i am getting error: 119 120 /* execute code for masking */ 121 %include codegen / source2; NOTE: %INCLUDE (level 1) file CODEGEN is file W:\SASWORK\TD765_\#L70. 122 +data out.TEST_1 ; 123 + set INPUT.TEST_1 ; 124 + ="ZZZZZZZZZZZ" ; _ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 125 +run; ... View more

actually i need to copy all datasets using a single program, this program is not copying the datasets without masked column, if there is no masking column it should copy the dataset as it is. i.e. without masking any column it should simply use SET function. ... View more

Actually i have a problem in the code, i have some dataset that has no sensitive columns so need there are no fields to be masked, if i give those dataset names alone in the excel it not copying the dataset since no masking column. can you please modify the code to copy the dataset if it dont have sensitive columns as well ... View more

@Patrick and also the code is copying all the datasets in library(excel sheet) to output path, but I need to copy any one or two of the datasets in excel sheet, how it can be done. just if I specify the name of the dataset it should copy to output path ... View more

Brilliant Thanks a lot man.. working great.... 🙂 ... View more

there is no results produced for this sql step proc sql; create table colsToMask as select c.libname, c.memname, c.name, c.type, c.length as len from ( select upcase(scan(cats('WORK.',dsname),-2,'.')) as libname length=8, upcase(scan(dsname,-1,'.')) as memname length=32, upcase(colname) as name length=32 from excel ) e , dictionary.columns c where e.libname=c.libname and e.memname=c.memname and e.name=upcase(c.name) and c.memtype='DATA' order by c.libname, c.memname ; quit; five columns are created like libname,memname,name,type,len but no entries are there.. can you please check this? ... View more

I tried the above code, there is no rows in coltomask table which created ... View more

what is the use of code gen file can you please explain your code. ... View more