Greetings, I am getting an error which I have not been able to troubleshoot with google or by searching these forums. I get the following error when trying to open a dataset outputted by a proc freq. ERROR: Format MISS not found or couldn't be loaded for variable First, I applied a format to the variables in my data set, then I do a proc freq to find missing vs non-missing values. The proc freq is outputting as expected, when I add the out= option, I do not get an error, but when I try and open the data set It fails to open. The log shows. ERROR: Format MISS not found or couldn't be loaded for variable .... And a message box reads "Unable to open the table, would you like to select another table to open. Here is my code. format; value $miss " "="missing" "nomissing"; run; format; miss .="missing" "nomissing"; run; proc contentsdata=Sandbox.&Basicnoprint out=Sandbox.Basic_name(keep=name format formatl); run; data Sandbox.Basic_Chars; set Sandbox.Basic_name; if format = "$"; run; data Sandbox.Basic_Nums; set Sandbox.Basic_name; if format = ""then format = "NUMERIC"; if format = "NUMERIC"; run; data Sandbox.Basic_Dates; set Sandbox.Basic_Name; if format = "DATETIME"; run; proc sql noprint; select trim(left(name)), count(*) into :basic_char_list separated by ' ', :nlist /*monitor the number of names in this list*/ from Sandbox.Basic_Chars; quit; proc sql noprint; select trim(left(name)), count(*) into :basic_num_list separated by ' ', :nlist /*monitor the number of names in this list*/ from Sandbox.Basic_Nums; quit; proc sql noprint; select trim(left(name)), count(*) into :basic_date_list separated by ' ', :nlist /*monitor the number of names inthis list*/ from Sandbox.Basic_Dates; quit; %put &basic_char_list.; %put &basic_num_list.; %put &basic_date_list.; proc freq data=Sandbox.&Basic; tables &basic_char_list. &basic_num_list. &basic_date_list. / missingout=sandbox.basic_freq; format &basic_char_list. $miss. &basic_num_list. &basic_date_list.miss.; run; I get no errors until I try and open the outputted data file, then it reads. ERROR: Format MISS not found or couldn't be loaded for variable transaction_entry_date. This was one of the variables formatted as datetime. Any ideas would be greatly appreciated. Thanks, David Bess
... View more