I try to export a sas dataset (have) to sas code file (want) using the following code.   PROC EXPORT DATA= mysasdat.have            OUTFILE= "C:\Users\weig3\Desktop\want.sas"            DBMS=TAB REPLACE;      PUTNAMES=NO; RUN;     have (SAS7bdat)   COL proc format ; value DFSTATv 0 = "lost" 1 = "clean" "2 = "dirty" 3 = ""error"    The output “want” belw show an extra “ “ as compare to the original “have”.     proc format ; "value DFSTATv 0 = ""lost""" "1 = ""clean""" "2 = ""dirty""" "3 = ""error"""   Any idea for don't having the extra “ “ ?   Thanks ... View more

I try to infile a sas file (CRF.sas) to sas using the following code. The output dataset is “Want”.               data want;   infile "C:\Users\weig3\Desktop\CRF.sas" ; input col $ 1-300;   RUN;    The CRF.sas contain 6 line as below  The “want” contains only 4 line as below   It sounds the line “data data1 (label=”Demographics”);” is missing( Please see attached file for details.)   Could anyone help me to avoid the error?   Thanks ... View more

My_table has two fields, one is defined as [c_array] char(20), with values like ‘123456781ABCD234’. Another field is defined as [b_array] binary(8). The task is to convert value of c_array into binary and assign it to b_array.   thanks   ... View more

  Our client only has SAS visual analytic (SAS VA) available. We are requested to create reports using SAS VA, and then those reports are requested to append to provided PDF files dynamically ( i.e. pdf files changes weekly, report scheduled weekly, we need to combine the two weekly). I know Acrobat can do it easily, but client prefer to create report dynamically using SAS VA. Alternately, I think to output report direct to exist PDF (provide pdf), which I had done it in ODS output in SAS 9.4 by coding. Could it possible to do it in same way using SAS VA? Any suggestion will be greatly appreciated. ... View more

I have 500 PDF  files need to convert to SAS datasets. I found there are some complex codes show to do one convert (one pdf file to one  sas datsset) . This code is prety complex and one do one convert. Is there any simple proc. to do it in a simple way and can quickly convert  these 500 pdf files?   Thanks       ... View more

I need to do regression analysis on hundreds dataset.  I had get one regression analysis done in one dataset by using EG task.  Is there a way to get hundreds dataset done with regression by using  task or a macro in EG? Thanks ... View more