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: 
kmardinian
‎05-27-2021
  • 215 Posts
  • 2 Likes Given
  • 2 Solutions
  • 6 Likes Received

Re: Variable will not reassign its value

by Quartz | Level 8 in SAS Programming
‎08-16-2018 11:46 AM
‎08-16-2018 11:46 AM
I was able to get it work!! Thank you everyone for your help, sorry it was such a hassle walking me through everything. Definitely learned a lot throughout this entire process. ... View more

Re: Variable will not reassign its value

by Quartz | Level 8 in SAS Programming
‎08-16-2018 10:59 AM
‎08-16-2018 10:59 AM
Thank you, I am trying to work with what everyone is telling me, but it is still not working. I changed the code so that col variables are no longer 0 (0.0) format. And tried to change the variables so that col_1 is numeric and not a character variable. But for some reason, col_1 is not actually  being converted to a numeric variable when I check in in the dataset num_prop   data num_prop1; set num_prop (keep=vname rowlabel _type_ col_1 col_2 col_3 comnum); numcol1=input(col_1,8.0); drop col_1; rename numcol1=col_1; run; data num_prop1 ;   length rowlabel $100 col_1 col_2  col_3 col_4 $32 ;    merge num_prop bignumber;    by comnum;    col_1=cat(strip(put(col_1, 8.0)),' (', strip(put((col_1/bigcol1)*100,8.1)) ,'%)');    col_2=cat(strip(put(col_2, 8.0)),' (', strip(put((col_2/bigcol2)*100,8.1)) ,'%)');    col_3=cat(strip(put(col_3, 8.0)),' (', strip(put((col_3/bigcol3)*100,8.1)) ,'%)'); vorder=1; roworder=2; run; ... View more

Re: Variable will not reassign its value

by Quartz | Level 8 in SAS Programming
‎08-15-2018 04:14 PM
‎08-15-2018 04:14 PM
So now I'm a bit confused...should I be trying to convert the col variables to character or numeric??   I can't seem to find anything that will work ... View more

Re: Variable will not reassign its value

by Quartz | Level 8 in SAS Programming
‎08-15-2018 03:53 PM
‎08-15-2018 03:53 PM
I just tried to convert col_1 to numeric with this code, but it also didn't work   4716 4717  data num_prop; 4718  numcol1=putn(col_1,8.0); 4719  drop col_1; 4720  rename numcol1=col_1; 4721  run; NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column).       4718:20 INFO: Character variables have defaulted to a length of 200 at the places given by: (Line):(Column). Truncation can result.       4718:1   numcol1 NOTE: Variable col_1 is uninitialized. NOTE: The data set WORK.NUM_PROP has 1 observations and 1 variables. NOTE: DATA statement used (Total process time):       real time           0.01 seconds       cpu time            0.01 seconds     I think the underlying issue is, all my conversions are not working. It just stays a character variable ... View more

Re: Variable will not reassign its value

by Quartz | Level 8 in SAS Programming
‎08-15-2018 03:48 PM
‎08-15-2018 03:48 PM
Hi Tom, it unfortunately gave me the same thing as before and just printed (%) for col variables, it also still lists col variables as character after I run this.   Should I try and convert the col variables to numeric using PUTN in a separate data step before I run this code   3945  data num_prop ; 3946     retain rowlabel col_1 col_2 col_3 ; 3947     merge num_prop bignumber; 3948     by comnum; 3949     if col_1 ne '0(0.0)' then col_1=cat(strip(putn(col_1, 8.0)),' (', strip(putn((col_1/bigcol1)*100,8.1)) ,'%)'); 3950     else col_1=col_1; 3951     if col_2 ne '0(0.0)' then col_2=cat(strip(putn(col_2, 8.0)),' (', strip(putn((col_2/bigcol2)*100,8.1)) ,'%)'); 3952     else col_2=col_2; 3953     if col_3 ne '0(0.0)' then col_3=cat(strip(putn(col_3, 8.0)),' (', strip(putn((col_3/bigcol3)*100,8.1)) ,'%)'); 3954     else col_3=col_3; 3955  vorder=1; 3956  roworder=2; 3957  run; NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).       3949:51   3949:82   3951:51   3951:82   3953:51   3953:82 NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column).       3949:58    3949:101   3951:58    3951:101   3953:58    3953:101 NOTE: Missing values were generated as a result of performing an operation on missing values.       Each place is given by: (Number of times) at (Line):(Column).       1 at 3949:87   1 at 3949:96   1 at 3951:87   1 at 3951:96   1 at 3953:87   1 at 3953:96 NOTE: There were 0 observations read from the data set WORK.NUM_PROP. NOTE: There were 1 observations read from the data set WORK.BIGNUMBER. NOTE: The data set WORK.NUM_PROP has 1 observations and 13 variables. NOTE: DATA statement used (Total process time):       real time           0.02 seconds       cpu time            0.00 seconds ... View more

