I take a data with 2000 columns. Names of the columns are like q1,q2,q3.... I want to create a new table with the ones that have the  count of non missing(+zero) rows more than 70% in the column. I also want to join the some column whose percentage is less than 70 to the table. My question is , how do i get 2000 output for 2000 columns with a single program and how do i specify and add the column to be created to the data. The table that I want to create should look like the one below.   Q1 resultPercantage Q2 resultPercantage Q3 resultPercantage There are also some codes that I tried to create below. %LET VARNAME = Column1/*Q1*/ Column2/*Q2*/ Column3/*Q3*/ ; %percentage(0.70) %macro procfreq(Var); %macro percentage(deger); PROC SQL; Create Table new as SELECT (tt.nonMissingCount/tt.toplamCount) as result format=percent10.2, case          when calculated result>&deger then out=yeni /*????*/          else 'false /*????*/'          end as yeniSonuc from( SELECT DISTINCT (SELECT COUNT(&Var) as NonMissing from work.exampledata WHERE &Var ne 0) as nonMissingCount ,(SELECT COUNT(&Var) as SumCnt from work.exampedata) as sumCount from work.exampledata)as tt; QUIT; %mend; %mend; %macro loop; %let i=1; %do %while(%scan(&VARNAME.,&i.,%STR( ))~=); %procfreq(%scan(&VARNAME.,&i.,%STR( ))); %let i=&i.+1; %end; %mend; %loop;   I will be very greatful if I hear from you as soon as possible. ... View more

Hello, I have a mssql code's below which i'm trying to write to SAS programming language.I am a little bir confused. Could you help me, please ?   begin tran SELECT * INTO newtable FROM maintable PIVOT ( SUM(result) FOR resul_id IN ([847],[848],[849],[850],[851],[852],[853],[854],[855],[856],[857],[858],[859],[860],[861],[862],[863],[864],[865],[866],[867],[868],[869],[870],[871],[872],[873],[874],[875],[876],[877],[878],[879],[880],[881],[882],[883],[884],[885],[886],[887],[888],[889],[890],[891],[892],[893],[894],[895]) ) PivotTable commit tran   SAS Code -> proc transpose data=maintable out=newtable Name=Pivot; run; ... View more