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