What is the best statement SET or Merge to get the desired PE output. I need to join the tables by PID and retain only the records from table P. Also need to have a field called source in PE to identify if the record is in both or P. Thank you Table P     Table E   PID SID1   PID SID2 1 123   1 124 2 24   2 24 3 43   4 33 5 26   5 23       6 15 Table PE         PID SID1 SID2     1 123 124     2 24 24     3 43       5 26 23     ... View more

I need to capture a value from the text field and use that as dataset or filename. But I am having issues with removing the leading and tailing blank spaces. My goal is to create a report and save the file as "RFPVER05567 Row_2BRHTUHB.pdf" No matter what I do now, my file is saved as "RFPVER05567 Row_2BRHTUHB                   .pdf" or "            RFPVER05567 Row_2BRHTUHB.pdf". Any suggestions? proc sql noprint; select distinct right(PName) into :plate from test ; select distinct strip(pName) into :plate_st from test; select distinct compress(pName) into :plate_cp from test; quit; pName=RFPVER05567 Row_2BRHTUHB   Thank you ... View more

I would like to create new field called Threshold based on the existing Test field. Is it possible to combine 2 code below with out an additional data step?   if test ="NP" then Threshold="> 14.80 = POS" else if test="RB" then Threshold="> 14.64 = POS" else if test="SP" then Threshold="> 19.66 = POS" proc sql; create table sample_final as select sample, test, conc_calculated format=7.2, count(N) as Total_counts, "" as Threshold, from sample_calcs group by sample, test, conc_calculated, Total_counts ; quit;   Thank you ... View more

I am generating .pdf report and have three questions? 1) I am getting error for .pdf file. What file is it looking for?  ods pdf FILE="C:\Temp\MVS.pdf"; ERROR: Physical file does not exist, C:\ProgramFiles\SASHome94\ReportFontsforClients\9.4\saswcur.ttf. 2) can we add style to the column headers and make it blue color for .PDF report? 3) How do I group after certain fields. Calc.Conc.Mean, recovery Mean, Conc Cv, R from Curve? Test Quality Dilution Concentration Well Calc. % Calc.     R Concentration Recovery Conc. Recovery Conc. from     Mean Mean CV curve             NTL QC1.1 5000 229 A03 190.58 83.22 191.88 83.79 0.96 1         B03 193.18 84.36 191.88 83.79 0.96 1   QC1.2 5000 39 C03 32.18 82.51 31.99 82.03 0.84 1         D03 31.8 81.54 31.99 82.03 0.84 1   QC1.3 5000 12.5 E03 10.01 80.11 9.86 78.86 2.25 1         F03 9.7 77.6 9.86 78.86 2.25 1 DDD QC1.1 5000 976 A03 751.33 76.98 769.27 78.82 3.3 0.9999         B03 787.21 80.66 769.27 78.82 3.3 0.9999   QC1.2 5000 288 C03 250.43 86.96 252.39 87.64 1.1 0.9999         D03 254.36 88.32 252.39 87.64 1.1 0.9999   Here is my code.. options orientation=landscape; ods pdf FILE="c:temp\test.pdf"; proc report data=qc_final Headline headskip nowd split='*' ; columns Test Quality Dilution Conc well mean_calc_conc mean_pct_recovery mean_Calc_Conc_Mean mean_PCT_RecMean mean_Calc_Conc_CV mean_RSquared ; define Test / order "Test" width=20; define Quality / order "Quality" width=30; define Dilution / order width=10; define Conc / order "Concentration" width=10; define Well / order "Well" width=7; define mean_calc_conc / order "Calc. * Concentration " width=10; define mean_pct_recovery / group /*order*/ " Recovery" width=7; define mean_Calc_Conc_Mean / group /*order*/ "Calc. * Conc. * Mean" width=10; define mean_PCT_RecMean / group /*order*/ "% * Recovery * Mean" width=7; define mean_Calc_Conc_CV / group /*order*/ "Calc. * Conc. * CV" width=10; define mean_RSquared / group /*order*/ "R * from * curve" width=7; run; ods pdf close;     Thank you ... View more

I am using base sas on windows platform, I have 2 .csv files that I need to read from the url and save them to my desktop using API token.. CSV file has headers.. In the code below, I am trying to read one .csv file. Is there a specific order to pass these parameters?   %let mytoken =yyyyyyy; filename my_in1 "ebyyc88ret54";     *.csv dataset name in that url; proc http url = "https://yyyy.yy/proxy/api/dataproxy/datasets/" in= my_in1 out= my_out method="GET" headerin=headers oauth_bearer = &mytoken.; run; I am getting the following error ( Iguess the system is checking for the my_in1 on my c drive instead of the URL.. ERROR: Physical file does not exist, C:\temp\ebyyc88ret54.   Thank you ... View more