Generating Output

[Ranjeeta]

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

[novinosrin]

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

[Ranjeeta]

Thankyou novinosrin I think i have resolved my issue as of now 🙂

[novinosrin]

Great!