Hi @k26_23 , this is your data set A. I have not figure out the solution for your request, also I do not quiet understand the intention of your request, i.e., what kind of dataset you would like to create, and what's for?   It looks to me like you are working on a dataset that has link ID to other datasets. But what's the sort-order column for? Looking from your dataset A, this column is character (if it is numeric the '01' to '06' would be displayed like '1' to '6', without the leading 0), so what's this column for (I converted this column to numeric, incase it is needed as an order variable)?   And it looks to me like, by the sort-order column you created a number for each Parameter column value, if so why not just order your data according to the Parameter column? Are you prompting some convoluted question and a false request that confused yourself? I tried some sql step but did not get the dataset you request. I'll post it here also. data tumor1; input Subject $1-7 Site 9-11 ID $13-17 Description $32. Parameter $51-61 ParamDesc $43. sortorder $12.; sortordernum=input(sortorder,8.); datalines; 101-276 101 NTLDAT Date of Assessment 01 101-276 101 NTL01 CARCINOMATOSIS:CARCINOMATOSIS NTLSTAT Status 02 101-276 101 NTL02 LIVER:LIVER LESIONS NTLSTAT Statu 02 101-276 101 TLDAT Date of Assessment 03 101-276 101 TL01 ABDOMEN:RUQ OMENTAL MET TLMEAS_C Measurement 04 101-276 101 TL02 ABDOMEN:LEFT ABDOMEN OMENTAL MET TLMEAS_C Measurement 04 101-276 101 TL03 LIVER:LEFT LIVER DOME TLMEAS_C Measurement 04 101-276 101 TL04 LIVER:RIGHT LIVER DONE TLMEAS_C Measurement 04 101-276 101 TL01 ABDOMEN:RUQ OMENTAL MET TLYN1 Was lesion assessed at this visit 05 101-276 101 TL02 ABDOMEN:LEFT ABDOMEN OMENTAL MET TLYN1 Was lesion assessed at this visit 05 101-276 101 TL03 LIVER:LEFT LIVER DOME TLYN1 Was lesion assessed at this visit 05 101-276 101 TL04 LIVER:RIGHT LIVER DONE TLYN1 Was lesion assessed at this visit 05 101-276 101 TL01 ABDOMEN:RUQ OMENTAL MET TLYN2 Check if lesion is too small to measure 06 101-276 101 TL02 ABDOMEN:LEFT ABDOMEN OMENTAL MET TLYN2 Check if lesion is too small to measure 06 101-276 101 TL03 LIVER:LEFT LIVER DOME TLYN2 Check if lesion is too small to measure 06 101-276 101 TL04 LIVER:RIGHT LIVER DONE TLYN2 Check if lesion is too small to measure 06 101-276 101 TLSUM_C Sum of Diameters 07 101-276 101 NLDAT Date of Assessment 08 101-276 101 NL01 LIVER:RIGHT LOBE LIVER LESION NLSTAT Status 09 101-276 101 NL02 LIVER:LIVER LESIONS NLSTAT Status 09 101-276 101 NL01 LIVER:RIGHT LOBE LIVER LESION NLMEAS Measurement 10 101-276 101 NL02 LIVER:LIVER LESIONS NLMEAS Measurement 10 101-276 101 RSDAT Date of Assessment 11 101-276 101 RSORRES1 RECIST 1.1 Target Response 12 101-276 101 RSORRES2 RECIST 1.1 Non-Target Response 13 101-276 101 RSYN1 Were unequivocal new lesions identified 14 101-276 101 RSORRES4 Tumor Biomarker Response 15 101-276 101 TLPCNTCH % Change from Baseline 16 101-276 101 TLNADIR % Change from NADIR 17 101-276 101 RSORRES3 RECIST 1.1 Overall Response 18 ; run; proc print data=tumor1;run; The sql step I tried: (it does not create the request dataset though, just add a hint to solve the question): proc sql; select * from tumor1 group by sortordernum order by sortordernum,id; quit; ... View more

 I have cycle 1 to 20, for first 3 cycle the lab is done on C1D1 C1D3 C1D8 C1D15 C1D22 C1D29 C1D36, after which Lab is performed only on  Day 1 (CxD1). now I need to calculate the future dates for the lab, when the dosing is present. how do I calculate the future dates for the lab based on the number of days from the Dosing date, only if the lab missing for all 20 cycles. So if you have data like: data have ; input subject cycle start :date. end :date.; format start end date9.; cards; 1032 1 29NOV2022 31JAN2023 1032 2 19JAN2023 16MAR2023 2005 4 01FEB2021 15APR2021 ; You can generate a record for each expect lab sample date like this: data want; set have; length labday $8 labdate 8; format labdate date9.; if cycle in (1:3) then do day=1,3,8 by 7 while((start+day-1)<=end); labday=cats('C',cycle,'D',day); labdate=start+day-1; output; end; else do; day=1; labday=cats('C',cycle,'D',day); labdate=start; output; end; run; Results: Obs subject cycle start end labday labdate day 1 1032 1 29NOV2022 31JAN2023 C1D1 29NOV2022 1 2 1032 1 29NOV2022 31JAN2023 C1D3 01DEC2022 3 3 1032 1 29NOV2022 31JAN2023 C1D8 06DEC2022 8 4 1032 1 29NOV2022 31JAN2023 C1D15 13DEC2022 15 5 1032 1 29NOV2022 31JAN2023 C1D22 20DEC2022 22 6 1032 1 29NOV2022 31JAN2023 C1D29 27DEC2022 29 7 1032 1 29NOV2022 31JAN2023 C1D36 03JAN2023 36 8 1032 1 29NOV2022 31JAN2023 C1D43 10JAN2023 43 9 1032 1 29NOV2022 31JAN2023 C1D50 17JAN2023 50 10 1032 1 29NOV2022 31JAN2023 C1D57 24JAN2023 57 11 1032 1 29NOV2022 31JAN2023 C1D64 31JAN2023 64 12 1032 2 19JAN2023 16MAR2023 C2D1 19JAN2023 1 13 1032 2 19JAN2023 16MAR2023 C2D3 21JAN2023 3 14 1032 2 19JAN2023 16MAR2023 C2D8 26JAN2023 8 15 1032 2 19JAN2023 16MAR2023 C2D15 02FEB2023 15 16 1032 2 19JAN2023 16MAR2023 C2D22 09FEB2023 22 17 1032 2 19JAN2023 16MAR2023 C2D29 16FEB2023 29 18 1032 2 19JAN2023 16MAR2023 C2D36 23FEB2023 36 19 1032 2 19JAN2023 16MAR2023 C2D43 02MAR2023 43 20 1032 2 19JAN2023 16MAR2023 C2D50 09MAR2023 50 21 1032 2 19JAN2023 16MAR2023 C2D57 16MAR2023 57 22 2005 4 01FEB2021 15APR2021 C4D1 01FEB2021 1   ... View more