Re: Variable will not reassign its value

by Quartz | Level 8 in SAS Programming
‎08-15-2018 03:38 PM
‎08-15-2018 03:38 PM
You're right, I can do calculations with col_1, but I checked and, bigcol1,2,3 are all numeric. And I did the same test with bigcol1 and SAS also can perform math with it.   bigcol: Length: 8 Format: Best12. Type: Numeric ... View more

Re: Variable will not reassign its value

by Quartz | Level 8 in SAS Programming
‎08-15-2018 03:13 PM
‎08-15-2018 03:13 PM
So I guess I am confused by the fact that I cannot convert this variable from character to numeric since all 3 of its observations are numbers. ... View more

Re: Variable will not reassign its value

by Quartz | Level 8 in SAS Programming
‎08-15-2018 03:12 PM
‎08-15-2018 03:12 PM
When I check the dataset num_prop before I run that particular code. The col variable has this description: Name:col_1 Label=^(N=21) Format: $32 Type: Character.   with 3 Observations of 12, 9, 21     ... View more

Re: Variable will not reassign its value

by Quartz | Level 8 in SAS Programming
‎08-15-2018 02:50 PM
‎08-15-2018 02:50 PM
292  data numprop; 293 294  col_1 = '5(25.0)'; 295  bigcol1=1000; 296  ratio=col_1/bigcol1; 297  run; NOTE: Character values have been converted to numeric values at the places given by:       (Line):(Column).       296:7 NOTE: Invalid numeric data, col_1='5(25.0)' , at line 296 column 7. col_1=5(25.0) bigcol1=1000 ratio=. _ERROR_=1 _N_=1 NOTE: Missing values were generated as a result of performing an operation on missing values.       Each place is given by: (Number of times) at (Line):(Column).       1 at 296:12 NOTE: The data set WORK.NUMPROP has 1 observations and 3 variables. NOTE: DATA statement used (Total process time):       real time           0.01 seconds       cpu time            0.01 seconds   So it converted col_1 to numeric, but seems to not like the format it's in? ... View more

Re: Variable will not reassign its value

by Quartz | Level 8 in SAS Programming
‎08-15-2018 02:40 PM
‎08-15-2018 02:40 PM
No, the log didn't list anything   13404 13405  data numprop; 13406 13407  col_1 = '5(25.0)'; 13408 13409  col_1a = put(col_1, 8.0); 13410 13411  run; NOTE: The data set WORK.NUMPROP has 1 observations and 2 variables. NOTE: DATA statement used (Total process time):       real time           0.01 seconds       cpu time            0.01 seconds I am going to play around with the put statement and see if I can figure it out. Thank you! ... View more

Re: Variable will not reassign its value

by Quartz | Level 8 in SAS Programming
‎08-15-2018 02:34 PM
‎08-15-2018 02:34 PM
I added this below code to ensure that col variables are equal to '0(0.0%)' and I checked, the col variables are character. I already tried changing them to numeric and still doesn't work after that is done.   data num_prop;    length rowlabel $100 col_1 col_2 col_3 col_4 $32 ;    rowlabel='    n (Proportion)';    col_1='0 (0.0%)';    col_2='0 (0.0%)';    col_3='0 (0.0%)';    col_4='';    roworder=3;    vorder=1; run; data num_prop;    set num_prop ;    comnum=1; run; proc sort; by comnum; run; data num_prop ;    retain rowlabel col_1 col_2 col_3 comnum ;    merge num_prop bignumber;    by comnum;    rowlabel=' n(Proportion)';    if col_1 = '0(0.0)' then col_1=cat(strip(put(col_1, 32.0)),' (', strip(put((col_1/bigcol1)*100,8.1)) ,'%)');    else col_1=col_1;    if col_2 = '0(0.0)' then col_2=cat(strip(put(col_2, 8.0)),' (', strip(put((col_2/bigcol2)*100,8.1)) ,'%)');    else col_2=col_2;    if col_3 = '0(0.0)' then col_3=cat(strip(put(col_3, 8.0)),' (', strip(put((col_3/bigcol3)*100,8.1)) ,'%)');    else col_3=col_3; vorder=1; roworder=3; run; ... View more

