Hi there    I am trying to use %nrstr and %str. I am passing my variable in the function however it wont work when trying to reference the value of the variable   e.g.  %let myvar = crazy&609 %let maskedname = %nrstr(&myvar.); %put &maskedfile.;   the masking works fine when doing this but not when using the variable: %let maskedname = %nrstr(crazy&609); ... View more

Hi there, I am trying to change the format of my field called Passport to $15 and keep it that way. How do I do that? I initially used proc import and copied and pasted the informat code. Not sure if there is a more sleek way as with various csv files coming in the format won't always be the same, where there will be various columns of different data types. I need to ensure that on every csv import, the column called Passport will change to character type. In some instances the passport number is only numeric however I need this column to be character as other files might have this field as alpha-numeric.    Is there perhaps a better way to use infile and ensure the Passport field remains character throughout? data work.test; infile "C:/mycsv.csv" delimiter = "," missover dsd firstobs=2 ; informat Code best32. ; informat Name $14. ; informat Firstname $35. ; informat Passport best32. ; format Code best12. ; format Name $14. ; format Firstname $35. ; format Passport $15. ; input Code Name $ Firstname $ Passport ; run; ... View more