data cat;      set sashelp.class;      if weight >= 60 then wcat = ">=60";      else if not missing(weight) and weight < 60 then wcat = "<60"; run; proc sgplot data=cat;     vbar wcat / response=height; run; ... View more

You would need to convert variable phone to numeric type first: phone_num = input(phone, 8.); ... View more

This will work if instead of formatting existing variable you create a new categorical variable with values "<60" and ">=60". ... View more

Please have a look at this post: https://blogs.sas.com/content/iml/2017/02/22/difference-of-medians-sas.html ... View more

Before getting into PROC SUMMARY or REPORT to beautify a table (step 2), or outputting it to xcel (step 3), try making a crude table of the results containing just the values that you need (step 1). To do that, you would need to combine SAS output tables from PROC FREQ and UNIVAR. Both procedures have several OUTPUT options, as statements ("OUTPUT ...;") or options after another statement ("/ OUTPUT ...;"). Try experimenting with that seeing which outputs contain useful values. If those tables are not enough, you may try preceding the procedures by "ODS TRACE ON;". That will list all the names of all the output tables in the log. After you see the list, you can save any of those tables under any name you like using "ODS OUTPUT listed_table_name_from_the_log=any_name_you_like;". More information is found here: https://blogs.sas.com/content/iml/2017/01/09/ods-output-any-statistic.html ... View more

Proc sql; select id, sub_id, min(date) as earliest_date from have where date ne . group by id having date = min(date) ; quit; ... View more

proc sql; CREATE TABLE data AS SELECT a.*, b.Type, b.ID FROM A inner join B ON a.npi=b.provnpi WHERE Type in (select TIN from a) /* not sure a or b */ and b.ID in ('111111111' '222222222' '333333333' '66666666' '77777777') ; quit; ... View more

I see. You can transpose by name. That will make rows with concatenated values into columns. After that, you can concatenate the resulting columns. ... View more

Before concatenating, replace the commas within the columns with something else (e.g., letter “x”). There is a REPLACE function for that. Then replace “x” back to a comma in the want dataset. ... View more

It is possible to apply format to a variable list. Here is an example: https://communities.sas.com/t5/SAS-Programming/Assigning-SAS-formats-to-a-list-of-variables/m-p/114336 ... View more

Please check out a similar post here: https://communities.sas.com/t5/SAS-Programming/Adding-leading-Zeros-to-Numeric-Variable/td-p/90932/page/2 ... View more

The pseudo code is this: 1) make a one-variable data set with variable YEAR containing all consecutive years just once per year 2) left join it to your dataset by year (this will create gaps in ID and NUMBER for the added observations) 3) use Last Observation Carry Forward (LOCF) on ID to fill in the gaps 4) if NUMBER is missing set it to zero. ... View more

Could you please double check with the client that they really need a numeric variable, not just a character variable with a length of 20? ... View more

Are you sure there was no mixed values there that got converted to missing? For example, if someone entered age “5A”, but then that is probably a good thing unless you wish to clean it to something like 5 if you are completely certain that the age is 5. I think both methods, implicit and explicit, would convert age “5A” to missing numeric age. ... View more

You would need to load critter and type into a hash and use that as a reference (i.e., look-up table). Here is an example: https://support.sas.com/kb/47/224.html#:~:text=Load%20a%20SAS%20data%20set%20into%20a%20Hash,step%20to%20look%20up%20values%20in%20a%20table. ... View more