How do i download files from intra company web in SAS, where i need to enter the ID, password and navigate to file and then download. Its a long question without any support. please help !
... View more
PROC SQL;
CREATE TABLE F1 AS
select RECORD, FRIST_PASS from F1 WHERE FRIST_PASS IS NOT NULL UNION ALL
select RECORD, SECOND_PASS from F1 WHERE SECOND_PASS IS NOT NULL UNION ALL
select RECORD, THIRD_PASS from F1 WHERE THIRD_PASS IS NOT NULL UNION ALL
select RECORD, FOURTH_PASS from F1 WHERE FOURTH_PASS IS NOT NULL;
QUIT;
Proc Freq data=F1;
tables First_pass; run; This worked for me !
... View more
That table was just for illustration purpose. Please ignore the name convention. For understanding purpose, i wrote it as 1st .. 2nd.. Can i work on an array function and count respective outcome from the array?
... View more
Please help ! I have the below table in SAS RECORD FIRST_PASS SECOND_PASS THIRD_PASS FOURTH_PASS 1234 R1 R3 R4 R5 5678 R3 R4 R5 9101 R3 R4 R5 1112 R2 R3 R4 R5 I need to summarize as below SUMMARY COUNT R1 1 R2 1 R3 4 R4 4 R5 4 Note - - R1, R2 are reason for pass. - Pass Reason appears only once for each record
... View more
data want;
set DMS.Dms1;
length newvar $100; /* Please adapt length as appropriate. */
newvar=catt(', ', of _A:);
run; Please Help ! I want to concatenate all the columns ending with _A in a table. I have more then 60 columns ending with _A in a table of 90 columns
... View more
Please Help ! I want to concatenate all the columns ending with _A in a table. I have more then 60 columns ending with _A in a table 90 columns
... View more