proc sql; create table EVT_SP440_2a as
select *
from EVT_FY2018Q2
where FLAG_SP440=1;
quit;*381 records had SP440 entry out of 387 EVT records;
How would I modify the code above to create an output with the following columns
Fiscal Year Fiscal Quarter CIHI Key Indicator No
The 1st three bolded fields are present in the EVT_FY2018Q2 dataset but Indicator No is for this datastep
Subsequently i have further sql steps which will produce the other indictor results as sas datasets
All I need to do is create and output that lists each cihikey for every indicator
e.g.the following output
CIHIKey1 2018 Q1 IndicatorNo1
CIHIKey2 2018 Q2 IndicatorNo2
CIHIKey3 2018 Q2 IndicatorNo2
Hi @Ranjeeta Good afternoon. May I request you to post a sample of your data(HAVE) and sample of your expected output(WANT) with your attempt. This would help anybody immediately jump on the solution. My 2 cents opinion.
Also the above helps us test. Make sure you post a representative sample otherwise this will go back and forth(Ding Dong) as I call it
Great!
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 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.