cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
ari
‎09-22-2021
  • 114 Posts
  • 14 Likes Given
  • 2 Solutions
  • 1 Likes Received

Re: SAS output missing values in a numeric variable as "." only (inste...

by Quartz | Level 8 in SAS Programming
‎09-22-2021 12:05 PM
‎09-22-2021 12:05 PM
Hi, Thanks for the response. I want to see the dot for missing numeric variables in the csv output file. But missing values are blanks in the csv file. Any ideas to represent missing values as dot (".") in csv file? ... View more

SAS output missing values in a numeric variable as "." only (instead o...

by Quartz | Level 8 in SAS Programming
‎09-22-2021 02:58 AM
‎09-22-2021 02:58 AM
Hi, I tried the following code but the missing values in the value column appear as blanks only instead of the . (dot).   If missing(value) then value= . ;   I tried also this. If missing(value) then value= "." ;    It didn't work, I still see missing values as blanks only for the value numeric variable.   Please help.     ... View more

Re: proc sgplot issues with grouping variable in the plot

by Quartz | Level 8 in SAS Programming
‎01-14-2021 11:02 PM
‎01-14-2021 11:02 PM
Thanks but its still doesnt solve the grouping issue. the data points are not connected per subject.  ... View more

proc sgplot issues with grouping variable in the plot

by Quartz | Level 8 in SAS Programming
‎01-14-2021 02:58 PM
‎01-14-2021 02:58 PM
I am trying to make  time series plot of few subjects grouped by dose. The subejcts are colored according to the group but the line connecting the data points looks strange as shown in graph below. Ideally I want the data points for each subjects connected per subject (but colored per the grouping variable) rather than the grouping variable. Any solution to this issue ?     code: proc sgplot data = data1; series x = time y = value/ markers markerattrs = (symbol = circlefilled) group = dosec lineattrs = (thickness = 2); run; ... View more

How to create anonymised ID in SAS?

by Quartz | Level 8 in SAS Programming
‎12-10-2020 12:48 AM
‎12-10-2020 12:48 AM
Is there a way to create anonymized ID in SAS?   which can also account for the new ID's added later. for example: Original data: ID     Anonimsed ID 1         204 2         206 3         208   New data: ID     Anonimsed ID 1         204 2         206 3         208 4         201 5         203   So retain the anonymized IDs created for the original ID's and only anonymise the newly added ID's.       ... View more

sas function to convert clock time to nominal values

by Quartz | Level 8 in SAS Programming
‎12-09-2020 02:21 AM
‎12-09-2020 02:21 AM
Hi, Is there a SAS function to convert the SAS clock time to nominal values? for example: 8:30 am    = 8.5 16:30 pm = 16.5 likewise... ... View more

Proc sgplot: cant add standard deviation to median

by Quartz | Level 8 in Graphics Programming
‎02-26-2020 05:05 AM
‎02-26-2020 05:05 AM
Hi All,   I cant add standard deviation to calculated median values. WARNING: Limit bars can only be generated with the MEAN statistic. The LIMITS= option will be ignored.   SAS prints this warning in the log.    Is there a way to overcome this issue and show SD with Median values?   My code: proc sgplot data=test; vline time / response=chg group=dose stat=median limitstat=stddev; xaxis label= "Time "; yaxis label="value"; run; ... View more

ERROR: The text expression length (65572) exceeds maximum length (6553...

by Quartz | Level 8 in SAS Programming
‎12-17-2019 05:40 AM
‎12-17-2019 05:40 AM
Dear Experts,   I encountered this error from running this code:   ERROR: The text expression length (65572) exceeds maximum length (65534). The text expression has been truncated to 65534 characters.   proc sql; select catx("=", NAME, quote(trim(dscr))) into :label_list separated by " " from test; quit;   Is there a way to solve this error?   Please let me know. Many thanks in advance.     ... View more

convert sas time5. format values to nominal values

by Quartz | Level 8 in SAS Programming
‎01-24-2018 05:51 AM
‎01-24-2018 05:51 AM
Hi ,   Is there an easy way to convert  time values in time5. format into nominal time values.? Example: 8:30 as 8.5                 16:30 as 16.5                 17:45 as 17.75     ... View more

Re: Convert multiple xpt to sas files

by Quartz | Level 8 in SAS Programming
‎11-23-2017 12:33 PM
‎11-23-2017 12:33 PM
@Tom; Any comments? ... View more

Convert multiple xpt to sas files

by Quartz | Level 8 in SAS Programming
‎11-23-2017 09:27 AM
‎11-23-2017 09:27 AM
hi All,   I am using the code below to convert xpt files to sas files. However, I see the following error message "ERROR: Libref XPTFILE is not assigned." Any leadss to resolve this issue?   Thanks   %let path=E:\data\source; filename xptfiles pipe "dir /b ""&path\%str(*).xpt"" " ; filename code temp; data files; infile xptfiles truncover; input filename $100. ; file code; put 'filename xptfile "&path\' filename +(-1) '" ;'; put 'proc copy inlib=xptfile outlib=ms; run;' ; run; libname ms 'E:\data\SAS datasets'; %inc code / source2 ;   ... View more

Re: To create frequency table

by Quartz | Level 8 in SAS Programming
‎10-19-2017 12:50 PM
‎10-19-2017 12:50 PM
. ... View more

To create frequency table

by Quartz | Level 8 in SAS Programming
‎10-19-2017 11:24 AM
‎10-19-2017 11:24 AM
Dear Community,   I'm trying to create a frequency table using the following sample dataset. For subjects, var1-var3 are variables measured on different days (day variable). I would like to generate a frequency count for how many subjects with value=1 on any given day per study (startified by study).   Any help to achieve the output is greatly appreciated.   data test; input id var1 var2 var3 day stud; datalines; 100101 1 1 1 -4 1 100101 1 0 0 1 1 100101 1 0 0 3 1 100101 1 1 1 8 1 100101 1 0 0 15 1 100101 1 0 0 17 1 100101 0 1 1 27 1 100103 1 1 1 -5 1 100103 1 0 0 1 1 100103 1 0 0 3 1 100103 0 1 1 7 1 100106 1 1 1 -4 1 100106 1 0 0 1 1 100106 1 0 0 3 1 100106 1 1 1 8 1 100106 1 0 0 15 1 100106 1 0 0 17 1 100106 1 1 1 26 1 1000101 1 1 1 -13 2 1000101 1 0 0 -8 2 1000101 1 0 0 0 2 1000101 1 0 0 1 2 1000101 1 0 0 1 2 1000101 0 1 1 7 2 1000101 1 0 0 8 2 1000101 1 1 1 15 2 1000101 1 0 0 111 2 1000103 1 1 1 -18 2 1000103 1 0 0 -9 2 1000103 1 0 0 0 2 1000103 0 1 1 6 2 1000103 1 0 0 7 2 1000103 1 0 0 17 2 1000103 0 1 1 19 2 1000103 1 0 0 24 2 4900201 1 0 0 -9 2 4900201 0 1 1 -9 2 4900201 1 0 0 -8 2 4900201 1 0 0 0 2 4900201 1 0 0 1 2 4900201 1 0 0 2 2 4900201 0 1 1 6 2 4900201 1 0 0 7 2 4900201 1 0 0 15 2 ; run;   Any help to achieve the example output is greatly appreciated.   day day day day day day day   -4 1 3 8 15 17 27 var1               var2               var3                 ... View more

Re: Impute missing values of the vairables with median by study, treat...

by Quartz | Level 8 in Statistical Procedures
‎05-19-2017 06:01 AM
‎05-19-2017 06:01 AM
@Rick_SAS:   Hi Rick, Thanks for this solution, this is the output from the table. I'm  still not sure how to use this table.                                                            study    treatment gender _TYPE_  _FREQ_ alti        asti        albi  201 3 1 0 6 . . . 201 2 1 0 9 . 43.5 72 201 1 1 0 33 . . 72   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-22-2021 03:25 PM
Likes given to
Likes from
View All
Quick links