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: 
mlogan
‎04-10-2025
  • 300 Posts
  • 117 Likes Given
  • 1 Solutions
  • 6 Likes Received

Re: Adding an empty row after each by group

by Lapis Lazuli | Level 10 in SAS Data Management
‎05-25-2019 01:21 PM
‎05-25-2019 01:21 PM
Hi Tom, I want to insert a blank space so that I can export it to excel from sas table without an extra step of PROC REPORT. ... View more

Re: Adding an empty row after each by group

by Lapis Lazuli | Level 10 in SAS Data Management
‎05-25-2019 12:12 PM
‎05-25-2019 12:12 PM
Thanks PGStats. It worked perfect. Would you be able to tell me what the code would be for flagging each by group with chronological number. I added some lines to your code, but I also count the black space. proc sort data=sashelp.class out=class; by sex age; run; data want; set class; by sex age; output; if last.age then do; call missing(of _all_); output; IF first.ID THEN count=1; ELSE count+1; end; ... View more

Adding an empty row after each by group

by Lapis Lazuli | Level 10 in SAS Data Management
‎05-24-2019 10:57 PM
1 Like
‎05-24-2019 10:57 PM
1 Like
Hi there, Can someone please tell me how to insert a blank line after each by group. Sorry I could not come up with any code but if you can write the code with sashelp.class table that would be great.   If it is not possible to do it on sas table please show me how to write that option during exporting to excel.    Thanks, ... View more

Re: Importing csv Text file with comma and double quote

by Lapis Lazuli | Level 10 in SAS Data Management
‎05-15-2019 11:30 AM
‎05-15-2019 11:30 AM
Hi Reeza, It did not work. Can you please write a working code for me. Thanks. ... View more

Importing csv Text file with comma and double quote

by Lapis Lazuli | Level 10 in SAS Data Management
‎05-15-2019 11:18 AM
‎05-15-2019 11:18 AM
Hi All, I tried to import data from a csv text file and failed to import successfully. Here is my code, can someone please help me with the correct code. Sample data file is attached.   Thank You.   proc import datafile="C:\2019_05_14\CanNCOA2_Results01.txt" out=Address.CanNCOA_Results dbms=csv; delimiter = ","; getnames=yes; guessingrows=100000; run; ... View more

Re: csv import with text qualifier

by Lapis Lazuli | Level 10 in SAS Data Management
‎02-24-2019 04:18 PM
‎02-24-2019 04:18 PM
Hi Tom, Thanks for your help, but I have 1000+ variables. So I really can't define them in data step, I mean it will be too much. Is there a easier way? ... View more

csv import with text qualifier

by Lapis Lazuli | Level 10 in SAS Data Management
‎02-24-2019 03:35 PM
1 Like
‎02-24-2019 03:35 PM
1 Like
I need to import a text file in csv format with text qualifiers. I tried PROC IMPORT but it didn't recognize the comma(,) as a delimiter in the file. Can anyone help me with the code for sas import that will take care of both the comma (as delimited) and text qualifier? Please note my data has " " where there is a missing variable. I will highly appreciate any help.   Here is how my data looks like:   KeyInd,Addr1,city,ID1,ID2, Name, Country Individual,"42nd Street","New York",09000033,04531-027-0031813," ", "United States" Individual,"9 Glen Echo Crt",Buffalo,04531-079-0035670,04531-027-0031819, "Joe Smith"," " Individual,"9 Glen Echo Crt",Buffalo,04531-079-0035670,04531-027-0031819, "Joe Smith",Canada ... View more

Re: Rename all variables at once

by Lapis Lazuli | Level 10 in SAS Programming
‎02-08-2019 11:04 AM
‎02-08-2019 11:04 AM
Hi ScottBass, Your code is giving me an error. Would you please find the error. I am getting the following error. Thanks. 164 PROC DATASETS LIB=work NOLIST; 165 MODIFY have; WARNING: Apparent invocation of macro LOOP not resolved. 166 RENAME %loop(&vars); - 22 76 NOTE: Enter RUN; to continue or QUIT; to end the procedure. ERROR 22-322: Expecting a name. ERROR 76-322: Syntax error, statement will be ignored. 167 RUN; NOTE: Statements not processed because of errors noted above. 168 QUIT; ... View more

Rename all variables at once

by Lapis Lazuli | Level 10 in SAS Programming
‎02-07-2019 10:34 PM
‎02-07-2019 10:34 PM
Hi there, I am trying to import data from a csv file and the only row I want to import is the first row. Following code is working, but I am getting my variable name as Var1, Var2, Var3 etc. Is there a way to name my variables as Var0001, Var0002, Var0003 during the import. I will appreciate any help on this.     OPTIONS obs=1; PROC IMPORT DATAFILE="C:\Test.csv" OUT=Want DBMS=csv REPLACE; GETNAMES=NO; DATAROW=1; RUN; ... View more

Increasing Variable name to more than 32 character

by Lapis Lazuli | Level 10 in SAS Data Management
‎02-04-2019 10:24 AM
‎02-04-2019 10:24 AM
Hi All, I am importing data from csv to Base sas. Some of the columns in csv is more than 32 characters and therefore can't read by PROC IMPORT properly. Is there a way to increase the length of variable so that sas can accomodate the whole length as it appears on the csv file.   Here is the code I was trying:   LIBNAME Apple 'C:\MyFolder'; OPTIONS FORMDLIM='_'; PROC IMPORT DATAFILE="C:\MyFolder\testfile.csv" OUT=Apple.Testfile DBMS=csv REPLACE; GETNAMES=YES; DATAROW=2; GUESSINGROWS=32000; RUN; ... View more