Even in Excel, enabling Slicers that point at Tables could be another option. VBA seems a touch outdated, but it depends on the complexity of the reports. ... View more

This one work perfectly . Thank you very much. ... View more

data Treatment1; format Subject $4. Visit $10. Visit_date date10. NextCycleManuallyAdded $3.; input Subject $8. Visit $12. Visit_date MMDDYY10. NextCycleManuallyAdded $5.; cards; A001 Screening 10/27/2021 Yes A001 cycle1 12/1/2021 Yes A001 cycle2 1/17/2022 Yes A001 cycle3 2/28/2022 Yes A001 cycle4 4/19/2022 Yes A001 cycle5 5/30/2022 Yes A001 cycle6 7/11/2022 Yes A001 cycle7 8/22/2022 Yes A001 cycle8 10/3/2022 Yes A001 cycle9 11/17/2022 Yes A001 cycle10 1/2/2023 Yes A001 cycle11 2/15/2023 Yes A001 cycle12 3/27/2023 Yes A002 Screening 11/22/2022 Yes A002 cycle1 1/14/2023 Yes A002 cycle2 2/28/2023 Yes A003 Screening 9/30/2022 Yes A003 cycle1 11/2/2022 Yes A003 cycle2 11/23/2022 Yes A003 cycle3 1/2/2023 No A003 EOT 1/9/2023 A004 Screening 9/1/2022 Yes A005 cycle1 9/23/2022 Yes A005 cycle2 10/31/2022 No A005 EOT 11/2/2022 ; run; proc sort data = Treatment; by subject descending visit_date; run; data Treatment2; set Treatment; format NextCyle _TempNextCyle $3.; retain _TempNextCyle; by Subject; select; when(first.Subject and Visit eq 'EOT' ) do; NextCyle = ''; _TempNextCyle = 'No';end; when(first.Subject) do; NextCyle = 'Yes'; _TempNextCyle = 'Yes';end; otherwise do; NextCyle = _TempNextCyle; _TempNextCyle = 'Yes';end; end; /* select; when(NextCyle eq NextCycleManuallyAdded) CorrectResult = 1; otherwise CorrectResult = 0; end; */ drop _: ; run; proc sort data = Treatment2; by subject visit_date; run; ... View more

Remove the comma which was accidentally placed at the end of the link. ... View more

You can use a format to divide the dates in two periods. For example: proc format; value BA low - '12JUN2013'd = "Before" '13JUN2013'd - high = "After"; run; proc glm data=myData; format date BA.; class date; model y = date; run; proc freq data=myData; format date BA.; tables date*state / chisq; run; PG ... View more

activity Poultry processing, Meat Processing, Poultry slaughter Poultry slaughter, Meat Processing Ready to eat Poultry, Poultry slaughter Meat Processing, Import Meat slaughter, Import, Meat Processing Ready to eat meat, Meat Processing Import This may occur in any combination, out of which i want to extract either poultry, meat, export, import to find out how many poultry centers (processing, slaughter, ready to eat), how many meat centers, and import, expor ... View more

Take a look through Robert Allison's SAS/Graph Examples! and find an example that's closes to what you're looking for.  His examples all have sample data and code to help. ... View more