About NazaninSAS

NazaninSAS · ‎08-03-2018

Hi, I have the following table: col1 dis1 dis2 dis3 DIS VisCode Vis InCode In 1 2 3 Y 2 Y 3 6 Y 4 5 Y 5 5 Y 6 7 7 Y I want to write a code to return number of "Y"s for each column. For example the output should be something like this: DIS:3 Vis:1 In:2 I would appreciate your help. best regards, Nazanin

NazaninSAS · ‎08-03-2018

Hi Paul, This is what I figured it out: data updateSI2 ; set SINewCol ; if not missing (DIS1) or not missing(DIS2) or not missing (DIS3) or not missing (DIS4) or not missing (DIS5) or not missing (DIS6) or not missing(DIS7) or not missing(DIS8) or not missing(DIS9)then PWD = "Y"; if not missing (AborCode) then Abor="Y"; if not missing ( VisCode) then VisMin="Y" ; run ; now I'm working on making it shorter! best regards, Nazanin

NazaninSAS · ‎08-03-2018

Thanks a lot Paul, It works. If I want to update on the same dataset, is it possible? also if I have more than one column to update, can I do at the same time? so basically I want to expand the code to go from table one to table 2. col1 dis1 dis2 dis3 DIS VisCode Vis InCode In 1 2 3 2 3 6 4 5 5 5 6 7 7 col1 dis1 dis2 dis3 DIS VisCode Vis InCode In 1 2 3 Y 2 Y 3 6 Y 4 5 Y 5 5 Y 6 7 7 Y if I do each update separately, I lose the previous update. How can I do all together? Your help is much appreciated. best, Nazanin

NazaninSAS · ‎08-02-2018

col2 1 2 25 3 4 6 29 7 9 col2 1 2 25 Y 3 4 6 29 Y 7 9 I want to go from first data set to the second one. let's call the third column "col3" Thanks, Nazanin

NazaninSAS · ‎08-02-2018

no luck!! 😞

NazaninSAS · ‎08-02-2018

I tried both. no difference

NazaninSAS · ‎08-02-2018

49 465! ; NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. 467 data update; 468 set Sinewcol; 469 if DIS1 then PWD = 'Y '; 470 run;

NazaninSAS · ‎08-02-2018

This is what I have but it gives me error data update; set Sinewcol; if (DIS1) then PWD='Y'; run;

NazaninSAS · ‎08-02-2018

I don't want to use cards. what should I use instead?

NazaninSAS · ‎08-02-2018

I wrote this, but it doesn't work data Update; set SINewCol; if not missing(Col1) then Col2='Y'; run;

NazaninSAS · ‎08-02-2018

if there is value on Col1, I want to assign "Y" to Col2.

NazaninSAS · ‎08-02-2018

Col1 col2 1 2 25 Y 3 4 6 29 Y 7 9 Thanks, so I want to update Col2, when Col1 is not null.

NazaninSAS · ‎08-02-2018

Hi experts, in my dataset, I have a column with values and null. I need your guidance to write a code to check if there is no null, assign values to another column. For example, on C1, I have values, but I want to update my C2 where there is a value on C1. Thanks a lot for your help. Nazanin

NazaninSAS · ‎08-02-2018

I also tried call missing. it works perfectly. Thanks, Nazanin

NazaninSAS · ‎08-02-2018

this is my new code: data SelfID3WNewCoulm; set work.SelfID3; length f1 f2 f3 $4; f1=''; f2=''; f3=''; number=.; run;

Online Status	Offline
Date Last Visited	‎02-21-2020 08:15 PM

Excel output

Re: how to calculate percentage over total in Proc report

Re: how to calculate percentage over total in Proc report

Re: how to calculate percentage over total in Proc report

how to calculate percentage over total in Proc report

Re: conditional subtotal proc report

Re: conditional subtotal proc report

conditional subtotal proc report

Re: label variables on Proc report

Re: label variables on Proc report

Re: conditional subtotal proc report

Re: label variables on Proc report

Re: label variables on Proc report

Re: label variables on Proc report

Re: Do Loop

How to add blank colums to an existing dataset

Re: drop variables in proc report

Re: Do Loop

Count function in dataset

Re: update query

Re: update query

Re: update query

Re: update query

Re: update query

Re: update query

Re: update query

Re: update query

Re: update query

Re: update query

Re: update query

update query

Re: How to add blank colums to an existing dataset

Re: How to add blank colums to an existing dataset