Hello everyone,
I have a requirement where I need to create.
300 occurrences of the following fields. Each set of occurrences is 77 characters long (23100 characters total).
Note the first VALID 300 immunizations administered (by dose date) for the matching client will be included. If the client has more than 300 immunizations the remaining immunizations will not be extracted and no error message will be given
Note the immunizations will be sorted in order by vaccine group, then dose date | |||
NCIR Vaccine Type | Char(40) |
| Vaccine Names used within the NCIR database |
Dose Date | Date(10) | dd/mm/yyyy | Date vaccine dose was given |
CVX code | Char(12) |
| The CVX code equivalent to the NCIR Vaccine Type. CVX codes are part of the HL-7 standard for interchange of information between immunization registries. The CVX code is the code associated with the vaccine administered ( Vaccine table) |
I developed the code but I am not sure how do we used Array function to create 300 occurrences.
Data Immunization_13YearsOld;
infile "/sas/RA/ABC.DAT";
input Clients_LName $1-35 Clients_Fname $36-60 Clients_DOB $61-70 Client_Gender $71
Clients_MedicaiID $72-91 For_Future_Use $92-100 Match_Number $101-102
NCIR_Client_Last_Name $103-137 NCIR_Client_First_Name $138-162
NCIR_Client_Date_of_Birth $163-172 NCIR_Client_Gender $173 NCIR_Client_Medicaid_Id $174-193
NCIR_Vaccine_Type $194-233 Dose_Date $234-243 CVX_CODE $244-255 CPT_CODE $256-267 Dose_Number $268-270;
If you guys guide me that would be great.
The issue is resolved.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.