If that screenshot is the exact code you ran, there are several problems: You're missing some spaces between keywords and variable names (e.g. "IFSBP" and "90THENSBPHypCat"); that will never work. The range syntax is not quite correct. Try this instead:   data WORK.MISSISSIPPI_VS; input SSN: $11. VisitDate Height Weight SBP DBP; datalines; 000-00-0000 18504 65 153 111 72 000-00-0000 18861 65 158 109 75 000-00-0000 19236 65 151 115 74 000-00-0000 19606 65 154 107 79 000-00-0000 19978 65 153 110 74 ; run; data want; set mississippi_vs; format SBPHypCat $32.; if SBP = . then SBPHypCat = ' '; else if SBP lt 90 then SBPHypCat = 'Below Normal'; else if 90 le SBP lt 120 then SBPHypCat = 'Normal'; else if 120 le SBP lt 140 then SBPHypCat = 'High Normal'; else if 140 le SBP lt 160 then SBPHypCat = 'Stage 1 Hypertension'; else if 160 le SBP lt 180 then SBPHypCat = 'Stage 2 Hypertension'; else if 180 le SBP then SBPHypCat = 'Stage 3 Hypertension'; run;     ... View more

@helloSAS  Is this what you're looking for? data table1; infile datalines; input id dts_tab1 :datetime20.; format dts_tab1 datetime20.; datalines; 11111 03JAN2020:08:06:03 11111 05JAN2020:16:06:03 11111 07JAN2020:08:06:03 ; run; data table2; infile datalines; input id dts_tab2 :datetime20.; format dts_tab2 datetime20.; datalines; 11111 01JAN2020:08:06:03 11111 01JAN2020:08:06:03 11111 04JAN2020:08:06:03 11111 04JAN2020:08:06:03 11111 04JAN2020:08:06:03 11111 06JAN2020:08:06:03 11111 08JAN2020:08:06:03 11111 08JAN2020:08:06:03 ; run; data table2_nobs; set table2; n = _n_; run; proc sql; create table work.joined as select a.id ,a.n ,a.dts_tab2 format datetime20. ,b.dts_tab1 format datetime20. from table2_nobs a left join table1 b on a.id = b.id and a.dts_tab2 > b.dts_tab1 order by n, dts_tab1; quit; data work.want (drop=n); set joined; by n dts_tab1; if last.n; run; Result:   ... View more

@stancemcgraw  Since you already have the number of days in character strings, give this a try. data have; input hlos $31.; datalines; 2.293055555555555556 8.490277777777777 8.0291667 ; run; data want; set have; hlos_numeric = round(input(hlos, 12.4), 1); run; (Also, I believe your second example would round off to 8 days, not 9.) ... View more

Hi @hjjijkkl. I presume that is a column name you're working with?   If your column name has spaces in it, it looks like PROC PRINT will chose column width based on the longest value in the column. If your column header does not have spaces, PROC PRINT will chose column width based on the longest value or column header (so that nothing spills over into multiple lines).  Here are a couple examples that should help:   If your column name is lengthy and has spaces, it . Try using width=full.   data have1; input 'long column name with spaces'n $50.; datalines; test ; run; proc print data=have1; run; proc print data=have1 width=full; run; Output: Otherwise you could remove the spaces from your column names, and then you won't have this problem: data have2; input long_column_name_without_spaces $50.; datalines; test ; run; proc print data=have2; run; proc print data=have2 width=full; run; Output:     ... View more

Per the documentation, it looks like the ZIPCITYDISTANCE function works for recognized ZIP codes in the United States. Many of those you provided (or made up?) are not in the U.S.  The SASHELP.ZIPCODE dataset contains which ZIP codes are valid: proc contents data=sashelp.zipcode; run; So make sure those that you're using are valid.   Here is an example that works, using ZIPCITYDISTANCE(), for valid U.S. zip codes: data have; input HQ_ZIP AFF_ZIP; datalines; 10001 90001 98101 32789 ; run; data want; set have; distance = zipcitydistance(HQ_ZIP, AFF_ZIP); run; ... View more