Proc content output    # Variable Type Len Format12543 a Char 31   b Char 8   c Num 8 PERCENT10. d Num 8 PERCENT10. e Num 8 PERCENT10.   I am trying to add a value to the last row of the dataset which is the mean value.    My code: proc sql; select mean(c)*100 into :orr_pct from Efficacy; select mean(d)*100 into :orrc_pct from Efficacy; select mean(e)*100 into :dcr_pct from Efficacy; insert into eff_all2(Cohort_new, N, c, d,e) values ("Total","&ne_allt",put(&orr_pct,8.2),put(&orrc_pct,8.2),put(&dcr_pct, 8.2)); quit; I get an error:  Error: proc sql; 237 insert into eff_all2 238 values ("Total", &ne_allt, put(&orrc_pct, 8.2), put(&orr_pct, 8.2), put(&dcr_pct, 8.2)); ___ _ 22 200 202 ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant, a datetime constant, a missing value, ), +, ',', -, MISSING, NULL, USER. ERROR 200-322: The symbol is not recognized and will be ignored. ERROR 202-322: The option or parameter is not recognized and will be ignored. The put command keeps giving me error.  When i insert without the put value i get the output but the decimal pint is mi ... View more

Hello,  I am creating a sas macro to read metadata file and assign libname depending on value obtained from metadata file.   Code: *Read metadata file (works fine)* PROC IMPORT OUT= Work.Metadata DATAFILE= "/home/pandek1/Reporting_DataMart/Input/Reporting_DataMart.xlsx" DBMS=xlsx REPLACE; SHEET="Sheet1"; GETNAMES=YES; RUN;  *Macro to assign libname* %Macro Study_list(); proc sql print; select distinct(Study) into :studylist separated by ' ' from Metadata; quit; %do i=1 %to %sysfunc(countw(&studylist,%str( ))); %let study_list=%scan(&studylist,&i,' '); %put &study_list; %global ta compd study; *Works Fine* data _null_; length ta compd study $ 10; ta=substr("&study_list",1,2); compd=substr("&study_list",3,3); study=substr("&study_list",7,3); run; %let ccvpath="/gbs/prod/clin/data/&ta./&compd./&study./stable/blinded/level0"; libname Input "&ccvpath" access=readonly; libname Input clean; %end; %mend Study_list; %Study_list;   *SAS log message* /gbs/prod/clin/data/ca/209/77T/stable/blinded/level0 ERROR: The CLEAN engine cannot be found. ERROR: Error in the LIBNAME statement. I have tried using libname function inside data step but to no use.  Example: *libname(libref,ccvpath,);   The idea is to loop through libname and extract data depending on each libname value.    Thank you in advance.     ... View more

My dataset looks like this And I want it to look like this Subject Code site subj 0156 00062 156 62 0156 00062 156 62 0047 00032 47 32 0034 00066 34 66 0032 00029 32 29 . . My Code: if "Subject Code"n ^="" then site=input(scan("Subject Code"n,1,' '),z9.); put site=; if "Subject Code"n ^="" thensubj=input(strip(substr((scan("Subject Code"n,-1)),1,4)),$4.); put subj=; The Output i get: site=15600062 subj=1560 As you can see sas takes out the leading 0 values and the space " ", because of which it's difficult to split. ... View more