SAS Support Communities

Nope, Plz check the result and the LOG. ... View more

Do not saddle yourself with those stupid name literals. Labels are made for pretty strings, so use them, but keep variable names simple for easier coding. ... View more

So using the following code to check if your dataset include this variable: proc contents data=mysas.MyData varnum; run; ... View more

%let current_datetime = %sysfunc(datetime(), mdyampm.); title1 "First Name & Last Name"; title2 "Date and Time: &current_datetime"; proc print data=sashelp.class; run;   ... View more

Your PROC FORMAT is NOT right.   data docvisits; input patientID $ weekday :$20. score; cards; 101 Friday 15 163 Wednesday 11 104 Friday 23 163 Thursday 13 123 Tuesday 10 104 Monday 20 157 Friday 21 101 Monday 10 112 Tuesday 11 157 Tuesday 10 123 Monday 9 123 Friday 9 101 Tuesday 11 112 Monday 9 157 Thursday 18 174 Monday 12 ; proc format; invalue weekdayfmt 'Monday' = 1 'Tuesday' = 2 'Wednesday' = 3 'Thursday' = 4 'Friday' = 5; run; data docvisits_sorted; set docvisits; daynum = input(weekday, weekdayfmt.); run; proc sql nowarn; select distinct weekday, count(distinct patientID) as Total_Patients from docvisits_sorted group by weekday order by daynum; quit; ... View more

Ohp, I got it. Disregard! ... View more

Another approach using ABS function. If we need to read only observations where change is greater than or equals 10 then  where statement is more efficient in terms of system processing.  data want; set have; where abs(starting_weight - end_weight) ge 10; run; ... View more

I wrote a PROC FREQ is just to make a sample data since you did not post a data. You can delete PROC FREQ and use your original dataset to PROC PRINT. " but the report wasn't quite in a format like " What do you mean by that ? you can format your report as your wish/code : options nodate nonumber papersize=(21cm 38cm) ; ods pdf file = "c:\temp\temp.pdf" style=journal ; proc print data = StateDataSet NOOBS label ; format Area Comma7.0 Population Comma10.0; title ; label State_Name = 'State Name'; label State_Abbrev = 'State Abbrev.'; label Postal_Abbrev = 'Postal Abbrev.'; label Area = 'Area (Sq Mi)'; run; ods pdf close; ... View more

Count the columns.  You can use the LIST statement to have SAS print it out for you to the SAS log. RULE: ----+----1----+----2----+----3----+----4----+----5- 1 2022/01/10 14:54:28.81 0.36 33.512 -116.768 43 2 2022/01/10 15:16:32.60 0.96 33.184 -116.031 43 3 2022/01/10 15:43:09.41 1.09 35.680 -117.535 43 4 2022/01/10 16:33:07.48 0.68 33.588 -116.808 43 5 2022/01/10 17:14:17.90 0.86 36.032 -117.807 43 6 2022/01/10 18:00:07.32 0.61 35.765 -117.580 43 7 2022/01/10 18:50:47.06 0.90 35.586 -117.462 43 8 2022/01/10 18:59:47.00 2.61 35.648 -115.927 43 NOTE: 8 records were read from the infile HAVE. The minimum record length was 43. The maximum record length was 43. You asked the INPUT statement to read the first two variables using FORMATTED MODE and the other three variables using LIST MODE.  So it read DATE from columns 1 to 10. Then TIME from columns 11 to 21 leaving the pointer at column 22.  So for MAGNITUDE it read the last digit of the TIME value.  And you never read in the last value on the line.   So either adjust the width of the TIME informat to account for the leading and trailing space. input Date yymmdd10. Time time13. Magnitude Latitude Longitude; Or if the values are not in fixed column locations, but every field has a value on every line (with single periods used to mark the missing values) then just use LIST MODE for all of the fields instead of just the last three.  You could use an INFORMAT statement to attach the desired informats to DATE and TIME. data have; infile have truncover; input Date Time Magnitude Latitude Longitude; informat date yymmdd. time time.; format date yymmdd10. time timeampm14.2; run; Or instead if you want to specify the informat in-line in the INPUT statement then make sure to use the colon modifier so that the INPUT statement still uses LIST MODE instead of switching to FORMATTED MODE for those variables. input Date :yymmdd. Time :time. Magnitude Latitude Longitude; Remember that in LIST MODE input the width attached to the informat specification is ignored.  Instead the whole next field on the line is read, however many bytes it takes.  So no need to specify any width at all.   To display 8 character time values with a decimal point and two places to the right of the decimal point and a space and two letter suffix will requried using the format specification timeampm14.2.   ... View more

data pizza_likes; input ID $ A $ B $; datalines; 21 Yes No 22 No No 23 Yes Yes 24 No Yes 25 Yes Yes 26 Yes No 27 No Yes ; run;   proc freq data=pizza_likes; tables A*B / nocol nopercent norow; run;   proc sql; select sum(A='Yes') as Likes_A, sum(B='Yes') as Likes_B, sum(A='Yes' and B='No') as Likes_Only_A, sum(A='No' and B='Yes') as Likes_Only_B, sum(A='Yes' and B='Yes') as Likes_Both, sum(A='No' and B='No') as Likes_Neither, sum(A='Yes' or B='Yes') as Likes_Either from pizza_likes; quit; ... View more

@unwashedhelimix wrote: Thanks for the reply! I just saw it after revising my question a bit. I appreciate the guidance on the conversion, but I thought it would be a better report if the missing cells (not the entire row) were deleted. I do not know what you mean by that comment.   There is no need to delete observations (or values).  Can you explain what you meant more clearly?     If you have data as you posted (with numeric variables) SAS will handle it properly.  data have; input Age Points Assists Rebounds Steals; cards; 21 12.1 7.2 7.4 1.2 26 20.3 7.2 . 1.2 21 10 . 7.4 . 19 8.4 10.1 . 2.3 ; For example the mean values will be calculated using only the non-missing values.  The MEANS Procedure Variable N Mean Std Dev Minimum Maximum ----------------------------------------------------------------------------- Age 4 21.7500000 2.9860788 19.0000000 26.0000000 Points 4 12.7000000 5.2883520 8.4000000 20.3000000 Assists 3 8.1666667 1.6743158 7.2000000 10.1000000 Rebounds 2 7.4000000 0 7.4000000 7.4000000 Steals 3 1.5666667 0.6350853 1.2000000 2.3000000 -----------------------------------------------------------------------------   ... View more