Hello    I have below dataset    data new; input room $ equpi $10.; datalines; A printer A fax A monitor B fax B monitor C LCD D montior ; run;   Below is the output I want       I have tried using proc transpose .But not geeting result    How can I acheive this      ... View more

%let aa="bddabc@new.dk"  "bddabc@new.dk"; %put &aa;   data new; zz=translate("&aa","@","$"); run;   NOTE: Line generated by the macro variable "AA". 1    ""bddabc@new.dk"  "bddabc@new.dk"      ---      216         -----         388         76 ERROR 216-185: The use of a BIT string constant is not allowed in this context.   ERROR 388-185: Expecting an arithmetic operator.   ERROR 76-322: Syntax error, statement will be ignored.   72   run;   Question : what does this error mean " The use of a BIT string constant is not allowed in this context."   ... View more

%macro example9; %LET Rsysv =xxxx; OPTIONS COMAMID = TCP ; signon Rsysv  user=xxxx password=yyyy noscript; let remvar1=75; %syslput x=&remvar1.; rsubmit; data c; y="&x."; run; proc download data=c; run; %sysrput yy=&x; endrsubmit; %put &yy.; %mend; %example9;     ERROR: %SYSRPUT statement is valid only when OPTION DMR is in effect. 74    data c; 75    y="&x."; 76    run;   why this error is coming and why value of YY is not resloving through put statement  ... View more

%let table_no=EMP_HIST; proc sql; connect to oleDB as passThru (properties=('Integrated Security'=SSPI 'Persist Security Info'=TRUE 'Initial Catalog'=DBDWH_EMP) provider=SQLOLEDB PROMPT=NO DATASOURCE='DWH-I-SQL.DWHNET\DB01 schema=DWHDS); create table work.temp_views as select * from connection to passThru ( SELECT s.name as schema_name ,v.name as view_name FROM sys.views v ,sys.schemas s WHERE v.schema_id=s.schema_id AND s.name like 'dwh' AND v.name ="&table_no" ORDER BY 1,2 ); disconnect from passThru; quit; ERROR: Describe error: IColumnsInfo::GetColumnInfo failed. : Deferred prepare could not be completed.: Statement(s) could not be prepared.: Invalid column name 'EMP_HIST'.     Question -I am ruuning the above code and it seems that code is resloving the macro varibale table no but due to pass through method it is showing above error   What should I write to run this code   ... View more

Can we create prompts in SAS 9.4 as we do in SAS enetrprise guide  ... View more