Hello, I am putting together a project for Patient Centered Primary Care Homes (PCPCH).  So I import a lot of information from csv files using the usual Proc import coding. On the last import which is not huge at all (664 obs - but will serve as my "go to" file for subsequent coding) the first 279 obs are missing some crucial CCO organization (Coordinated Care Organization) information.  I did a lot of find / replace from a "master list" of CCO name, organization, practice_name ... and so on to fill in as many of the missing CCOs in the first 279 obs that I could.   After the import from csv to SAS I examined the data set and found that the file looks like the attached example (this is from excel not SAS but illustrates my problem). THe first little block of obs is what the data looks like in the csv file before import.  The second is how the data appears in the SAS data file after import. The shaded rows are rows with missing CCOs, the unshaded are complete obs, for our purposes.  As you can see only the first 'byte' of the both the numeric (CCO_TIN, Organization_TIN, Practice_TIN) and text str (CCO_unique_ID, Organization, Practice) show in the data set.  Recall, that the obs from 280 through 664 have/had all these column values populated; now rows 280 through 664 have only one  byte showing. When I do a 'View Columns' on the data set this is what is shown: Name                    Type                  Length     Format       Informat cco_unique_id       text                       4               4.                4. cco_tin                   numeric                8              10.             10. organization           text                     30              30.             30. organization_tin     numeric                8              10.             10. practice                  text                     63              65.             65. practice_tin            numeric                8                8.               8.   Your help in the past has always been right on the mark.  I can certainly use your expertise on this.   Thank you in advance.   Walt Lierman ... View more

I have a SAS output data set of drugs prescribed for a Medicaid population.   I have two issues: 1) setting up a if-then-else section to search for specific hiv/aids drugs by brand and/or generic. The following is the coding. The brand name is mentioned first and the generic is second. Another wrinkle is that there is one brand but (many times) several generics (or more like generic cocktail mix). (There are many lines so I am going to shorten the example. )   Data hivaids.hivaids_drugs (keep = DSC_NDC label);     set hal_data.mcaid_drug_dn;     If dsc_ndc eq "Emtriva" or "emtricitabine" then label eq "Yes";    Else If dsc_ndc eq "Delstrigo" or "doravirine" and "lamivudine" and    "tenofovir disoproxil fumarate" then label eq "Yes"; : : : Else If dsc_ndc eq "Kaletra" or "lopinavir" and "ritonavir" then label eq "Yes";   So the error I run into is INVALID numeric data, << drug name >> at line xxxx column xx   That error repeats many times.  All the drug names on the right hand side of the  OR are the generics and there can be from two to five. I separated each by AND. I received output which was basically just the column DSC_NDC in the SAS output set.  What I really want is to match the list of hiv/aids drugs against the SAS output set and then only keep those where label = "Yes".   That is the first problem.   Secondly in the SAS output set there may be several lines for the same drug depending upon how the drug is administered. For example,        Oncovin             Vial        Oncovin              Syringe       Oncovin               Syringe   I just want to identify the name once - but I get every line for each drug by mode of delivery as listed in the SAS dataset.   So the second problem is just having the name of any drug match listed only once.   Thank you for you assistance on this. Walt Lierman ... View more

I have nine diagnosis code attributes (columns) labeled Diag1, Diag2,  ..... , Diag9   I have several icd-10 dx_codes that I need to check across 3 years of Medicaid recipient claims   Here is the c ode starting after the FROM clause   WHERE Month Between '201701' And '201912'     And ClaimType Not In ('D')     And  Diag1 - Diag9 In ('B20', 'B9735', ........., '09873') ORDER By Recipno, Month; quit;   The problem occurs at Diag1- Diag9  with the error reading: Expression using negation (-) requires numeric types   I have tried several variants of the Diag1-DIag9 construct but none have solved the issue. I appreciate your help again.   Walt Lierman ... View more

I have written the following short query   proc sql noprint; CREATE table aqc_puds.data_count_claim AS SELECT               claimtypedesc,               claimtype,               Count(claim) FROM aqc_puds.base_yr_pudset GROUP BY claimtypedesc; quit;   Desired output data (hypothetical numbers): Claimtypedesc           count dental                         1534236 inpatient                   22342522   professional             44999900             ....... and so on ...... there should be about 10 rows - one for every claimtype - with claims counted over each claimtype   actual output data Claimtypedesc              count dental                            15151016 dental                            15151016    .                                       .    .                                       .    .                                       .   and so on for each dental claim   So the dilemma is to obtain the first hypothetical table rather than the erroneous actual table.   This is likely a pretty straightforward solution.  However, I haven't been able to crack the code and so your expertise is very appreciated.   Walt Lierman    ... View more