Hi, I have data where the ID of the people are in character format and the data looks like this ID 840-02-001 840-02-002 840-02-003   Can you please suggest how to convert this text to numeric so that i can sort and also convert back to same character text. Since i cant sort the data with this id variable because it is character. data id; set name; ptid =input(id,10.); run; Help to correct the code for reading character with Hyphen and converting to numeric for sorting.   Thanks     ... View more

I used the right click option on the file code generated to download but its not downloading the file. Is there any alterantive to download file generated from SAS on Demand. ... View more

I used the auto call program %loc2xpt to convert sas datasets to XPT  using the below code. proc sql; create table sdtmDomains as select libname ,memname from dictionary.tables where libname eq 'SDTM' order by memname; quit; data _null_; set sdtmDomains end=eof; call symput('domain_' || strip(put(_n_,2.)) ,strip(lowcase(memname)) ); if eof then call symput('domainCnt',strip(put(_n_,2.))); run; %macro xpt; %do idx=1 %to &domainCnt; filename xptfile "c:\public\sdtm\&&domain_&idx...xpt"; %loc2xpt(libref=sdtm ,memlist=&&domain_&idx ,filespec=xptfile ); %end; %mend xpt; %xpt   I am trying to change the above code to use with another auto call macro %xpt2loc to convert the xpt datasets back to sas datasets and I am ending with errors. %xpt2loc(libref=work, memlist=Thisisalongdatasetname, filespec='c:\trans.v9xpt' ); I susbstituted the above auto call code with %xpt2loc macro call and its not working. Any help on this issue. I have to convert 100 xpt datasets using the %xpt2loc macro. ... View more