thanks  here are my codes data MYK007_20241105_final ; retain age gender study_id subject_id visit_name Date_study htm wtm BMI BSA sbp dbp hr contrast_given contrast_agent Field_strength gad_vol time_inj Hct date_hct Lv_mass Lv_massi lvedv lvedvi lvesv lvesvi lvsv lvsvi lvef co ci Lge1_4SD Lge2_4SD Lge3_4SD Lge4_4SD Lge5_4SD Lge6_4SD Lge7_4SD Lge8_4SD Lge9_4SD Lge10_4SD Lge11_4SD Lge12_4SD Lge13_4SD Lge14_4SD Lge15_4SD Lge16_4SD Lge_mass_4SD Lge_pct_4SD Lge1_5SD Lge2_5SD Lge3_5SD Lge4_5SD Lge5_5SD Lge6_5SD Lge7_5SD Lge8_5SD Lge9_5SD Lge10_5SD Lge11_5SD Lge12_5SD Lge13_5SD Lge14_5SD Lge15_5SD Lge16_5SD Lge_mass_5SD Lge_pct_5SD Lge1_6SD Lge2_6SD Lge3_6SD Lge4_6SD Lge5_6SD Lge6_6SD Lge7_6SD Lge8_6SD Lge9_6SD Lge10_6SD Lge11_6SD Lge12_6SD Lge13_6SD Lge14_6SD Lge15_6SD Lge16_6SD Lge_mass_6SD Lge_pct_6SD wt1 wt2 wt3 wt4 wt5 wt6 wt7 wt8 wt9 wt10 wt11 wt12 wt13 wt14 wt15 wt16 wt_max wt1_max wt2_max wt3_max wt4_max wt5_max wt6_max wt7_max wt8_max wt9_max wt10_max wt11_max wt12_max wt13_max wt14_max wt15_max wt16_max T1pre1 T1pre2 T1pre3 T1pre4 T1pre5 T1pre6 T1pre7 T1pre8 T1pre9 T1pre10 T1pre11 T1pre12 T1pre13 T1pre14 T1pre15 T1pre16 ECVF1 ECVF2 ECVF3 ECVF4 ECVF5 ECVF6 ECVF7 ECVF8 ECVF9 ECVF10 ECVF11 ECVF12 ECVF13 ECVF14 ECVF15 ECVF16 ECVF_global Tau1 Tau2 Tau3 Tau4 Tau5 Tau6 Tau7 Tau8 Tau9 Tau10 Tau11 Tau12 Tau13 Tau14 Tau15 Tau16 Tau_global Rv_mass Rv_massi rvedv rvedvi rvesv rvesvi rvsv rvsvi rvef length4cham_sys length4cham_pre length4cham_post length3cham_sys length3cham_pre length3cham_post length2cham_sys length2cham_pre length2cham_post width4cham_sys width4cham_pre width4cham_post width3cham_sys width3cham_pre width3cham_post width2cham_sys width2cham_pre width2cham_post area4cham_sys area4cham_pre area4cham_post area3cham_sys area3cham_pre area3cham_post area2cham_sys area2cham_pre area2cham_post special_note reservoiramt contractileamt totalamt reservoirpct contractilepct totalpct lav_max lav_min lav_maxi lav_mini lav_max_ht lav_min_ht lvesv_ht lvedv_ht lvsv_ht co_ht lv_mass_ht mcf ec_mass ec_massi ec_mass_ht ECVFi ECVF_ht mcf2 lvrv_mass lvrv_massi lvrv_mass_ht ; set MYK007_20241105_b ; run; proc sort data=myk007_20241105_Final; by subject_id visit_name; run; proc means n nmiss mean min max data=MYK007_20241105_final; var _numeric_; run; the proc means will run but then it will lock up and showed this message and the only way out is to shut down SAS The output window does not allow entry of any of BOTTOM, Forward or End Just wondering if there is something wrong with the SAS installation as this is a newly installed laptop.  The same code ran on a different computer (with data files stored in similar paths) had no such issue. thanks   ... View more

I have the dataset with these variables patient_id pt_name lab_date,         lab_type result normal_range visit_description HD date_HD 01234        Smith, J   2023-10-23    gfr            30       60-100             chest pain 1            0       . 01234        Smith, J   2024-02-23   gfr            20       60-100             dyspnea                 0       . 01234        Smith, J   2024-10-21    gfr            10        60-100             asymptomatic       1      2023_10_30 01234        Smith, J   2023-07-23    trop        0.06     <0.010             chest pain 5              0       . 01234        Smith, J   2024-01-20    trop           0.08      <0.010             dyspnea                 0       . 01226       wong, J   2023-04-23    gfr        15     <0.010             chest pain 4              1      2023_04_30 01226        wong, J   2024-2-20    trop           0.08      <0.010             dyspnea                 0       . the dataset has several millions lines from several thousand pts would like to organize the data so that each line represents the range of a lab type in a given month with range and mean values such as this; patient_id patient_name lab_month lab_type low high mean max date_max          normal_range visit_des                                     HD date date_hd 01234        Smith, J              Oct2023    gfr           10    30     20       30    2023_10-23    60-100             chest pain 1, asymptomatic    1             2023-10-30   I have tried proc SQL but could not achieve all the results  many thansk for your help! ... View more

