proc import datafile='D:\Exchange of data\shoes.xlsx' dbms=xlsx out=shoes replace; ENDCOL="4"; STARTCOL="2"; run; In the above code it showing error.suggest me where I am going wrong? ... View more

I resolve to 8.what  does it signifies?   code  (data sets frrom SAS Macro Programming Made Easy) options mprint mlogic symbolgen; %macro trimname(namevalue); %cmpres(%qupcase(%sysfunc( compress(%superq(namevalue),%str(, ),kA)))) %mend trimname; proc tabulate data=work.ytdsales (where=(upcase(author)= "%trimname(%str(wright, LINDA, Lisa))")) ; title "Title list for %trimname(%str(wright, linda, lisa))"; class booktitle datesold bookfmt; tables booktitle=' ', datesold="Quarter Sold" all='**Total Books Sold', all="Books Sold"*(bookfmt all='Total')*n=' '*f=3. / misstext='0'; format datesold qtr.; run; ... View more

whay it showing error  with following code? libname books "C:\books\datasets"; data book.ytdsales(label='Sales for 2014'); attrib section length=$30 label='Section' booktitle length=$50 label='Title of Book' author length=$50 label='First Author' publisher length=$50 label='Publisher' ... View more

What is difference between single quotation marks and double quotation marks? ... View more

%sysfunc - why this function we use? ... View more

DATA step creates a permanent SAS data set? ... View more