About Melvin_Sas

SuryaKiran · ‎04-17-2018

That might be because of your previously assigned Title, try clearing the titles by simply TITLE; This will clear all titles.

Reeza · ‎02-27-2018

That indicates that you do not have a well formed CSV file. You first need to figure out how many issues and what type of clean up you need to do. I would also try setting GUESSINGROWS=MAX and see if you get a slightly better results. If the variable happens to be at the end there are some workarounds you can try, but if it's in the middle its much harder.

PeterClemmensen · ‎12-20-2017

data _null_; input chardate:$10.; numdate=input(chardate, mmddyy10.); format numdate mmddyy10.; put numdate; datalines; 12/03/2016 11/29/2016 06/18/2014 ;

art297 · ‎05-24-2017

If you don't have multiple records for a given id and year that contain non-missing amounts, then the update statement would be your easiest solution. e.g.: data want; update have (obs=0) have; by id year; run; Art, CEO, AnalystFinder.com

Melvin_Sas · ‎05-04-2017

Ok thanks.

Ksharp · ‎04-21-2017

data b; set sashelp.class; stop; run; data a; set sashelp.class; run; data a(repempty=no); set b; run;

Melvin_Sas · ‎04-17-2017

Thanks Artc

Melvin_Sas · ‎04-13-2017

Ok thanks.

Online Status	Offline
Date Last Visited	‎04-17-2018 04:43 PM

Email body with embedded table from dataset

Proc import CSV with Comma in data

Convert string to date mmddyy10.

Remove duplicate in dataset

Re: How to icrease the record length in Filename Statement for email

How to icrease the record length in Filename Statement for email

Data Set options

Re: data and Macro

Re: data and Macro

data and Macro

Re: Email body with embedded table from dataset

Re: Convert string to date mmddyy10.

Re: Convert string to date mmddyy10.

Re: Convert string to date mmddyy10.

Re: Convert string to date mmddyy10.

Re: Email body with embedded table from dataset

Re: Proc import CSV with Comma in data

Re: Convert string to date mmddyy10.

Re: Remove duplicate in dataset

Re: How to icrease the record length in Filename Statement for email

Re: Data Set options

Re: data and Macro

Re: Infile and Macro