Re: Variable will not reassign its value

by Quartz | Level 8 in SAS Programming
‎08-15-2018 02:21 PM
‎08-15-2018 02:21 PM
I ran the test code and it works, it replaces col_1a with '5(25.0)' But I'm not sure what that tells me? That its not a problem with the variable, but the syntax in my code? Thanks for your help! ... View more

Re: Variable will not reassign its value

by Quartz | Level 8 in SAS Programming
‎08-15-2018 02:11 PM
‎08-15-2018 02:11 PM
Thank you for your help, for some reason, now, nothing is showing up for all the col variables.   7930   data num_prop ; 7931   retain rowlabel col_1 col_2 col_3 comnum ; 7932   merge num_prop bignumber; 7933   numcol_1=input(col_1,best32.); 7934   numcol_2=input(col_2,best32.); 7935   numcol_3=input(col_3,best32.); 7936   drop col_1 col_2 col_3; 7937   rename numcol_1=col_1 numcol_2=col_2 numcol_3=col_3; 7938      by comnum; 7939      rowlabel=' n(Proportion)'; 7940      if col_1 ne '0(0.0)' then col_1=cat(strip(put(col_1, 8.0)),' (', strip(put((col_1/bigcol1)*100,8.1)) ,'%)'); 7941      else col_1=col_1; 7942      if col_2 ne '0(0.0)' then col_2=cat(strip(put(col_2, 8.0)),' (', strip(put((col_2/bigcol2)*100,8.1)) ,'%)'); 7943      else col_2=col_2; 7944      if col_3 ne '0(0.0)' then col_3=cat(strip(put(col_3, 8.0)),' (', strip(put((col_3/bigcol3)*100,8.1)) ,'%)'); 7945      else col_3=col_3; 7946   vorder=1; 7947   roworder=3; 7948   run; NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).       7940:80   7942:80   7944:80 NOTE: Missing values were generated as a result of performing an operation on missing values.       Each place is given by: (Number of times) at (Line):(Column).       1 at 7940:85   1 at 7940:94   1 at 7942:85   1 at 7942:94   1 at 7944:85   1 at 7944:94 NOTE: There were 0 observations read from the data set WORK.NUM_PROP. NOTE: There were 1 observations read from the data set WORK.BIGNUMBER. NOTE: The data set WORK.NUM_PROP has 1 observations and 13 variables. NOTE: DATA statement used (Total process time):       real time           0.02 seconds       cpu time            0.01 seconds ... View more

Variable will not reassign its value

by Quartz | Level 8 in SAS Programming
‎08-15-2018 01:38 PM
‎08-15-2018 01:38 PM
Hi, I am trying to create a table with variables col_1, col_2, col_3, to be reassigned to the values below, but for some reason they only show up as (%) with no numbers assigned to them. I have checked my bigcol variables and they do have values. Any advice is appreciated!   data num_prop ;    retain rowlabel col_1 col_2 col_3 comnum ;    merge num_prop bignumber;    by comnum;    rowlabel=' n(Proportion)';    if col_1 ne '0(0.0)' then col_1=cat(strip(put(col_1, 8.0)),' (', strip(put((col_1/bigcol1)*100,8.1)) ,'%)');    else col_1=col_1;    if col_2 ne '0(0.0)' then col_2=cat(strip(put(col_2, 8.0)),' (', strip(put((col_2/bigcol2)*100,8.1)) ,'%)');    else col_2=col_2;    if col_3 ne '0(0.0)' then col_3=cat(strip(put(col_3, 8.0)),' (', strip(put((col_3/bigcol3)*100,8.1)) ,'%)');    else col_3=col_3; vorder=1; roworder=3; run; ... View more

