Hello, I cleaned a data set and at the end of the cleaning, I saved the clean SAS data set, as permanent data. Because during my data cleaning I created some format values (using PROC FORMAT; ), now I must read the format file before reading the permanent SAS file. otherwise, For each missing format, I get an error and the following warning ERROR: The format VARIBLE_1 was not found or could not be loaded. NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.temp_clean_SAS_data may be incomplete.  When this step was stopped there were 0 observations and 42 variables. What is an efficient way to save and access the clean data set at the end of the data cleaning process?   Thanks   *saving the clean data set; libname clean "&path"; data clean.permanent_clean_SAS_data; set temp_clean_SAS_data; run;   *reading the permanent clean data set; libname import "&path"; data temp _data; set import.permanent _clean_SAS_data; run;   ... View more

I read a .xlsx data in SAS using proc import:   options validvarname=v7;  proc import datafile="&proj_loc\my_data.xlsx" dbms=xlsx replace out=SAS_data; run;   One of my numeric columns with 2 decimal places in the Excel file is read as a character variable in SAS. I switched that to numeric using varnum=input(var​char, best14.);   The problem is some values are read with exponential format during the proc import and the best14. does not fix them. For example, a 0.07 is imported as 7.0000000000000007E-2 and in the var_num it is read as only 7.   I appreciate it if you have any suggestions to fix this.   Thanks ... View more

Hello, I want to create a column (column_3) based on two other columns (column_1 and column_2). if both column_1 and column_2 have a value then column_3 is the average of column_1 and column_2 If the values for either column_1 or column_2 are missing (only one of them has a value) then column_3 is set equal to the non-missing value. I know my code is wrong, but something like this data want; set have; column_3=.; if column_1 eq '.' and column_2>0 then column_3=column_2; if column_2 eq '.' and column_1 >0 then column_3=column_1; else if column_1>0 and column_2>0 then column_3 = (column_1+column_2)/2; run;   Thanks ... View more

I have a sas_data that I would like to read in one excel file (description) with two sheets created by two procedures.  In the first procedure, I want to read all columns (*) and rows with specific ID values, using proc sql. In the second procedure, I want to read all rows and specific columns, using proc print.   My SAS output looks good but the excel file created by my code is empty.   My excel file is not open. The error message is below. I checked my c drive but "AppData" folder does not exist and no file there created today (all dates are older than today). WARNING: An error occurred while deleting the temporary package files in C:\Users\wxyz\AppData\Local\Temp\SAS Temporary Files\_TD9272_SPHHS82-01_\_T000000004CA0D1C0. Do you have any suggestions to fix my code?   Thanks!    ODS EXCEL FILE="C:\path\description.xlsx" options(embedded_titles='on' embedded_footnotes='on' sheet_interval = 'proc'); libname sql 'SAS-library'; proc sql; title1 'checking specific rows'; select * from sas_data where PID like '331047145%' or ID like '536%' or ID like '588%' or ID like 'EP%'; quit; run; proc print data=sas_data; var PID uniquerespid uniqueidforeachrespondent record; run; ods excel close; ... View more