yes, my mistake writing monyy7 and missed the dot generated the problem. Thanks so much for pointing this to me ... View more

so helpful! the MONYY7 was supposed to be monyy7. to format the date variable. many thanks ! ... View more

this works!  thanks so much I should not have assume =1 because the text did not always start on the first position. very much appreciated ... View more

one more question.  This is in the log and it seems the only field that was not read correctly is the date.  All values in "date" were missing as a result.  Thanks      99 data procedure; 100 infile "C:\Users\rk64\Desktop\cardreport_diag_procedure\RK64_20240207_103523_Prc.txt" 101 dsd dlm='|' truncover firstobs=2 102 ; 103 length EMPI $20 EPIC_PMRN $20 MRN_Type $10 MRN $15 Date 8 104 Procedure_Name $40 Code_Type $10 Code $10 105 Procedure_Flag $8 Quantity 8 106 Provider $20 Clinic $20 Hospital $20 107 Inpatient_Outpatient $10 Encounter_number 8 108 ; 109 input EMPI -- Encounter_number; 110 informat date date.; 111 format date date9.; 112 run; NOTE: The infile "C:\Users\rk64\Desktop\cardreport_diag_procedure\RK64_20240207_103523_Prc.txt" is: Filename=C:\Users\rk64\Desktop\cardreport_diag_procedure\RK64_20240207_103523_Prc.txt, RECFM=V,LRECL=32767, File Size (bytes)=2464662277, Last Modified=07Feb2024:20:10:47, Create Time=12Oct2024:20:35:49 NOTE: Invalid data for Date in line 2 36-45. NOTE: Invalid data for Encounter_number in line 2 184-207. ... View more

thanks   do you mind sharing an example how to use Data step to read in a large txt file?  The txt file is extremely large with thousands of columns of variables so I do not know how to use infile statement to define the large number of variables.   thanks   ... View more

thanks   The txt file I am trying to read into SAS is stored in a dropbox folder in a local C drive.  The SAS is also a desktop version not an online network version.  I am not using SAS enterprise.  I hope I answered your question correctly   ... View more