Proc Report; Create a custom table

by Quartz | Level 8 in ODS and Base Reporting
‎08-13-2018 11:54 AM
‎08-13-2018 11:54 AM
Hi, I am trying to create a customized table based on simple analyses I completed in SAS and I am not sure how to create the custom column titles and row titles in the proc report statement. This is what I have so far and I have attached an image of what the top row should look like. The below code may be wrong, I just wasn't sure how else to go about it. Any advice is appreciated!    data row1;    length rowlabel $100 col_1 col_2 col_3 col_4 $32 ;    rowlabel='Aronchick Scored Bowel Cleansing - Insertion:';    col_1='ECP';    col_2='MoviPrep';    col_3='Total';    col_4='ECP-MoviPrep';    roworder=1;    run;   proc summary data=t2 nway completetypes;    class trt;    output out=BigN (drop=_type_ rename=(_freq_=bigN) index=(trt))/levels; run; proc transpose data=BigN out=bignumber;    var bign; run; data row2;    length rowlabel $100 col_1 col_2 col_3 col_4 $32 ;    set bignumber;    rowlabel='n';    col_1=strip(put(col1, 8.0));    col_2=strip(put(col2, 8.0));    col_3=strip(put(col3, 8.0));    roworder=2;    run;    proc freq Data=t2;    table trt*outcome;    exact binomial riskdiff;    output out=freq (keep=xl_rsk12 xu_rsk12 xl_rsk22 xu_rsk22 xl_rsk2 xu_rsk2      _rdif2_ xl_rdif2 xu_rdif2) riskdiff binomial; run; data row4;    length rowlabel $100 col_1 col_2 col_3 $32 ;    set freq;    rowlabel='    95% CI^{super 2}';    col_1='['||strip(put(xl_rsk12*100, 8.1))||'%, '||strip(put(xu_rsk12*100, 8.1))||'%]';    col_2='['||strip(put(xl_rsk22*100, 8.1))||'%, '||strip(put(xu_rsk22*100, 8.1))||'%]';    col_3='['||strip(put(xl_rsk22*100, 8.1))||'%, '||strip(put(xu_rsk22*100, 8.1))||'%]';    col_4='';    roworder=4; run;   data row5;    length rowlabel $100 col_1 col_2  col_3 col_4 $32 ;    set freq;    rowlabel='    Risk Difference (95% CI)^{super 3}';    col_4=strip(put(_rdif2_, 8.3))||' ['||strip(put(xl_rdif2, 8.3))||', '||strip(put(xu_rdif2, 8.3))||']';    col_1=''; col_2=''; col_3='';    roworder=5;  run;    data num_prop;  set t2;  comnum=1;  if rowlabel='SUCCESS';  rowlabel='        n (proportion)';  run; proc sort; by comnum; run; data bignumber_vorder; set bignumber; comnum=1; drop _name_; rename col1=bigcol1 col2=bigcol2 col3=bigcol3; run; data row3; retain rowlabel col_1 col_2 col_3 col_4; merge num_prop bignumber_vorder; by comnum; if col_1 ne '0(0.0)' then col_1=cat(strip(put(col_1,8.0)),' (', strip(put((col_1/bigcol1)*100,8.1)) ,'%)'); else col_1=col_1; if col_2 ne '0(0.0)' then col_2=cat(strip(put(col_2,8.0)),' (', strip(put((col_2/bigcol2)*100,8.1)) ,'%)'); else col_2=col_2; if col_3 ne '0(0.0)' then col_3=cat(strip(put(col_3,8.0)),' (', strip(put((col_3/bigcol3)*100,8.1)) ,'%)'); else col_3=col_3; col_4=' '; roworder=3; run; data all_vorder; set title num_prop row4 row5; run; data all_vorder; length rowlabel $100 col_1 col_2 col_3 col_4 $32; rowlabel='    n(Proportion)'; col_1='0 (0.0%)'; col_2='0 (0.0%)'; col_3='0 (0.0%)'; col_4=''; roworder=2; run; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎05-27-2021 02:24 PM
Likes given to
View All
Likes from
View All
Quick links