No, S1000 begins with "S1".
Maybe you want to modify your z array definition to
array z(*) s:;
Ohhh yes, that was the only issue.
Thanks
Not on my computer :
143 proc sql;
144 SELECT count(*) INTO :nvar
145 FROM dictionary.columns
146 WHERE LIBNAME="SASHELP" AND MEMNAME="YR1001"
147 AND NAME LIKE "S0%";
148 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.05 seconds
cpu time 0.00 seconds
149
150 %put &=nvar.;
NVAR= 503
Try to print the dimensions of each of your arrays to see if they match :
dimz=dim(z);
put dimz=;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: