this is the variable that I have and I need to know how many rows are in this variable from obs 1 which is 1000 to last one 5009 I need a function or do loop that can count the number of rows. Site Number 1000 1001 1050 1100 1200 1250 1252 1300 1350 1351 1400 1401 1450 1451 1452 1453 1500 1600 1601 1602 1700 1750 5000 5002 5003 Main Campus 5003 Burbank 5003 Pasadena 5003 Torrance 5003 Valencia 5003 Ventura 5003 Westlake 5004 5005 5006 5007 5008 5009
... View more
I have a numeric variable which includes some written characteristics parts like the following the problem is I need to calculate some statistics for the variable by proc mean and it doesn't let me bc of the written characteristic part. this is the error that I got Variable site_number in list does not match type prescribed for this list I need a way to ask sas to ignore the written part and just calculate the numeric or substr the numeric part 1453 1500 1600 1601 1602 1700 1750 5000 5002 5003 Main Campus 5003 Burbank
... View more
PROC IMPORT OUT= WORK.auto1 DATAFILE= "C:\Users\ 2-Feb-18.xlsx" DBMS=xlsx REPLACE; SHEET="auto"; GETNAMES=YES; RUN; I'm traying to import excel file and I got an error ERROR: DBMS type XLSX not valid for import. What I should do??
... View more
NOTE: Invalid argument to function YRDIF( ,18148,'ACTUAL') at line 12375 column 34. NOTE: Invalid argument to function YRDIF( ,18189,'actual') at line 12378 column 30. also I find the data stored the numaric missing as blnk not as .
... View more
11549 if TAPER_D ne . then TAPER_A=yrdiff(DOB,TAPER_D,"actual"); ------ 68 ERROR 68-185: The function YRDIFF is unknown, or cannot be accessed.
... View more