yes, sorry for not including in the last message:  here is the error message prior.  I removed some of the error message that contain PHI   14709 proc import 14710 datafile="C:\Users\rk64\Desktop\cardreport_diag_procedure\RK64_20240207_103523_Prc.txt" 14711 dbms=dlm 14712 out=work.procedure 14713 replace; 14714 getnames=YES; 14715 14716 run; Number of names found is less than number of variables found. Name EMPI|EPIC_PMRN|MRN_Type|MRN|Date|Procedure_Name|Code_Type|Code|Procedure_Flag|Quantity|Provider|Clinic |Hospital|Inpatient_Outpatient|Encounter_number truncated to EMPI_EPIC_PMRN_MRN_Type_MRN_Date. Problems were detected with provided names. See LOG. 14717 /********************************************************************** 14718 * PRODUCT: SAS 14719 * VERSION: 9.4 14720 * CREATOR: External File Interface 14721 * DATE: 11OCT24 14722 * DESC: Generated SAS Datastep Code 14723 * TEMPLATE SOURCE: (None Specified.) 14724 ***********************************************************************/ 14725 data WORK.PROCEDURE ; 14726 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */ 14727 infile 'C:\Users\rk64\Desktop\cardreport_diag_procedure\RK64_20240207_103523_Prc.txt' 14727! delimiter = ' ' MISSOVER DSD lrecl=32767 firstobs=2 ; 14728 informat EMPI_EPIC_PMRN_MRN_Type_MRN_Date $61. ; 14729 informat VAR2 $20. ; 14730 informat VAR3 $12. ; 14731 informat VAR4 $18. ; 14732 informat VAR5 $10. ; 14733 informat VAR6 $33. ; 14734 informat VAR7 $31. ; 14735 informat VAR8 $31. ; 14736 informat VAR9 $15. ; 14737 informat VAR10 $11. ; 14738 informat VAR11 $34. ; 14739 informat VAR12 $16. ; 14740 informat VAR13 $51. ; 14741 informat VAR14 $51. ; 14742 informat VAR15 $35. ; 14743 informat VAR16 $51. ; 14744 informat VAR17 $8. ; 14745 informat VAR18 $9. ; 14746 informat VAR19 $51. ; 14747 informat VAR20 $51. ; 14748 informat VAR21 $38. ; 14749 informat VAR22 $51. ; 14750 informat VAR23 $9. ; 14751 informat VAR24 $51. ; 14752 informat VAR25 $51. ; 14753 informat VAR26 $7. ; 14754 informat VAR27 $51. ; 14755 informat VAR28 $11. ; 14756 informat VAR29 $32. ; 14757 informat VAR30 $17. ; 14758 informat VAR31 $38. ; 14759 informat VAR32 $33. ; 14760 informat VAR33 $42. ; 14761 informat VAR34 $43. ; 14762 informat VAR35 $38. ; 14763 informat VAR36 $8. ; 14764 informat VAR37 $2. ; 14765 informat VAR38 best32. ; 14766 informat VAR39 $39. ; 14767 format EMPI_EPIC_PMRN_MRN_Type_MRN_Date $61. ; 14768 format VAR2 $20. ; 14769 format VAR3 $12. ; 14770 format VAR4 $18. ; 14771 format VAR5 $10. ; 14772 format VAR6 $33. ; 14773 format VAR7 $31. ; 14774 format VAR8 $31. ; 14775 format VAR9 $15. ; 14776 format VAR10 $11. ; 14777 format VAR11 $34. ; 14778 format VAR12 $16. ; 14779 format VAR13 $51. ; 14780 format VAR14 $51. ; 14781 format VAR15 $35. ; 14782 format VAR16 $51. ; 14783 format VAR17 $8. ; 14784 format VAR18 $9. ; 14785 format VAR19 $51. ; 14786 format VAR20 $51. ; 14787 format VAR21 $38. ; 14788 format VAR22 $51. ; 14789 format VAR23 $9. ; 14790 format VAR24 $51. ; 14791 format VAR25 $51. ; 14792 format VAR26 $7. ; 14793 format VAR27 $51. ; 14794 format VAR28 $11. ; 14795 format VAR29 $32. ; 14796 format VAR30 $17. ; 14797 format VAR31 $38. ; 14798 format VAR32 $33. ; 14799 format VAR33 $42. ; 14800 format VAR34 $43. ; 14801 format VAR35 $38. ; 14802 format VAR36 $8. ; 14803 format VAR37 $2. ; 14804 format VAR38 best12. ; 14805 format VAR39 $39. ; 14806 input 14807 EMPI_EPIC_PMRN_MRN_Type_MRN_Date $ 14808 VAR2 $ 14809 VAR3 $ 14810 VAR4 $ 14811 VAR5 $ 14812 VAR6 $ 14813 VAR7 $ 14814 VAR8 $ 14815 VAR9 $ 14816 VAR10 $ 14817 VAR11 $ 14818 VAR12 $ 14819 VAR13 $ 14820 VAR14 $ 14821 VAR15 $ 14822 VAR16 $ 14823 VAR17 $ 14824 VAR18 $ 14825 VAR19 $ 14826 VAR20 $ 14827 VAR21 $ 14828 VAR22 $ 14829 VAR23 $ 14830 VAR24 $ 14831 VAR25 $ 14832 VAR26 $ 14833 VAR27 $ 14834 VAR28 $ 14835 VAR29 $ 14836 VAR30 $ 14837 VAR31 $ 14838 VAR32 $ 14839 VAR33 $ 14840 VAR34 $ 14841 VAR35 $ 14842 VAR36 $ 14843 VAR37 $ 14844 VAR38 14845 VAR39 $ 14846 ; 14847 if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */ 14848 run; NOTE: The infile 'C:\Users\rk64\Desktop\cardreport_diag_procedure\RK64_20240207_103523_Prc.txt' is: Filename=C:\Users\rk64\Desktop\cardreport_diag_procedure\RK64_20240207_103523_Prc.txt, RECFM=V,LRECL=32767, File Size (bytes)=2464662277, Last Modified=07Feb2024:20:10:47, Create Time=12Oct2024:20:35:49 NOTE: Invalid data for VAR38 in line 33 338-340. .......   NOTE: 8293654 records were read from the infile 'C:\Users\rk64\Desktop\cardreport_diag_procedure\RK64_20240207_103523_Prc.txt'. The minimum record length was 109. The maximum record length was 1311. NOTE: The data set WORK.PROCEDURE has 8293654 observations and 39 variables. NOTE: DATA statement used (Total process time): real time 37.36 seconds cpu time 8.15 seconds Errors detected in submitted DATA step. Examine log. 8293654 rows created in WORK.PROCEDURE from C:\Users\rk64\Desktop\cardreport_diag_procedure\RK64_20240207_103523_Prc.txt.   There were many "invalid data for var 38.... ... View more

many thanks for the great suggestion I will try this     ... View more