About r3570

Peter_C · ‎11-18-2021

See the paper VFORMAT Lets SAS® Do the Format Searching At http://support.sas.com/resources/papers/proceedings14/1744-2014.pdf

Ksharp · ‎11-17-2021

/*XPT文件的路径*/ %let path_in= D:\XiaKeShan\my_code\数据管理\转XPT文件\XPT ; /*XPT文件转成SAS数据集的路径*/ %let path_out= D:\XiaKeShan\my_code\数据管理\转XPT文件\SAS ; libname out v9 "&path_out"; data _null_; rc=filename('x',"&path_in."); did=dopen('x'); do i=1 to dnum(did); memname=dread(did,i); call execute(cat("libname tranfile xport '&path_in\",memname,"';proc copy in=tranfile out=out ; run;")); end; run;

FreelanceReinh · ‎10-29-2021

Hello @r3570, @r3570 wrote: This looks somewhat complex program. Hard for me to understand. Could you please help me with a simple easy to understand program ? Maybe it's easier to understand if you split the task into several short steps: /* Create a temporary unique sort key _SEQNO */ data _tmp / view=_tmp; set have; _seqno=_n_; run; /* Separate duplicate and unique ID-DATE-EVENT combinations */ proc sort data=_tmp out=dup nouniquekey uniqueout=uni; by id date event; run; proc sort data=dup; by _seqno; run; proc sort data=uni; by _seqno; run; /* Reunite the two parts, flagging the duplicates */ data want(drop=_seqno); set dup(in=d) uni; by _seqno; if d then flag='Y'; run;

PeterClemmensen · ‎10-28-2021

Try this data have; input ID TERM $ 5 - 25; datalines; 101 VOMITING 101 HEADACHE and NAUSEA 102 FATIGUE 102 PYREXIA/COLD ; data want; set have; flag = ifc(countw(term, ' /') > 1, 'Y', ''); run;

r3570 · ‎10-26-2021

Apologies..!! out put is as expected. there was issue in case sensitive info...i rectified it.. thank you so much..!!

SteveDenham · ‎10-05-2021

The examples contain sample programs, data and output. SteveDenham

ballardw · ‎09-24-2021

@r3570 wrote: Hi Tom, I was able to create a single xpt file which included all the datasets in it using proc copy. Because it is hectic task to write 26 programs for each dataset to convert into xpt, I need a macro which creates xpt file separately for each dataset in one go. If you can place all the data sets into one file what is the advantage of creating 26 files?

Reeza · ‎09-22-2021

By what rule? What should XZ_VAC_901 map to? What's the encoding system?

maguiremq · ‎09-22-2021

Also, here's another way to do it. data have; input (A B C D) ($); datalines; XYZ 1,2,3 PQR YZA ; data want (drop = bb i); retain a b c d; set have (rename = (b = bb)); do i = 1 to countw(bb, ","); b = scan(bb, i, ","); output; end; run; a b c d XYZ 1 PQR YZA XYZ 2 PQR YZA XYZ 3 PQR YZA

Patrick · ‎09-22-2021

Below some sample code for both a numerical and a character variable. If your variable is of type character then we must first convert the string to an number using an input statement and then use a put statement with a numerical format to create a string as you want it in your character variable. The character variable must have a length long enough to hold the additional 3 characters (the dot and two digits). data have; input @1 myvar_num @1 myvar_char $; datalines; 20010 20050 20070 20014 ; data want; set have; format myvar_num 16.2; myvar_char=put(input(myvar_char,best32.),16.2 -l); run; proc print data=want; run;

Reeza · ‎09-22-2021

By what rule? What should XZ_VAC_901 map to? What's the encoding system?

yabwon · ‎05-28-2021

Something like this: data want; input Start_Date $ 20.; t1 = scan(Start_Date,1,"T"); t2 = scan(Start_Date,2,"T"); Start_Date = catx("T", ifc(t1 = "-----","2020-01-01",t1), coalescec(t2,"00:00:00") ) ; drop t:; cards; 2020-02-02T16:29:00 2020-11-03 -----T12:47:00 ; run; proc print; run; ? Bart

PGStats · ‎05-24-2021

If you want to take care of incomplete days as well as missing periods: data want; set have; by subject; output; if last.subject then do; call missing(result); do p = period to 3; do d = day+1 to 3; period = p; day = d; output; end; day = 0; end; end; drop d p; run;

LinusH · ‎05-21-2021

Fot the firrst scenartio I woiulr use compress to remove the dashes, and then concatenate with the date string of your choice. If you store the result as a numrical datatime varible, you can chose a datetime format that will automatically display all values in the same format.

Kurt_Bremser · ‎05-19-2021

@r3570 wrote: Hi Sir, could you please also let me know how to convert the below: 2020-11-03 (in character format) to 2020-11-03T00:00:00 (character format) and 2020-11-10T09:04 (character format) to 2020-11-10T09:04:00 (character format) You do NOT store date or time values as character in SAS. You need more storage (numbers need only 8 bytes, and for dates you can reduce that to 4), and everytime you need to work with the values you have to convert them first. So you simply don't. Exporting or printing them in a specific format is done at the time of export/report, and how they are displayed is determined by the assigned display format.

Online Status	Offline
Date Last Visited	‎07-08-2024 05:00 AM

Re: How to identify missing dates ?

Re: How to identify missing dates ?

How to identify missing dates ?

Re: How to identify correct treatment

Re: How to identify correct treatment

How to identify correct treatment

Re: Need help with logic

Need help with logic

Re: How to assign value to ew variable from existing variable within b...

How to assign value to ew variable from existing variable within by gr...

Re: Proc transpose help needed

Re: How to extract and replace alphanumeric characters

Re: Date time format

Re: Date time format

Re: How to convert XPT files to sas datasets ?

Re: How to identify if values are same in 2 different variables

Re: identifying a record which has 2 or more words

Re: Identifying duplicate values

Re: Nonmem Program

Re: Macro to convert sas dataset to xpt files

Re: Data Type conversion

Re: Splitting values in a variable

Re: decimal points

Re: Data Type conversion

Re: Issues with Date time

Re: Insert dummy records in a dataset

Re: Missing Date in Date time format

Re: Date time conversions