Hello, I'm trying to read an Excel sheet in SAS using proc import. The sheet has date/time variables formatted as m/d/yyyy h:mm. When imported to SAS, the variables are converted to string. For example a value in the Excel sheet of: 12/31/2020 10:42:00 PM is imported as a character variable with the value: 44196.94583333333. When I try converting the character variable to numeric, SAS doesn't allow me to apply the DATETIME. format, it only works if I use the format 20. When I apply the DATETIME. format to the newly created numeric variable (formatted 20.), I get the wrong date! Is there a way to fix this? Thank you:) ... View more

Hello, I used the macro below to calculate shortest driving distances between a set of addresses. I got the error "ERROR: Bad request. Use the debug option for more info." I used this code to check "filename gmaps url 'http://support.sas.com/techsup/service_intro.html' debug ;"  which gave no output at all! What is the "Bad request" error? And Can I fix it? Thanks. The macro I used: *Create empty data set to append all distances; data drdist; run; %macro ShortDrDist(j=); *Create loop to access each observation; %do i=1 %to &j; *Assign macro variables needed; data _null_; set AddressY; if _n_=&i then do; call symput('addr1',trim(strip(Address1))); call symput('addr2',trim(strip(Address2))); call symput('referhid',referhid); call symput('hospid',hospid); end; run; *Find Road distances; filename gmaps url "http://maps.google.com/maps?daddr=&addr1.%nrstr(&saddr)=&addr2"; data drdistX&i (drop=sitecode idrivdist rdstart); infile gmaps recfm=f lrecl=1000 end=eof; input sitecode $1000.; referhid="&referhid"; hospid="&hospid"; AddStart=tranwrd(tranwrd("&addr1","+"," "),",",", "); AddEnd=tranwrd(tranwrd("&addr2","+"," "),",",", "); if find(sitecode,'miles'); idrivdist=find(sitecode,'miles'); rdstart=idrivdist-1; drivdist=input(compress(scan(substr(sitecode,1,rdstart),1, ' "','bc'),','),best12.); run; proc sort data=drdistX&i; by drivdist; run; data drdist&i; set drdistX&i; by drivdist; if _n_=1; run; data drdist; set drdist drdist&i; if drivdist^=.; label AddStart='Starting Address' AddEnd='Ending Address' drivdist='Shortest Driving Distance (miles)' referhid='Referring Hospital' hospid='Destination Hospital'; run; filename gmaps clear; %end; %mend; %ShortDrDist(j=&obsnum); ... View more

Hello,   I have a set with hospital IDs, names, and addresses. In the same set the same hospital could be the place for patient admission, patient referral (patient sent to another hospital), or patient reception (patient came from another hospital). The address is assigned only to the admission hospital. Is there a quick way/code to create referring hospital and receiving hospital address variables  using the hospital ID and Address fields?  Thank you! ... View more

Hello. I'm using the Link King to link two data sets together. When importing my matching set I keep getting a warning that I have over 35 K records with missing date of birth values, which is not the case! My date of birth variable is a string formatted as YYYYMMDD. Anyone knows why this is happening and how to fix it? Thank you! ... View more