Hi everyone, I recently received a series of permanent SAS datasets along with saved formats for the data (formats were saved in a folder named as formats64). However, I have not been able to view the contents of the datasets because of the error message shown below whenever I run a proc print statement:   “ERROR: Format $RACEFMT not found or couldn't be loaded for variable RACE. ERROR: Format $SEXFMT not found or couldn't be loaded for variable SEX. ERROR: Format $CDTYPEI not found or couldn't be loaded for variable CDTYPE. ERROR: Format $PD96DET not found or couldn't be loaded for variable PDIS. ERROR: Format $YNUFMT not found or couldn't be loaded for variable HISPANIC. ERROR: Format $RXSTOP not found or couldn't be loaded for variable RXSTOP. NOTE: The SAS System stopped processing this step because of errors".   I applied the following libname codes before the proc print statement: LIBNAME CORE 'C:\Users\CORE'; LIBNAME LIBRARY 'C:\Users\CORE'; options fmtsearch= (formats64 CORE LIBRARY);   The proc print statement was: proc print data=CORE.patients; run;   I was hoping someone could help me troubleshoot the coding steps such that the problem with the Format and how it can be applied to the dataset will be resolved. Thanking you in advance for your help. Best, Ayo ... View more

Hello, I found a paper online which described a code for matching cases and controls in SAS (https://doi.org/10.3389/fdata.2019.00004). The code runs when applied to my dataset. However, I was hoping to seek input on how to modify the code such that a complete dataset of matched controls and cases can be exported separately into excel sheet for visualization. I have shown the code which I applied to my dataset below. Thanking you in advance for your guidance!    PROCIMPORT OUT= WORK.case              DATAFILE= "C:\Case.csv"              DBMS=CSV REPLACE;        GETNAMES=YES;        DATAROW=2;  RUN;     PROCIMPORT OUT= WORK.control              DATAFILE= "C:\Control.csv"              DBMS=CSV REPLACE;        GETNAMES=YES;        DATAROW=2;  RUN;     data sort_case; set case;  procsort; by PAT_MRN;run;  data sort_control; set control;  procsort; by PAT_MRN;run;     data population;  merge sort_case sort_control;  by PAT_MRN;  run;        %LET agerange = 5;  %LET ratio = 3;  DATA cases controls;     SET population;     IF casecontrol = 1 THENOUTPUT cases;     ELSEOUTPUT controls;  RUN;     PROCFREQ NOPRINTDATA=cases;     TABLES age*gender/OUT=caseout;  RUN;     %MACRO sample(v_age, v_gender, v_count);        DATA qualify1;        SET controls;        WHERE (&v_age-&agerange <= age <= &v_age+&agerange)        AND        (gender = "&v_gender");        case_age = &v_age;     case_gender = "&v_gender";         SEED = RANUNI(0);     PROC SORT;        BY SEED;        DATA qualify2;        SET qualify1 NOBS=totobs;        IF _N_ <= &v_count*&ratio;        IF &v_count*&ratio <= totobs THEN tag = 'yes';       ELSE tag = 'no';        PROC APPEND BASE=matches DATA=qualify2 force;        PROC SORT DATA=qualify2 OUT=temp1 (KEEP=PAT_MRN);        BY PAT_MRN;        PROC SORT DATA=controls OUT=temp2;        BY PAT_MRN;        DATA controls;         MERGE temp1(IN=in1) temp2(IN=in2);        BY PAT_MRN;        IF in2 AND NOT in1;     %MEND sample;     DATA_NULL_;      SET caseout;     CALL EXECUTE ('%sample('||age||','||gender||','||count||')');  RUN;  Proc print; run;        PROCFREQ NOPRINTDATA=matches;     TABLES case_age*case_gender/OUT=con_out;     PROCSORT DATA = caseout(RENAME=                    (age=case_age gender=case_gender count=case_cnt));     BY case_age case_gender;     PROCSORT DATA = con_out (RENAME= (count=con_cnt));     BY case_age case_gender;     DATA final (DROP=percent);     MERGE caseout con_out;     BY case_age case_gender;     con_need = case_cnt*&ratio;  IF con_cnt = . THEN con_cnt = 0;  diff = con_cnt-con_need;  Procprint;run;     PROCPRINT DATA = final;      WHERE diff < 0;     *TITLE 'Insufficient Matches';  RUN;  ... View more

Hi everyone, I am in need of some help. I am very new here and would appreciate all assistance. I have a dataset with 9000 rows but only the first column contains the data for each row. The data in each row has 27 variables which are separated by semicolon (some have 3 semicolons back to back). I am interested in splitting the data into different columns for each row so I can have each variable in a column. Could anyone please suggest a SAS code that I can adapt to the data in order to separate out the row data into separate columns? Thanks everyone for your help. Best, Ay. ... View more