About user24

user24 · ‎03-22-2018

Hello, I am trying to export the sas table to text file. Running this code; DATA _NULL_; SET Final_Out; FILE "C:\SDB\ADMISStest\TEST.txt" LRECL=250 ; PUT @1 E1010 $7. @8 E1012 $10. @18 E1013 $3. @21 E1014 $10. @31 E101A $1. @32 E1008 $20. ; run; I created 'test' table in the area I want. And I have access that area. But I have this error when I run this code; ERROR: Insufficient authorization to access /app/config/Lev1/SASApp/C:\SDB\ADMISStest\TEST.txt. Thank you,

user24 · ‎04-11-2017

My date format is WORDDATE. August 25, 2015 i want to change as 08/25/2015

user24 · ‎04-07-2017

I have chracter variable. Also you can think like its left join . i only want to take if the work has variable and number doesn;t have variable. id work number 11 2 2 12 13 3 3 15 1 1-2 16 2 2-3 So i have the table without red variables. I want the table with red variables

user24 · ‎04-07-2017

if the 'number' is null and 'work' has variable, add that variable to the 'number' by 'id'. Is that clear?

user24 · ‎04-07-2017

How can i merge 2 variable if the one ofthem is null id work number 5 0 4 8 1 1-2 9 2 2-5 i want to change as if the number is null merge with 'work' id work number 5 0 0 4 8 1 1-2 9 2 2-5

user24 · ‎03-07-2017

The table i have as below: id term course ind 2 2016 ENC10 I 2 2017 ENC10 E 5 2010 MAT12 E 5 2012 MAT12 I 6 2011 STA11 E 6 2013 STA11 I 6 2015 STA11 E Table should be sot like this: proc sort data = work.a; by id course term;run; I neen only same id and course sort by term; last 'ind' should be 'E', first or second ind should be 'I' So the table should be like below id term course ind 2 2016 ENC10 I 2 2017 ENC10 E 6 2011 STA11 E 6 2013 STA11 I 6 2015 STA11 E

user24 · ‎03-02-2017

how can i remove if the character long not more than 4 or less than 4

user24 · ‎03-02-2017

How can i remove the data if the variable is not start with a letter. Should i type all the letter or any other short way variable A153 B124 0564 .1548 na w853 I want to keep only these variables. It should be 4 character long variable A153 B124 w853

user24 · ‎03-02-2017

i want to remove if the id has not duplicate, like as below. Thisis table example i have now id desc i 15 W100786 1 15 03/21/1970 2 20 K64478 1 20 02/14/1968 2 21 M157842 1 22 W250143 1 22 02/15/2000 2 i need the table as below: id desc i 15 W100786 1 15 03/21/1970 2 20 K64478 1 20 02/14/1968 2 22 W250143 1 22 02/15/2000 2 So i need to remove the id:21, because it doesn't have duplicate.

user24 · ‎02-01-2017

it takes only 2 variable.

user24 · ‎02-01-2017

data have; input id $ number $; datalines; 3 25 3 12 3 10 4 15 ;quit; data want; set have; length fst_val $20; retain fst_val; if first.id then fst_val=number; Else number=catx('-',fst_val,number); If last.id then output; run; Can you check the code, what is missing. Not working

user24 · ‎02-01-2017

yes, thats'a good question. Thank you. I modified my question

user24 · ‎02-01-2017

How can i put '-' between these 2 variable for same id id number code 3 25 a 3 12 a 3 10 a 4 15 a new table i need id number code 3 25-12-10 a 4 15 a

user24 · ‎01-31-2017

Thank you. It is close but not correct. For the OV2, total is not right.

user24 · ‎01-31-2017

I have table as below: For same id id class time OV 3 F 3 4 F 1 OV 4 F 3 OV 5 M 1 OV 6 F 1 I need to make the table as below; for the same id sum the time and make OV1 and OV2 id class time OV 3 F 3 4 F 4 OV1 4 F 4 OV2 5 M 1 OV 6 F 1

Online Status	Offline
Date Last Visited	‎04-09-2018 02:47 PM

How to export sas table to txt file

change date format worddate

Re: Merge 2 variables

Re: Merge 2 variables

Merge 2 variables

if first variable by another group

Re: Keep if start with letter

Keep if start with letter

Remove if the variable doesn't have duplicate

Re: Put "-" between 2 variable

Re: Transpose data

How to export sas table to txt file

change date format worddate

Re: Merge 2 variables

Re: Merge 2 variables

Merge 2 variables

if first variable by another group

Re: Keep if start with letter

Keep if start with letter

Remove if the variable doesn't have duplicate

Re: Put "-" between 2 variable

Re: Put "-" between 2 variable

Re: Put "-" between 2 variable

Put "-" between 2 variable

Re: Total for same observations

Total for same observations