ODS PDF - Keeping PROC REPORT and GCHART on same page

by Lapis Lazuli | Level 10 in ODS and Base Reporting
‎10-20-2018 10:14 PM
‎10-20-2018 10:14 PM
  Hi All, I can't keep this table from PROC REPORT and barchart from GCHART in one page. Can anyone tell me how I can do that. On my ODS PDF output the small table from PROC REPORT stays in the first page, but the GCHART goes to the next page occupying the whole page. Here is the code I was trying:     %LET TITLE4 =Test; ODS PDF CLOSE; OPTIONS NODATE NONUMBER; ODS GRAPHICS / RESET=ALL; ODS PDF FILE='C:\\Rpt01.PDF' STARTPAGE=NO; OPTIONS(PAGEBREAK='NO') STYLE=EGDEFAULT; TITLE4 ls=1 font='helvetica/bold' height=12pt "&TITLE4."; PROC GCHART DATA=Apple.Prop_Master; WHERE Sol_RE_Title='Maritimes'; LABEL prop_status='Statuses'; VBAR Prop_Status / DISCRETE outside=PERCENT width=10 DESCENDING; RUN; QUIT; TITLE; PROC REPORT DATA=Apple.Sol_assign; WHERE Sol_RE_Title='Maritimes'; COLUMN Sol_RE_Title Count; DEFINE Sol_RE_Title / DISPLAY "Name"; DEFINE Count / DISPLAY "Portfolio Size"; RUN; TITLE; ODS _ALL_ CLOSE;   ... View more

ODS PDF - Keeping PROC REPORT and GCHART on same page

by Lapis Lazuli | Level 10 in ODS and Base Reporting
‎10-20-2018 10:12 PM
‎10-20-2018 10:12 PM
Hi All, I can't keep this table from PROC REPORT and barchart from GCHART in one page. Can anyone tell me how I can do that. On my ODS PDF output the small table from PROC REPORT stays in the first page, but the GCHART goes to the next page occupying the whole page. Here is the code I was trying:   %LET TITLE4 =Test; ODS PDF CLOSE; OPTIONS NODATE NONUMBER; ODS GRAPHICS / RESET=ALL; ODS PDF FILE='C:\\Rpt01.PDF' STARTPAGE=NO; OPTIONS(PAGEBREAK='NO') STYLE=EGDEFAULT; TITLE4 ls=1 font='helvetica/bold' height=12pt "&TITLE4."; PROC GCHART DATA=Apple.Prop_Master; WHERE Sol_RE_Title='Maritimes'; LABEL prop_status='Statuses'; VBAR Prop_Status / DISCRETE outside=PERCENT width=10 DESCENDING; RUN; QUIT; TITLE; PROC REPORT DATA=Apple.Sol_assign; WHERE Sol_RE_Title='Maritimes'; COLUMN Sol_RE_Title Count; DEFINE Sol_RE_Title / DISPLAY "Name"; DEFINE Count / DISPLAY "Portfolio Size"; RUN; TITLE; ODS _ALL_ CLOSE; ... View more

Re: by group with all missing value

by Lapis Lazuli | Level 10 in SAS Data Management
‎09-24-2018 09:39 AM
‎09-24-2018 09:39 AM
Thanks Novinorsin ... View more

by group with all missing value

by Lapis Lazuli | Level 10 in SAS Data Management
‎09-21-2018 01:35 PM
‎09-21-2018 01:35 PM
Hi All, I want to find all the by group observations where one of the specific variable is missing on all. Can anyone help please. Thanks.     data have; input Grade $1-7 ST_ID $9-11 Course $13-16 Score$17-18 date; informat date ddmmyy8.; format date date9.; cards; Grade10 101 Eng 20 01/01/82 Grade11 105 Bio 25 25/11/99 Grade11 105 Math18 23/09/00 Grade11 105 Eng 15 11/12/01 Grade11 105 Math15 14/12/05 Grade11 102 Eng 15 13/07/02 Grade11 102 Bio 20 22/11/07 Grade11 102 Phy 16 19/04/88 Grade11 102 Math21 27/08/99 Grade11 104 Arts13 18/06/00 Grade11 104 Che 12 14/07/09 Grade11 104 Eng 18 09/03/08 Grade11 104 Bio 21 25/11/13 Grade12 103 Bio 10 13/12/99 Grade12 103 Math20 25/05/01 Grade12 103 Eng 16 04/04/06 Grade12 103 15 09/11/02 Grade12 103 Phy 17 16/03/15 Grade12 106 17 14/03/16 Grade12 106 19 11/05/01 Grade12 106 10 13/12/99 ; RUN;     Expected Out put Table: Grade   St_ID Course  Score  Date Grade12 106                17        14/03/16 Grade12 106                19        11/05/01 Grade12 106                10        13/12/99   ... View more

Duplicate record by similarity score/closer value

by Lapis Lazuli | Level 10 in SAS Data Management
‎08-23-2018 03:22 PM
‎08-23-2018 03:22 PM
Hi All, I am looking for a code that will allow me to find duplicate based on exact as well as similar value. I know for exact value we can use NODUP, NODUPKEYS and NOUNIQUEKEYS. But can anyone tell me what function I can use to identify duplicate records based on similarity value.   Example: Following two records should be considered as duplicate though Last name and Address are not same (but they are similar).     First Name      Last Name  Address John                Murruy         1 New York St. John                Murray         1 New York Street    Thanks, ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎04-10-2025 02:32 PM
Likes given to
Quick links