another way I can think of by using lookup table and prxchange.     /*have a lookuptable with all your values*/ data lookup; value ="IRAN|INDIA|USA|United States of America"; run; /*this is your table*/ data mytable; length col1 $200.; col1= "Further Credit to Bank ABC IRAN"; output; col1= "Forward Credit to India from Salman Ali"; output; col1= "For further credit from Bank XYZ USA to Account of Rakesh Roy"; output; col1= "Forward Credit to Bank in United States of America from Salman Al" ; output; run; /*create macrovariable to use this in your prxchange query */ data _null_; set lookup; call symputx("value", value); run; %put &value; data final; set mytable; suffix = prxchange("s/(.*)(&value)(.*)/$2/i", -1, col1); run; ... View more

because you have "High" not "high" in your else statement.   else if level = 2 or 3 then exp="Medium"; change it to    else if level = 2 or level = 3 then exp="Medium";   ... View more

change your code to below level = 3 is missing. becacuase there is no "high" assigned and change your dataset name in set statement to have instead of levels     data want; set work.have; if level=. then exp="unknown"; else if level=1 then exp="Low"; else if level = 2 or level = 3 then exp="Medium"; else exp="High"; run;   ... View more

is your Netezza table,  newly created table or you are appending the data to already created netezza table(Just for information, Proc append will create table, if same name table is not there). if it is already created table, you cannot change datatype. for changing datatypes will have multiple restrictions, most often you have to recreate netezza table.       ... View more

this is appending to netezza table. your base table is netezza table ... View more

if you have SAS dataset with number and you can map it to byteint. As said previously post SAS is pretty smart in mapping most of time.   SAS numeric can be mapped to byteint int decimal easily and it takes care of its own SAS charcter to char varchar etc.   I am not sure, what exactly issue your having.   try using dbsastype as shown in below example . info on dbsastype in the link http://support.sas.com/documentation/cdl/en/acreldb/63647/HTML/default/viewer.htm#a001371572.htm   proc append base=dblib.hrdata (dbsastype=(empid='CHAR(20)')) data=saslib.personnel; run; ... View more

did u run the codes. first 2 work if your month, day and year are allowable then mdy code work.  ... View more

see the below example . even if you have data in character values this works albite it gives note in log.(first 2 examples work) unless some of your does not make date, which cause this issue. check the examples in code below data want; mnth = 1; d = 2; yr =2016; newdate=mdy(mnth,d,yr); format newdate mmddyy10.; run; data want1; mnth = "1"; d = "2"; yr ="2016"; newdate=mdy(mnth,d,yr); format newdate mmddyy10.; run; /* this will not work because there is 13 as month and result in . and you have note in log NOTE: Invalid argument to function MDY(13,2,2016) at line 77 column 9.*/ data want3; mnth = 13; d = 2; yr =2016; newdate=mdy(mnth,d,yr); format newdate mmddyy10.; run;   ... View more

try making new column name as date and I have updated my answer ... View more