Yes tables are in same library but with different names and want result as below and it has the common key Table List Table Rows Count Distinct Key Count Test_2020_Jul_04 35678 27890 Temp_2020_Aug_05 54987 50000 Check_2020_Sep_06 68775 34980 Members_2020_Oct_03 34000 24578 Table5_2020_Nov_03 15000 9845 ... View more

is there any other way we can do this.??   i mean by using dictionary.tables if yes the how.??   ... View more

what if my table names are different ... View more

654 data all / view =all; 655 length dsname dname $41; 656 set work.table: indsname=dname; ^ ERROR: Found "indsname" when expecting one of END, KEY, NOBS or POINT 657 dsname = dname; 658 run; ... View more

ghetting this error 616 set temp.table: indsname=dname; ^ ERROR: Found "indsname" when expecting one of END, KEY, NOBS or POINT i have 5 tables in temp library ... View more

I have 5 tables in library Temp   Table Name with obs counts Table1-35678 Table2-54987 Table3-68775 Table4-34000 Table5-15000   I want result like this in another table Table List Table Rows Count Distinct Key Count Table_2020_Jul_04 35678 27890 Table2_2020_Aug_05 54987 50000 Table3_2020_Sep_06 68775 34980 Table4_2020_Oct_03 34000 24578 Table5_2020_Nov_03 15000 9845   ... View more

I have 5 tables in library Temp   Table Name with obs counts Table1-35678 Table2-54987 Table3-68775 Table4-34000 Table5-15000   I want result like this in another table Table List Table Rows Count Distinct Key Count Table1 35678 27890 Table2 54987 50000 Table3 68775 34980 Table4 34000 24578 Table5 15000 9845     ... View more

I don't want to use %let statement it should pick up the year from dataset and should increase by year when it will start running for next year ... View more

Right invalid date in test2 ... View more

Right, but program needs to validate this date and send an error vai email that date is wrong correct it so person who sent me file will fix it from his end ... View more

PROC IMPORT OUT= work.PRACTICE1 DATAFILE= "&file Practice.xlsx" DBMS=XLSX REPLACE; RUN; data work.PRACTICE; set work.PRACTICE1 ; Date=input(LOAD_DATE,ddmmyy10.); Date ddmmyy10.;; run; Thats how i am reading excel file. ... View more

i am reading excel file and that date cell in excel file with date value as 120/04/2020 and i have already converted variable to number and applied format ddmmyy10. by this it will take date as dot but i want to identify and put error. ... View more