@Abishekaa wrote: Hi Tom, Thanks so much for the reply. However, 24M is not the last visit
So I have no idea what your data looks like then. Perhaps you can provide a more complete example.
If you just want to flag whether or not a particular visit exists then you might be able to just do that with dataset options. So if you existing dataset is named HAVE and the two variables of interest are named PTID and VISIT here is a data step that will create a new variable named HAS24M to indicate if the PTID has a VISIT '24M' or not. Note this assumes the data is sorted by PTID.
data want;
merge have
have(in=in2 keep=ptid visit rename=(visit=visit24m) where=('24M'=visit24m))
;
by ptid ;
has24m = in2 ;
drop visit24m ;
run;
... View more
The reason is clear: you are violating the PK by adding those rows. If the PK is relevant you need to change your update approach. Like decide whether you only wish to add records for new keys, or update rows with a key match.
... View more
What are you trying to accomplish? Are you trying to save space, combine similar "details", or something else?
Art, CEO, AnalystFinder.com
... View more
Hi: Sort of sounds like it works like an XMLMap, when you use an XMLMap, you write instructions for how SAS can read an XML file into SAS format and populate the columns on each row with information from the XML tags. This paper has some good explanations and examples of importing an XML file into SAS using an XMLMap: http://support.sas.com/resources/papers/proceedings12/253-2012.pdf cynthia
... View more
Hello,
DSD is what you are looking for.
data have;
infile datalines dsd missover;
input (A B C D E F G H I) (:$8.);
datalines;
"A","B","C","D","","F","","H",""
;
... View more
Adding a reply here in case anyone else gets this as a recommendation.
First - when transferring from z/OS to another platform: HTML and Javascript files (if any) should be transferred as Text (ASCII in some FTP programs) - codepage translaton will happen between EBCDIC and UTF8 or ASCII; image files (JPG, PNG, etc.) have to be transferred in IMAGE or BINARY mode. Secomd - there's a free Apache-based web server for z/OS that isn't hard to set up and get running; maybe just server the pages from the mainframe itself. One advantage: When you re-run your SAS program to tweak the graph or update it, you only need to refresh the web page in your browser, no file transfers necessary.
... View more
So far as I know, z/OS doesn't have a viewer for GIF images, so you'll have to transfer your image files to your PC to view them. However, if you're using an emulator on your PC to access z/OS, you should be able to use the WBROWSE command to open the SAS Remote Browser and view the file. Here's a link to the documentation for the WBROWSE command:
http://support.sas.com/documentation/cdl/en/hosto390/68955/HTML/default/viewer.htm#n1kr9eav5k7rm3n1nxo5ohhv7p1j.htm
If you don't have the SAS Remote Browser set up, you'll probably have to continue transferring your files to your PC for viewing.
Keith
... View more
Hi Data _null_,
Thank you for your promt response, I'm running this on 9.3 so till our SAS gets upgraded to 9.4 I'll keep this in progress
... View more
@vandhan
Besides of rounding you can also use the compfuzz() function for such situations.
Alternatively - and what I would do - you round the result of such operations from the very beginning. Something like:
y = round(0.1 + 0.1 + 0.1,0.00000001);
... View more
